public JsonResult put(Coustmer cous)
{
string query = @"
update dbo.Coustmer set
CoustmerName = '" + cous.CoustmerName + @"'
,Department = '" + cous.Department + @"'
,DateOfJoining = '" + cous.DateOfJioning + @"'
Where CoustmerId = " + cous.CoustmerId + @"
";
DataTable table = new DataTable();
string sqlDataSource = _configuration.GetConnectionString("CoustmerAppCon");
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(Coustmer cous)
{
string query = @"
insert into dbo.Coustmer
(CoustmerName,Department,DateOfJoining,PhotoFileName)
values
(
'" + cous.CoustmerName + @"'
,'" + cous.Department + @"'
,'" + cous.DateOfJioning + @"'
,'" + cous.PhotoFileName + @"'
)
";
DataTable table = new DataTable();
string sqlDataSource = _configuration.GetConnectionString("CoustmerAppCon");
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"));
}
