public string Post([FromBody] readUserData status)
{
freightOrderStatus e_status = new freightOrderStatus();
try
{
return(e_status.statusAdd(status));
//return "Success";
}
catch
{
return("Error");
}
}
public string Post([FromBody] readUserData enddata)
{
endpost e_endpost = new endpost();
try
{
return(e_endpost.endpost_Add(enddata));
//return "Success";
}
catch
{
return("Error");
}
}
public string statusAdd(readUserData status)
{
SqlConnection con = new SqlConnection("data source=bsspublic.database.windows.net; Initial catalog=HTW; user id=HTW; Password=u3Q9##X6&I;");
con.Open();
string Query = "update dbo.SmartLoadAppData set freightOrderId='" + status.freightOrderId + "',freightOrderStatus='" + status.freightOrderStatus + "',userId='" + status.userId + "',timestamp='" + status.timestamp + "' where freightOrderId='" + status.freightOrderId + "';";
try
{
SqlCommand com = new SqlCommand(Query, con);
com.ExecuteNonQuery();
return("Success");
}
catch
{
return("Error");
}
}
public string endpost_Add(readUserData enddata)
{
SqlConnection con = new SqlConnection("data source=bsspublic.database.windows.net; Initial catalog=HTW; user id=HTW; Password=u3Q9##X6&I;");
con.Open();
string Query = "update dbo.SmartLoadAppData set companyName='" + enddata.companyName + "',description='" + enddata.description + "',freightOrderStatus='" + enddata.freightOrderStatus + "',timestamp='" + enddata.timestamp + "', postalCode='" + enddata.postalCode + "', country='" + enddata.country + "',city='" + enddata.city + "',streetName='" + enddata.streetName + "',streetNumber='" + enddata.streetNumber + "',signatureTagPacker='" + enddata.signatureTagPacker + "',feedbackPacker='" + enddata.feedbackPacker + "',photoTagsPacker='" + enddata.photoTagsPacker + "',signatureTagDriver='" + enddata.signatureTagDriver + "',feedbackDriver='" + enddata.feedbackDriver + "',photoTagsDriver='" + enddata.photoTagsDriver + "',userId='" + enddata.userId + "' where freightOrderId='" + enddata.freightOrderId + "';";
try
{
SqlCommand com = new SqlCommand(Query, con);
com.ExecuteNonQuery();
return("Success");
}
catch
{
return("Error");
}
// return "s";
}
