public int Add_For_GeneralAct(PRPDBatchActivityDetails obj) { try { SqlParameter[] paramList = new SqlParameter[] { new SqlParameter("@PRPDBatchBatchActID", obj.PRPDBatchActivity), new SqlParameter("@SubActivity", obj.SubActivity), new SqlParameter("@ActivityDate", obj.ActivityDate), new SqlParameter("@StartTime", obj.StartTime), new SqlParameter("@StopTime", obj.StopTime), new SqlParameter("@StartQty", obj.StartQty), new SqlParameter("@StopQty", obj.StopQty), new SqlParameter("@SupervisedBy", obj.SupervisedBy), new SqlParameter("@Remarks", obj.Remarks), new SqlParameter("@PRPDBatchActDetailsID", obj.PRPDBatchActDetailsID)}; return Execute.RunSP_RowsEffected(Connection, "SPADD_PRPDBatchActivityDetailsGen", paramList); } catch (Exception ex) { throw new Exception(ex.Message, ex); } }
public int AddActWithMachine(PRPDBatchActivityDetails obj) { try { SqlParameter[] paramList = new SqlParameter[] { new SqlParameter("@PRPDBatchBatchActID", obj.PRPDBatchActivity), new SqlParameter("@SubActivity", obj.SubActivity), new SqlParameter("@ActivityDate", obj.ActivityDate), new SqlParameter("@StartTime", obj.StartTime), new SqlParameter("@StartQty", obj.StartQty), new SqlParameter("@SupervisedBy", obj.SupervisedBy), new SqlParameter("@Remarks", obj.Remarks), new SqlParameter("@NoOfTrays", obj.NoOfTrays), new SqlParameter("@WeightLoss", obj.WeightLoss), new SqlParameter("@ID", obj.PRPDBatchActDetailsID)}; return Execute.RunSP_RowsEffected(Connection, "SPADD_PRPDBatchActivityDetails", paramList); } catch (Exception ex) { throw new Exception(ex.Message, ex); } }
public int Update(PRPDBatchActivityDetails obj, long Original_PRPDBatchActDetailsID) { try { SqlParameter[] paramList = new SqlParameter[] { new SqlParameter("@PRPDBatchBatchActID", obj.PRPDBatchActivity), new SqlParameter("@SubActivity", obj.SubActivity), new SqlParameter("@ActivityDate", obj.ActivityDate), new SqlParameter("@StartTime", obj.StartTime), new SqlParameter("@StopTime", obj.StopTime), new SqlParameter("@StartQty", obj.StartQty), new SqlParameter("@StopQty", obj.StopQty), new SqlParameter("@SupervisedBy", obj.SupervisedBy), new SqlParameter("@Remarks",obj.Remarks), new SqlParameter("@Original_PRPDBatchActDetailsID", obj.PRPDBatchActDetailsID)}; return Execute.RunSP_RowsEffected(Connection, "SPUPDATE_PRPDBatchActivityDetails", paramList); } catch (Exception ex) { throw new Exception(ex.Message, ex); } }
public void Clear() { lblStopQty.Visible = false; // lblStopTime.Visible = false; // dtStopTime.Visible = false; txtStopQty.Visible = false; txtStopQty.Text = "0.00"; txtStartQty.Text = "0.00"; // txtComment.Text = ""; objPRPDBatchActivityDetails = null; }
public PRPDBatchActivityDetails Get(long PRPDBatchActivityDetailsID) { try { SqlParameter[] paramList = new SqlParameter[] { new SqlParameter("@PRPDBatchActDetailsID" , PRPDBatchActivityDetailsID)}; DataTable dt = Execute.RunSP_DataTable(Connection, "SPGET_PRPDBatchActivityDetailsByID", paramList); PRPDBatchActivityDetails obj = new PRPDBatchActivityDetails(); if (dt.Rows.Count > 0) { obj.PRPDBatchActDetailsID = Convert.ToInt64(dt.Rows[0]["PRPDBatchActDetailsID"]); obj.PRPDBatchActivity= objPRPDBatchActivity_DL.Get(Convert.ToInt64(dt.Rows[0]["PRPDBatchBatchActID"])); obj.SubActivity = Convert.ToString(dt.Rows[0]["SubActivity"]); obj.ActivityDate = Convert.ToDateTime(dt.Rows[0]["ActivityDate"]); obj.StartTime = Convert.ToDateTime(dt.Rows[0]["StartTime"]); obj.StopTime = Convert.ToDateTime(dt.Rows[0]["StopTime"]); obj.StartQty = Convert.ToDecimal(dt.Rows[0]["StartQty"]); obj.StopQty = Convert.ToDecimal(dt.Rows[0]["StopQty"]); obj.SupervisedBy = objEmployee_DL.Get(Convert.ToString(dt.Rows[0]["SupervisedBy"])); obj.Remarks = Convert.ToString(dt.Rows[0]["Remarks"]); obj.NoOfTrays = Convert.ToInt64(dt.Rows[0]["NoOfTrays"]); obj.WeightLoss = Convert.ToDecimal(dt.Rows[0]["WeightLoss"]); } return obj; } catch (Exception ex) { throw new Exception(ex.Message, ex); } }
public frmPRPDMachine(User objUser, PRPDBatchActivityDetails objPRPDBatchAcDetails) { CurrentUser = objUser; objPRPDBatchActivityDetails = objPRPDBatchAcDetails; InitializeComponent(); }
public frmPRPDLabour(User objUser, PRPDBatchActivityDetails objPRPDBatchAcDetails) { this.objPRPDBatchActivityDetails = objPRPDBatchAcDetails; CurrentUser = objUser; InitializeComponent(); }