public JsonResult Post(ImportLendet il)
{
string query = @"
insert into ImportLendet (Emer,Mbiemer,Lenda,Dega,VitiLenda,VitiStudent,
Paraleli,NrStudent,Kapur,Paradiplomim) values
('" + il.Emer + @"','" + il.Mbiemer + @"','" + il.Lenda + @"','" + il.Dega + @"',
'" + il.VitiLenda + @"','" + il.VitiStudent + @"','" + il.Paraleli + @"','" + il.NrStudent + @"',
'" + il.Kapur + @"','" + il.Paradiplomim + @"')";
DataTable table = new DataTable();
string sqlDataSource = _configuration.GetConnectionString("OrariAppCon");
SqlDataReader myReader;
using (SqlConnection myCon = new SqlConnection(sqlDataSource))
{
myCon.Open();
using (SqlCommand myCommand = new SqlCommand(query, myCon))
{
myReader = myCommand.ExecuteReader();
table.Load(myReader);;
myReader.Close();
myCon.Close();
}
}
return(new JsonResult("Shtuar me Sukses"));
}
public IHttpActionResult GetImportLendet(int id)
{
ImportLendet importLendet = db.ImportLendets.SingleOrDefault(m => m.Id == id);
if (importLendet == null)
{
return(NotFound());
}
return(Ok(importLendet));
}
public IHttpActionResult PostImportLendet(ImportLendet importLendet)
{
if (!ModelState.IsValid)
{
return(BadRequest(ModelState));
}
db.ImportLendets.Add(importLendet);
db.SaveChanges();
return(Ok(importLendet));
}
public IHttpActionResult DeleteImportLendet(int id)
{
ImportLendet importLendet = db.ImportLendets.Find(id);
if (importLendet == null)
{
return(NotFound());
}
db.ImportLendets.Remove(importLendet);
db.SaveChanges();
return(Ok(importLendet));
}
public HttpResponseMessage Update(ImportLendet ILtoUpdate)
{
try
{
ILtoUpdate.Update();
var res = Request.CreateResponse(HttpStatusCode.OK, "Modifikimi u krye me sukses!");
return(res);
}
catch (Exception ex)
{
var res = Request.CreateResponse(HttpStatusCode.BadRequest, "Gabimi: " + ex.Message);
return(res);
}
}
public HttpResponseMessage GetLendById(int id)
{
try
{
ImportLendet data = ImportLendet.GetByID(id);
var res = Request.CreateResponse(HttpStatusCode.OK, data);
return(res);
}
catch (Exception ex)
{
var res = Request.CreateResponse(HttpStatusCode.BadRequest, "Gabimi: " + ex.Message);
return(res);
}
}
public HttpResponseMessage GetLendet()
{
try
{
List <ImportLendet> data = ImportLendet.GetALL();
var res = Request.CreateResponse(HttpStatusCode.OK, data);
return(res);
}
catch (Exception ex)
{
var res = Request.CreateResponse(HttpStatusCode.BadRequest, "Gabimi: " + ex.Message);
return(res);
}
}
public IHttpActionResult PutImportLendet(int id, ImportLendet importLendet)
{
var updateImportLendet = db.ImportLendets.Where(x => x.Id == id).FirstOrDefault();
if (!ModelState.IsValid)
{
return(BadRequest(ModelState));
}
if (id != importLendet.Id)
{
return(BadRequest());
}
updateImportLendet.Id = importLendet.Id;
updateImportLendet.Dega = importLendet.Dega;
updateImportLendet.IdTipi = importLendet.IdTipi;
updateImportLendet.Lenda = importLendet.Lenda;
updateImportLendet.Kapur = importLendet.Kapur;
updateImportLendet.Paraleli = importLendet.Paraleli;
updateImportLendet.Pedagog = importLendet.Pedagog;
updateImportLendet.Tipi = importLendet.Tipi;
updateImportLendet.Viti = importLendet.Viti;
updateImportLendet.Zgjedhje = importLendet.Zgjedhje;
db.Entry(updateImportLendet).State = EntityState.Modified;
try
{
db.SaveChanges();
}
catch (DbUpdateConcurrencyException)
{
if (!ImportLendetExists(id))
{
return(NotFound());
}
else
{
throw;
}
}
return(StatusCode(HttpStatusCode.NoContent));
}
