public int ShiftOrder(clsModel_ShiftOrder data)
{
try
{
if (DbConnection())
{
try
{
Query = "insert into tbl_shiftorder values(@OrderId,@ShiftFrom,@QuantityOrdered,@ShiftTo,@Capacity,@QuantityInWarehouse)";
Cmd = new MySqlCommand(Query, Con);
Cmd.Parameters.AddWithValue("OrderId", data.OrderId);
Cmd.Parameters.AddWithValue("ShiftFrom", data.ShiftFrom);
Cmd.Parameters.AddWithValue("QuantityOrdered", data.QuantityOrdered);
Cmd.Parameters.AddWithValue("ShiftTo", data.ShiftTo);
Cmd.Parameters.AddWithValue("Capacity", data.Capacity);
Cmd.Parameters.AddWithValue("QuantityInWarehouse", data.QuantityInWarehouse);
Con.Open();
Cmd.ExecuteNonQuery();
Con.Close();
return(1);
//TempData["msg"] = "Submitted Successfully";
}
catch (Exception ex)
{
//TempData["msg"] = ex.ToString();
}
}
}
catch (Exception ex)
{
}
return(0);
}
public List <clsModel_ShiftOrder> BindTblData(string ID)
{
try
{
if (ID == null)
{
return(null);
}
int id = Convert.ToInt32(ID);
List <clsModel_ShiftOrder> lst = new List <clsModel_ShiftOrder>();
clsModel_ShiftOrder modelData = new clsModel_ShiftOrder();
if (DbConnection())
{
DataTable = new DataTable();
Query = "select * from tbl_shiftorder where OrderId =" + id + "";
Cmd = new MySqlCommand(Query, Con);
MySqlDataAdapter = new MySqlDataAdapter(Cmd);
MySqlDataAdapter.Fill(DataTable);
for (int i = 0; i < DataTable.Rows.Count; i++)
{
modelData.OrderId = Convert.ToInt32(DataTable.Rows[i]["OrderId"]);
modelData.ShiftFrom = DataTable.Rows[i]["ShiftFrom"].ToString();
modelData.QuantityOrdered = Convert.ToInt32(DataTable.Rows[i]["QuantityOrdered"]);
modelData.ShiftTo = DataTable.Rows[i]["ShiftTo"].ToString();
modelData.Capacity = Convert.ToInt32(DataTable.Rows[i]["Capacity"].ToString());
modelData.QuantityInWarehouse = Convert.ToInt32(DataTable.Rows[i]["QuantityInWarehouse"].ToString());
lst.Add(modelData);
}
return(lst);
}
}
catch (Exception ex)
{
}
return(null);
}
