public JsonResult Put(Aplikimet apliko)
{
string query = @"
update Aplikimet set
IdUser = '******',
Pushimi = '" + apliko.Pushimi + @"',
DataFillimit = '" + apliko.DataFillimit + @"',
DataMbarimit = '" + apliko.DataMbarimit + @"',
Pershkrimi = '" + apliko.Pershkrimi + @"',
Aprovimi = '" + apliko.Aprovimi + @"'
where Id = " + apliko.Id + @"
";
DataTable table = new DataTable();
string sqlDataSource = _configuration.GetConnectionString("ElavingApp");
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("Updated Successfully"));
}
public JsonResult Post(Aplikimet apliko)
{
string query = @"
insert into Aplikimet values
('" + apliko.IdUser + @"',
'" + apliko.Pushimi + @"',
'" + apliko.DataFillimit + @"',
'" + apliko.DataMbarimit + @"',
'" + apliko.Pershkrimi + @"',
'" + apliko.Aprovimi + @"')
";
DataTable table = new DataTable();
string sqlDataSource = _configuration.GetConnectionString("ElavingApp");
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("Added Successfully"));
}
