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