public RPDBatchActivityDetails Get(long RPDBatchActivityDetailsID)
{
MRPDataSetRPD dsMRP = new MRPDataSetRPD();
RPDBatch_DL objRPDBatch_DL = new RPDBatch_DL(Connection);
Employee_DL objEmployee_DL = new Employee_DL(Connection);
MainActivity_DL objMainActivity_DL = new MainActivity_DL(Connection);
Machine_DL objMachine_DL = new Machine_DL(Connection);
Material_DL objMaterial_DL = new Material_DL(Connection);
RPDBatchActivityDetails obj = new RPDBatchActivityDetails();
try
{
da.FillByID(dsMRP.tblRPDBatchActivityDetails, RPDBatchActivityDetailsID);
if (dsMRP.tblRPDBatchActivityDetails.Rows.Count > 0)
{
foreach (MRPDataSetRPD.tblRPDBatchActivityDetailsRow dr in dsMRP.tblRPDBatchActivityDetails)
{
obj.BatchActDetailsID = Convert.ToInt64(dr.BatchActDetailsID);
obj.Comments = dr.Comments;
obj.FinalQty = dr.FinalQty;
obj.Frequency = dr.Frequency;
obj.InitialVolume = dr.InitialVolume;
obj.LossQty = dr.LossQty;
obj.NoOfTrays = dr.NoOfTrays;
obj.RPDBatchActID = Convert.ToInt64(dr.RPDBatchActID);
obj.SieveSize = dr.SieveSize;
obj.StartQty = dr.StartQty;
obj.StartTime = dr.StartTime;
obj.StopQty = dr.StopQty;
obj.StopTime = dr.StopTime;
obj.SupervisedBy = dr.SupervisedBy;
}
return(obj);
}
return(null);
}
catch (Exception ex)
{
throw new Exception(ex.Message, ex);
}
finally
{
dsMRP.Dispose();
objRPDBatch_DL = null;
objEmployee_DL = null;
objMainActivity_DL = null;
objMachine_DL = null;
}
}
private void Clear()
{
txtComment.Text = "";
txtFinalQty.Text = "0.00";
txtFrequency.Text = "0.00";
txtinitialVol.Text = "0.00";
txtLossQty.Text = "0.00";
txtNoOfTrays.Text = "0.00";
txtSieveSize.Text = "";
txtStartQty.Text = "0.00";
txtStopQty.Text = "0.00";
dtStartTime.Value = Convert.ToDateTime("7/15/2009 8:00 AM");
dtStopTime.Value = Convert.ToDateTime("7/15/2009 5:00 PM");
objRPDBatchActivityDetails = null;
lblStop.Visible = false;
dtStopTime.Visible = false;
btnDelete.Visible = false;
lblStopQty.Visible = false;
txtStopQty.Visible = false;
}
public long Add(RPDBatchActivityDetails obj)
{
try
{
Decimal?RETID = null;
int res = da.SPADD_RPDBatchActivityDetails_Update(
obj.BatchActDetailsID,
obj.RPDBatchActID,
obj.StartQty,
obj.StopQty,
obj.StartTime,
obj.StopTime,
obj.Frequency,
obj.InitialVolume,
obj.FinalQty,
obj.LossQty,
obj.SieveSize,
obj.Comments,
obj.NoOfTrays,
obj.SupervisedBy,
ref RETID);
if (res > 0)
{
return(Convert.ToInt64(RETID.Value));
}
return(0);
}
catch (Exception ex)
{
throw new Exception(ex.Message, ex);
}
finally
{
da.Dispose();
}
}
public frmActivityDetailsLabour(User objUser, RPDBatchActivityDetails objRPDBatchAcDetails)
{
objRPDBatchActivityDetails = objRPDBatchAcDetails;
CurrentUser = objUser;
InitializeComponent();
}
public frmActivityDetailsMachine(User objUser, RPDBatchActivityDetails objRPDBatchAcDetails)
{
CurrentUser = objUser;
objRPDBatchActivityDetails = objRPDBatchAcDetails;
InitializeComponent();
}