public RPDActivityDetailsMachine Get(long ID)
{
try
{
SqlParameter[] paramList = new SqlParameter[] {
new SqlParameter("@ActivityDetailsMachineID", ID)
};
DataTable dt = Execute.RunSP_DataTable(Connection, "SPGET_RPDActivityDetailsMachine_By_ID", paramList);
RPDActivityDetailsMachine obj = new RPDActivityDetailsMachine();
if (dt.Rows.Count > 0)
{
obj.ActivityDetailsMachineID = Convert.ToInt64(dt.Rows[0]["ActivityDetailsMachineID"]);
obj.BatchActID = Convert.ToInt64(dt.Rows[0]["BatchActID"]);
obj.Description = Convert.ToString(dt.Rows[0]["Description"]);
obj.MachineCode = Convert.ToString(dt.Rows[0]["MachineCode"]);
obj.MeshSize = Convert.ToString(dt.Rows[0]["MeshSize"]);
obj.StartTime_D = Convert.ToDateTime(dt.Rows[0]["StartTime"]);
obj.StopTime_D = Convert.ToDateTime(dt.Rows[0]["StopTime"]);
obj.HourlyRate = Convert.ToDecimal(dt.Rows[0]["HourlyRate"]);
}
return(obj);
}
catch (Exception ex)
{
throw new Exception(ex.Message, ex);
}
}
private void ClearForm()
{
txtDescription.Text = "";
txtFinalQty.Text = "0.00";
if (cmbMachine.Items.Count > 0)
{
cmbMachine.SelectedIndex = 0;
}
txtMeshSizeGRN.Text = "0.00";
txtRemarks.Text = "";
txtStartQtyGRN.Text = "0.00";
dtpMachineStartGRN.Value = Convert.ToDateTime("7/15/2009 8:00 AM");
txtStopQtyGRN.Text = "0.00";
dtpMachineStopGRN.Value = Convert.ToDateTime("7/15/2009 5:00 PM");
objRPDActivityDetailsMachine = null;
btnDelete.Enabled = false;
bindMachines.DataSource = objRPDActivityDetailsMachineDL.Get_By_BatchActDetails_View(objRPDBatchActivityDetails.BatchActDetailsID);
dtStopDate.Value = DateTime.Now;
dtStartDate.Value = DateTime.Now;
lblStop.Visible = false;
lblStopMachine.Visible = false;
lbStopQty.Visible = false;
dtpMachineStopGRN.Visible = false;
dtStopDate.Visible = false;
txtStopQtyGRN.Visible = false;
}
private void txtMachineStop_KeyDown(object sender, KeyEventArgs e)
{
if (e.KeyCode == Keys.Enter)
{
try
{
if (objRPDBatchActivity.ActivityStatus == RPDBatchActivity.Status.Finalized)
{
MessageBox.Show(this, "Activity is already Finished", "Wrong Attempt", MessageBoxButtons.OK);
txtMachineStart.Text = "";
txtMachineStop.Text = "";
}
else
{
RPDActivityDetailsMachine obj = new RPDActivityDetailsMachine();
obj.BatchActID = RPDBatchActivityID;
obj.StartTime = txtMachineStart.Text;
obj.StopTime = txtMachineStop.Text;
obj.Description = "No";
obj.MachineCode = cmbMachine.SelectedValue.ToString();
obj.MeshSize = "N/A";
objRPDActivityDetailsMachine_DL.Add(obj);
Load_Machine_List();
txtMachineStart.Text = "";
txtMachineStop.Text = "";
//SetColors();
}
}
catch (Exception)
{
MessageBox.Show(this, "Error occured while loading Machine Details", "Error", MessageBoxButtons.OK, MessageBoxIcon.Warning);
txtMachineStart.Text = "";
txtMachineStop.Text = "";
cmbMachine.Select();
}
}
}
public long Add(RPDActivityDetailsMachine obj)
{
try
{
SqlParameter[] paramList = new SqlParameter[] {
new SqlParameter("@BatchActID", obj.BatchActID),
new SqlParameter("@Description", obj.Description),
new SqlParameter("@MachineCode", obj.MachineCode),
new SqlParameter("@MeshSize", obj.MeshSize),
new SqlParameter("@StartTime", obj.StartTime),
new SqlParameter("@StopTime", obj.StopTime),
new SqlParameter("@outParam", obj.ActivityDetailsMachineID)
};
return(Execute.RunSP_Output(Connection, "SPADD_RPDActivityDetailsMachine", paramList));
}
catch (Exception ex)
{
throw new Exception(ex.Message, ex);
}
}
