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")); }