SQL
create database [3020_Integralni]
use [3020_Integralni]

create table Brendovi (
    BrendId int primary key IDENTITY(1,1),
    ImeBrenda NVARCHAR(100) NOT NULL
)
create table Uredjaji (
    UredjajId int primary key IDENTITY(1,1),
    BrendId int foreign key references Brendovi(BrendId),
    SerijskiBroj NVARCHAR(100) NOT NULL,
    PodGarancijom bit
)

create table Servisi (
    ServisId int primary key IDENTITY(1,1),
    UredjajId int foreign key references Uredjaji(UredjajId),
    DatumPrijema Date NOT NULL,
    OpisKvara NVARCHAR(250) NOT NULL,
    ZavrsenServis bit
)

insert into Brendovi
values ('Apple')


SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
CREATE PROCEDURE spAddNewService
    @BrendId int,
    @SerijskiBroj NVARCHAR(100),
    @PodGarancijom bit,
    @DatumPrijema date,
    @OpisKvara NVARCHAR(250),
    @ZavrsenServis bit
AS
BEGIN
    INSERT INTO Uredjaji
    VALUES(@BrendId, @SerijskiBroj,@PodGarancijom);
    INSERT INTO Servisi
    VALUES(@@IDENTITY, @DatumPrijema, @OpisKvara, @ZavrsenServis);
END
GO

SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
CREATE PROCEDURE spGetServices
AS
BEGIN
    SELECT CONVERT(VARCHAR(10), S.DatumPrijema, 104) as DatumPrijema,                      U.SerijskiBroj, S.OpisKvara, S.ZavrsenServis
    FROM Servisi as S join Uredjaji as U on
    S.UredjajId=U.UredjajId join Brendovi as B on
    U.BrendId = B.BrendId
order by S.DatumPrijema DESC
END
GO






DAServisi.cs

using System;
using System.Collections.Generic;
using System.Linq;
using System.Text;
using System.Threading.Tasks;

namespace DAServisi
{
    public class DAServisi
    {
        public static List<spGetServices_Result> GetServices()
        {
            using (Entities s = new Entities())
            {
                return s.spGetServices().ToList();
            }
        }
        public static void InsertService(int? brendId, string serijskiBroj, bool? podGarancijom,      DateTime? datumPrijema, string opisKvara, bool? zavrsenServis)
        {
            using (Entities s = new Entities())
            {
                s.spAddNewService(brendId, serijskiBroj, podGarancijom, datumPrijema, opisKvara, zavrsenServis);
            }
        }
    }
}
















Servisi.aspx
<%@ Page Language="C#" AutoEventWireup="true" CodeBehind="Servisi.aspx.cs" Inherits="WT_Integralni_ispit_3020NEWWW.Servisi" %>

<!DOCTYPE html>

<html xmlns="http://www.w3.org/1999/xhtml">
<head runat="server">
    <title></title>
    <link href="style.css" rel="stylesheet" />
</head>
<body>
    <form id="form1" runat="server">
    <div>
        <h1>Novi servis:</h1>
        <asp:Label ID="Label1" runat="server" Text="Brend:"></asp:Label>
        <asp:DropDownList ID="brendoviList" runat="server" DataSourceID="SqlDataSource1" DataTextField="ImeBrenda" DataValueField="BrendId"></asp:DropDownList>
        <asp:SqlDataSource ID="SqlDataSource1" runat="server" ConnectionString="<%$ ConnectionStrings:3020_IntegralniConnectionString %>" SelectCommand="SELECT [BrendId], [ImeBrenda] FROM [Brendovi]"></asp:SqlDataSource>
        <br />
        <asp:Label ID="Label2" runat="server" Text="Serijski broj:"></asp:Label>
        <asp:TextBox ID="serijskiBroj" runat="server"></asp:TextBox>
        <br />
        <asp:Label ID="Label3" runat="server" Text="Pod garancijom: "></asp:Label>
        <asp:CheckBox ID="podGarancijom" runat="server" Checked="true" />
        <h2>Uredjaj:</h2>
        <asp:Label ID="Label4" runat="server" Text="Datum prijema: "></asp:Label>
        <asp:Calendar ID="Calendar1" runat="server" ></asp:Calendar>
        <br />
        <asp:Label ID="Label5" runat="server" Text="Opis kvara:"></asp:Label>
        <asp:TextBox ID="opisKvara" runat="server" TextMode="MultiLine"></asp:TextBox>
        <br />
        <asp:Button ID="Button1" runat="server" Text="Posalji" OnClick="Button1_Click" OnClientClick="return validate();" />
        <h1>Servisi:</h1>
        <asp:GridView ID="GridView1" runat="server" AutoGenerateColumns="False" DataSourceID="SqlDataSource2">
            <Columns>
                <asp:BoundField DataField="DatumPrijema" HeaderText="DatumPrijema" SortExpression="DatumPrijema" />
                <asp:BoundField DataField="SerijskiBroj" HeaderText="SerijskiBroj" SortExpression="SerijskiBroj" />
                <asp:BoundField DataField="OpisKvara" HeaderText="OpisKvara" SortExpression="OpisKvara" />
                <asp:CheckBoxField DataField="ZavrsenServis" HeaderText="ZavrsenServis" SortExpression="ZavrsenServis" />
            </Columns>
        </asp:GridView>
        <asp:SqlDataSource ID="SqlDataSource2" runat="server" ConnectionString="<%$ ConnectionStrings:3020_IntegralniConnectionString %>" SelectCommand="spGetServices" SelectCommandType="StoredProcedure"></asp:SqlDataSource>
    </div>
    </form>
    <script src="validation.js"></script>
</body>
</html>

Servisi.aspx.cs
using System;
using System.Collections.Generic;
using System.Linq;
using System.Web;
using System.Web.UI;
using System.Web.UI.WebControls;
using DAServisi;

namespace WT_Integralni_ispit_3020NEWWW
{
    public partial class Servisi : System.Web.UI.Page
    {
        protected void Page_Load(object sender, EventArgs e)
        {
            if (!IsPostBack)
            {
            }
        }

        protected void Button1_Click(object sender, EventArgs e)
        {
            if (Calendar1.SelectedDate == DateTime.MinValue)
                Response.Write("Select date !");
            else {
                DAServisi.DAServisi.InsertService(Convert.ToInt32(brendoviList.SelectedValue), serijskiBroj.Text, podGarancijom.Checked, Calendar1.SelectedDate, opisKvara.Text
                    , false);
                GridView1.DataBind();
            }
        }
    }
}
Style.css
.error{
    border:1px solid red;
}

Validation.js
function validate() {
    var valid = true;
    var brend = document.getElementById("brendoviList");
    var serijskiBroj = document.getElementById("serijskiBroj");
    var datumPrijema = document.getElementById("Calendar1");
    var opisKvara = document.getElementById("opisKvara");
    if (brend.selectedIndex == 0) {
        brend.className = "error";
        valid = false;
    }
    else
        brend.className = "";

    if (serijskiBroj.value == "") {
        serijskiBroj.className = "error";
        valid = false;
    }
    else
        serijskiBroj.className = "";

    if (opisKvara.value.length <20) {
        opisKvara.className = "error";
        valid = false;
    }
    else
        opisKvara.className = "";

    return valid;
}