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