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