public static dynamic UpdateStatus(ProductsOrder dto)
{
DataTable tabl = ConnectDb.ExecuteDataTableTask(Startup.ConnectionString, "SP_ProductsOrder",
new string[] { "@flag", "@Id", "@Status", "@ModifiedBy" },
new object[] { "UpdateStatus", dto.Id, dto.Status, dto.ModifiedBy });
return((from r in tabl.AsEnumerable()
select new
{
N = (int)(r["N"]),
}).FirstOrDefault());
}
public static dynamic SaveItem(ProductsOrder dto)
{
DataTable tabl = ConnectDb.ExecuteDataTableTask(Startup.ConnectionString, "SP_ProductsOrder",
new string[] { "@flag", "@Id", "@Name", "@Phone", "@Email", "@Address", "@Description", "@Status" },
new object[] { "SaveItem", dto.Id, dto.Name, dto.Phone, dto.Email, dto.Address, dto.Description, dto.Status });
return((from r in tabl.AsEnumerable()
select new
{
N = (int)(r["N"]),
}).FirstOrDefault());
}
