public BatchLabourDetails Get(long LabourActID) { try { SqlParameter[] paramList = new SqlParameter[] { new SqlParameter("@LabourRecID", LabourActID) }; DataTable dt = Execute.RunSP_DataTable(Connection, "SPGET_BatchLaourDetails", paramList); BatchLabourDetails obj = new BatchLabourDetails(); BatchActivity_DL objBatchActivity_DL = new BatchActivity_DL(ConnectionStringClass.GetConnection()); Employee_DL objEmployee_DL = new Employee_DL(ConnectionStringClass.GetConnection()); if (dt.Rows.Count != 0) { obj.BatchAct = objBatchActivity_DL.GetByID(Convert.ToInt32(dt.Rows[0]["BatchActID"])); obj.Emp = objEmployee_DL.Get(Convert.ToString(dt.Rows[0]["EmployeeID"])); obj.HourlyRate = Convert.ToDecimal(dt.Rows[0]["HourlyRate"]); obj.LabourRecID = Convert.ToInt32(dt.Rows[0]["LabourRecID"]); obj.OTHours = Convert.ToDecimal(dt.Rows[0]["OTHours"]); obj.OTRate = Convert.ToDecimal(dt.Rows[0]["OTRate"]); obj.WorkStart_Date = Convert.ToDateTime(dt.Rows[0]["WorkStart"]); obj.WorkStop_Date = Convert.ToDateTime(dt.Rows[0]["WorkStop"]); } return(obj); } catch (Exception ex) { throw new Exception(ex.Message, ex); } }
private void dgvBatchLabourDetails_KeyDown(object sender, KeyEventArgs e) { if (e.KeyCode == Keys.Delete) { DialogResult theResult = new DialogResult(); theResult = MessageBox.Show(this, "Do you Want to Delete this Record", "Confirmation", MessageBoxButtons.YesNo); if (theResult == System.Windows.Forms.DialogResult.Yes) { if (objPRPDBatchActivity.State == PRPDBatchActivity.ActStatus.Finished) { MessageBox.Show(this, "This Activity Is Finished.", "Wrong Attempt", MessageBoxButtons.OK); } else { BatchLabourDetails obj = new BatchLabourDetails(); objPRPDActivityDetailsLabour_DL.Delete(Convert.ToInt32(dgvBatchLabourDetails.CurrentRow.Cells["LabourRecID"].Value)); Load_Labour_List(); } } } }
private void txtOTMinutes_KeyDown(object sender, KeyEventArgs e) { if (e.KeyCode == Keys.Enter) { if (e.KeyCode == Keys.Enter) { try { Decimal OTHours = 0; Decimal OTMinutes = 0; if (txtOT.Text != "") { OTHours = Convert.ToDecimal(txtOT.Text); } if (txtOTMinutes.Text != "") { OTMinutes = Convert.ToDecimal(txtOTMinutes.Text); } BatchLabourDetails obj = new BatchLabourDetails(); obj.BatchAct = objBatchActivity; obj.Emp = objEmployee_DL.Get(cmbEmployee.SelectedValue.ToString()); obj.OTHours = Calculate.CalOTHours(OTHours, OTMinutes); obj.WorkStart = txtFrom.Text; obj.WorkStop = txtTo.Text; if (rdbOutsource.Checked == true) { int theCount = Convert.ToInt32(txtNos.Text); for (int i = 0; i < theCount; i++) { objBatchLabourDetails_DL.Add(obj); } } else { objBatchLabourDetails_DL.Add(obj); } Load_BatchLabourDetails(); Clear_Labour(); // Load_Activity_List(); } catch (Exception) { MessageBox.Show(this, "Error occured while loading Labour Details", "Error", MessageBoxButtons.OK, MessageBoxIcon.Warning); } } } }
private void dgvBatchLabourDetails_KeyDown(object sender, KeyEventArgs e) { if (e.KeyCode == Keys.Delete) { BatchLabourDetails obj = new BatchLabourDetails(); objBatchLabourDetails_DL.Delete(Convert.ToInt32(dgvBatchLabourDetails.CurrentRow.Cells["LabourRecID"].Value)); Load_BatchLabourDetails(); } }
private void dgvBatchLabourDetails_KeyDown(object sender, KeyEventArgs e) { if (e.KeyCode == Keys.Delete) { if (objBatchActivity.BatchActStatus == BatchActivity.Status.Finished) { MessageBox.Show(this, "This Activity Is Finished.", "Wrong Attempt", MessageBoxButtons.OK); } else { BatchLabourDetails obj = new BatchLabourDetails(); objBatchLabourDetails_DL.Delete(Convert.ToInt32(dgvBatchLabourDetails.CurrentRow.Cells["LabourRecID"].Value)); Load_BatchLabourDetails(); } } }
private void SaveRecord() { try { Decimal OTHours = 0; Decimal OTMinutes = 0; if (txtOT.Text != "") { OTHours = Convert.ToDecimal(txtOT.Text); } if (txtOTMinutes.Text != "") { OTMinutes = Convert.ToDecimal(txtOTMinutes.Text); } BatchLabourDetails obj = new BatchLabourDetails(); obj.BatchAct = objBatchActivity; obj.Emp = objEmployee_DL.Get(cmbEmployee.SelectedValue.ToString()); obj.OTHours = Calculate.CalOTHours(OTHours, OTMinutes); obj.WorkStart = txtFrom.Text; obj.WorkStop = txtTo.Text; if (rdbOutsource.Checked == true) { int theCount = Convert.ToInt32(txtNos.Text); for (int i = 0; i < theCount; i++) { objBatchLabourDetails_DL.Add(obj); } } else { objBatchLabourDetails_DL.Add(obj); } } catch (Exception) { MessageBox.Show(this, "Error occured while loading Batch List", "Error", MessageBoxButtons.OK, MessageBoxIcon.Warning); } }
public long Add_Secondary(BatchLabourDetails objBatchLabourDetails) { try { SqlParameter[] paramList = new SqlParameter[] { new SqlParameter("@BatchActID", objBatchLabourDetails.BatchAct.BatchActID), new SqlParameter("@EmployeeID", objBatchLabourDetails.Emp.EmployeeID), new SqlParameter("@WorkStart", objBatchLabourDetails.WorkStart), new SqlParameter("@WorkStop", objBatchLabourDetails.WorkStop), new SqlParameter("@OTHours", objBatchLabourDetails.OTHours) }; return(Execute.RunSP_Int(Connection, "SPADD_BatchLabourDetails_Secondary", paramList)); } catch (Exception ex) { throw new Exception(ex.Message, ex); } }
private void txtOTMinutes_KeyDown(object sender, KeyEventArgs e) { if (e.KeyCode == Keys.Enter) { if (e.KeyCode == Keys.Enter) { if (objBatchActivity.BatchActStatus == BatchActivity.Status.Finished) { MessageBox.Show(this, "Activity is already Finished", "Wrong Attempt", MessageBoxButtons.OK); Clear_Labour(); } else { if (!DataValidation.IsTimeShift(txtFrom.Text, txtTo.Text)) { MessageBox.Show(this, "please enter valid time period", "MRP System", MessageBoxButtons.OK); } else if (!DataValidation.IsHours(txtOT.Text) || !DataValidation.IsMinutes(txtOTMinutes.Text)) { MessageBox.Show(this, "please enter valid OT Details", "MRP System", MessageBoxButtons.OK); } else { try { Decimal OTHours = 0; Decimal OTMinutes = 0; if (txtOT.Text != "") { OTHours = Convert.ToDecimal(txtOT.Text); } if (txtOTMinutes.Text != "") { OTMinutes = Convert.ToDecimal(txtOTMinutes.Text); } BatchLabourDetails obj = new BatchLabourDetails(); obj.BatchAct = objBatchActivity; obj.Emp = objEmployee_DL.Get(cmbEmployee.SelectedValue.ToString()); obj.OTHours = Calculate.CalOTHours(OTHours, OTMinutes); obj.WorkStart = txtFrom.Text; obj.WorkStop = txtTo.Text; if (rdbOutsource.Checked == true) { int theCount = Convert.ToInt32(txtNos.Text); for (int i = 0; i < theCount; i++) { objBatchLabourDetails_DL.Add(obj); } } else { objBatchLabourDetails_DL.Add(obj); } Load_BatchLabourDetails(); Clear_Labour(); } catch (Exception) { MessageBox.Show(this, "Error occured while loading Labour Details", "Error", MessageBoxButtons.OK, MessageBoxIcon.Warning); } } } } } }
private void txtOTMinutes_KeyDown(object sender, KeyEventArgs e) { if (e.KeyCode == Keys.Enter) { if (e.KeyCode == Keys.Enter) { if (objBatchActivity.BatchActStatus == BatchActivity.Status.Finished) { MessageBox.Show(this, "Activity is already Finished", "Wrong Attempt", MessageBoxButtons.OK); Clear_Labour(); } else { try { Decimal OTHours = 0; Decimal OTMinutes = 0; if (txtOT.Text != "") { OTHours = Convert.ToDecimal(txtOT.Text); } if (txtOTMinutes.Text != "") { OTMinutes = Convert.ToDecimal(txtOTMinutes.Text); } BatchLabourDetails obj = new BatchLabourDetails(); obj.BatchAct = objBatchActivity; obj.OTHours = Calculate.CalOTHours(OTHours, OTMinutes); obj.WorkStart = txtFrom.Text; obj.WorkStop = txtTo.Text; int count = 0; if (objBatchActivity.ActType == "Packing_Secondary") { for (int i = 0; i < dgvEmployeeList.Rows.Count; i++) { if (Convert.ToBoolean(dgvEmployeeList.Rows[i].Cells["Select"].Value) == true) { obj.Emp = objEmployee_DL.Get(dgvEmployeeList.Rows[i].Cells["EmpID"].Value.ToString()); count++; objBatchLabourDetails_DL.Add_Secondary(obj); } } } else { for (int i = 0; i < dgvEmployeeList.Rows.Count; i++) { if (Convert.ToBoolean(dgvEmployeeList.Rows[i].Cells["Select"].Value) == true) { obj.Emp = objEmployee_DL.Get(dgvEmployeeList.Rows[i].Cells["EmpID"].Value.ToString()); count++; objBatchLabourDetails_DL.Add(obj); } } } Clear_Labour(); this.Close(); } catch (Exception) { MessageBox.Show(this, "Error occured while loading Labour Details", "Error", MessageBoxButtons.OK, MessageBoxIcon.Warning); } } } } }