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