private void ClearForm()
{
//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");
objPRPDActivityDetailsMachine = null;
btnDelete.Enabled = false;
bindMachines.DataSource = objPRPDActivityDetailsMachineDL.GetDataView(objPRPDBatchActivityDetails.PRPDBatchActDetailsID);
dtStopDate.Value = DateTime.Now;
dtStartDate.Value = DateTime.Now;
lblMachineStop.Visible = false;
lblStopDate.Visible = false;
lblStopQty.Visible = false;
dtpMachineStopGRN.Visible = false;
dtStopDate.Visible = false;
txtStopQtyGRN.Visible = false;
}
public PRPDActivityDetailsMachine Get(long ActivityDetailsMachineID)
{
try
{
SqlParameter[] paramList = new SqlParameter[] {
new SqlParameter("@ActivityDetailsMachineID", ActivityDetailsMachineID)
};
DataTable dt = Execute.RunSP_DataTable(Connection, "SPGET_PRPDActivityMachineByID", paramList);
PRPDActivityDetailsMachine obj = new PRPDActivityDetailsMachine();
if (dt.Rows.Count > 0)
{
obj.ActivityDetailsMachineID = Convert.ToInt64(dt.Rows[0]["ActivityDetailsMachineID"]);
obj.PRPDBatchActDetailsID = Convert.ToInt64(dt.Rows[0]["BatchActID"]);
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.Remarks = Convert.ToString(dt.Rows[0]["Remarks"]);
}
return(obj);
}
catch (Exception ex)
{
throw new Exception(ex.Message, ex);
}
}
private void txtMachineStop_KeyDown(object sender, KeyEventArgs e)
{
if (e.KeyCode == Keys.Enter)
{
try
{
if (objPRPDBatchActivity.State == PRPDBatchActivity.ActStatus.Finished)
{
MessageBox.Show(this, "Activity is already Finished", "Wrong Attempt", MessageBoxButtons.OK);
txtMachineStart.Text = "";
txtMachineStop.Text = "";
}
else
{
PRPDActivityDetailsMachine obj = new PRPDActivityDetailsMachine();
obj.PRPDBatchActDetailsID = PRPDBatchActivityID;
obj.StartTime = txtMachineStart.Text;
obj.StopTime = txtMachineStop.Text;
obj.Remarks = "No";
obj.MachineCode = cmbMachine.SelectedValue.ToString();
obj.MeshSize = "N/A";
objPRPDActivityDetailsMachine_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 int Add(PRPDActivityDetailsMachine obj)
{
try
{
SqlParameter[] paramList = new SqlParameter[] {
new SqlParameter("@BatchActID", obj.PRPDBatchActDetailsID),
new SqlParameter("@MachineCode", obj.MachineCode),
new SqlParameter("@MeshSize", obj.MeshSize),
new SqlParameter("@StartTime", obj.StartTime),
new SqlParameter("@StopTime", obj.StopTime),
new SqlParameter("@Remarks", obj.Remarks)
};
return(Execute.RunSP_Int(Connection, "SPADD_PRPDActivityDetailsMachine", paramList));
}
catch (Exception ex)
{
throw new Exception(ex.Message, ex);
}
}
public int Update(PRPDActivityDetailsMachine obj, long Original_ActivityDetailsMachineID)
{
try
{
SqlParameter[] paramList = new SqlParameter[] {
new SqlParameter("@BatchActID", obj.PRPDBatchActDetailsID),
new SqlParameter("@MachineCode", obj.MachineCode),
new SqlParameter("@MeshSize", obj.MeshSize),
new SqlParameter("@StartTime", obj.StartTime),
new SqlParameter("@StopTime", obj.StopTime),
new SqlParameter("@Remarks", obj.Remarks),
new SqlParameter("@Original_ActivityDetailsMachineID", obj.ActivityDetailsMachineID)
};
return(Execute.RunSP_RowsEffected(Connection, "SPUPDATE_PRPDActivityDetailsMachine", paramList));
}
catch (Exception ex)
{
throw new Exception(ex.Message, ex);
}
}
