public IHttpActionResult GetLabVezba(int id)
{
using (BAZAEntities db = new BAZAEntities())
{
var lab_vezbaDB = db.LAB_VEZBA.FirstOrDefault(x => x.ID == id);
if (lab_vezbaDB == null)
{
return(BadRequest());
}
var s = new LabVezba
{
ID = lab_vezbaDB.ID,
tag = lab_vezbaDB.tag,
naziv = lab_vezbaDB.naziv
};
return(Json(s));
}
//string query = @"
// select tag, naziv from
// dbo.LAB_VEZBA where ID=" + id + @"
// ";
//DataTable table = new DataTable();
//using (var con = new SqlConnection(ConfigurationManager.
// ConnectionStrings["AppDB"].ConnectionString))
//using (var cmd = new SqlCommand(query, con))
//using (var da = new SqlDataAdapter(cmd))
//{
// cmd.CommandType = CommandType.Text;
// da.Fill(table);
//}
//return Request.CreateResponse(HttpStatusCode.OK, table);
}
public string Post(LabVezba lv)
{
try
{
db.LabVezba.Add(lv);
db.SaveChanges();
return("Added Successfully!!");
}
catch (Exception)
{
return("Failed to Add!!");
}
}
public string Put(LabVezba lv)
{
try
{
using (BAZAEntities db = new BAZAEntities())
{
var lab_vezbaDB = db.LAB_VEZBA.FirstOrDefault(x => x.ID == lv.ID);
lab_vezbaDB.tag = lv.tag;
lab_vezbaDB.naziv = lv.naziv;
db.SaveChanges();
}
return("Updated Successfully!!");
}
catch (Exception)
{
return("Failed to Update!!");
}
//try
//{
// string query = @"
// update dbo.LAB_VEZBA set tag=
// '" + lv.tag + @"', naziv='" + lv.naziv + @"'
// where ID=" + lv.ID + @"
// ";
// DataTable table = new DataTable();
// using (var con = new SqlConnection(ConfigurationManager.
// ConnectionStrings["AppDB"].ConnectionString))
// using (var cmd = new SqlCommand(query, con))
// using (var da = new SqlDataAdapter(cmd))
// {
// cmd.CommandType = CommandType.Text;
// da.Fill(table);
// }
// return "Updated Successfully!!";
//}
//catch (Exception)
//{
// return "Failed to Update!!";
//}
}
public IActionResult GetLabVezba(int id)
{
var lab_vezbaDB = db.LabVezba.FirstOrDefault(x => x.Id == id);
if (lab_vezbaDB == null)
{
return(BadRequest());
}
var s = new LabVezba
{
Id = lab_vezbaDB.Id,
Tag = lab_vezbaDB.Tag,
Naziv = lab_vezbaDB.Naziv
};
return(Ok(s));
}
public string Put(LabVezba lv)
{
try
{
var lab_vezbaDB = db.LabVezba.FirstOrDefault(x => x.Id == lv.Id);
lab_vezbaDB.Tag = lv.Tag;
lab_vezbaDB.Naziv = lv.Naziv;
db.SaveChanges();
return("Updated Successfully!!");
}
catch (Exception)
{
return("Failed to Update!!");
}
}
public IActionResult PostMultipleRaspored([FromBody] RasporedFromCsv[] data)
{
try
{
foreach (var raspored in data)
{
var student = db.Student.FirstOrDefault(x => x.Indeks == raspored.Indeks);
if (student is null && raspored.Indeks.HasValue)
{
student = new Student()
{
Indeks = raspored.Indeks,
Ime = raspored.Ime,
Prezime = raspored.Prezime,
Username = raspored.Email
};
db.Student.Add(student);
}
var lab = db.LabVezba.FirstOrDefault(x => x.Naziv == raspored.NazivLabVezbe && !string.IsNullOrEmpty(raspored.NazivLabVezbe));
if (lab is null)
{
lab = new LabVezba
{
Naziv = raspored.NazivLabVezbe,
Tag = raspored.Tag
};
db.LabVezba.Add(lab);
}
var specificna = db.LabSpecificna.FirstOrDefault(x => x.IdLabVezbeNavigation.Naziv == raspored.NazivLabVezbe && x.Redosled == raspored.LabVezba);
if (specificna is null)
{
specificna = new LabSpecificna
{
Redosled = raspored.LabVezba,
IdLabVezbeNavigation = lab
};
db.LabSpecificna.Add(specificna);
}
var rasporedDB = db.Raspored.FirstOrDefault(x => (student == null || x.Student == student.Id) && x.LabVezba == specificna.Id);
if (rasporedDB is null)
{
rasporedDB = new Raspored
{
LabVezbaNavigation = specificna,
PocetakLaba = raspored.Pocetak,
StudentNavigation = student,
Ucionica = raspored.Ucionica,
ZavrsetakLaba = raspored.Kraj
};
db.Raspored.Add(rasporedDB);
}
else
{
rasporedDB.PocetakLaba = raspored.Pocetak;
rasporedDB.ZavrsetakLaba = raspored.Kraj;
rasporedDB.Izmenjen = true;
}
}
db.SaveChanges();
return(Ok());
}
catch (Exception ex)
{
return(BadRequest());
}
}
