public int UpdateEfficencyInfo(EfficencyInput efficency) { int actionResult = 0; try { EfficencyGateway efficencyGateway = new EfficencyGateway(); actionResult = efficencyGateway.UpdateEfficencyInfo(efficency); return(actionResult); } catch (Exception ex) { throw ex; } }
public DataTable InsertEfficencyData(EfficencyInput efficency) { DataTable dt = null; try { EfficencyGateway efficencyGateway = new EfficencyGateway(); dt = efficencyGateway.InsertEfficencyData(efficency); return(dt); } catch (Exception ex) { throw ex; } }
private void saveButton_Click(object sender, EventArgs e) { EfficencyBLL efficencyBLL = new EfficencyBLL(); EfficencyInput efficency = new EfficencyInput(); DataTable dt = null; int returnValue = 0; efficency.EfficencyId = Id; if (plantComboBox.SelectedItem == "" || plantComboBox.SelectedItem == null) { System.Windows.Forms.MessageBox.Show("Please Select Plant"); } else { efficency.Plant = plantComboBox.SelectedItem.ToString(); } if (sewingTeamTextBox.Text == "" || sewingTeamTextBox.Text == null) { System.Windows.Forms.MessageBox.Show("Please Select Sewing Team"); } else { efficency.SewingTeam = sewingTeamTextBox.Text; } if (SupervisorNameComboBox.SelectedItem == "" || SupervisorNameComboBox.SelectedItem == null) { System.Windows.Forms.MessageBox.Show("Please Select Supervisor"); } else { efficency.Supervisor = SupervisorNameComboBox.SelectedItem.ToString(); } if (attendenceTextBox.Text == "" || attendenceTextBox.Text == null) { System.Windows.Forms.MessageBox.Show("Please enter total number of attendeance"); } else { efficency.Attendance = Convert.ToDecimal(attendenceTextBox.Text); } if (buyerComboBox.SelectedItem == "" || buyerComboBox.SelectedItem == null) { System.Windows.Forms.MessageBox.Show("Please Select buyer"); } else { efficency.BuyerName = buyerComboBox.SelectedItem.ToString(); } if (serialNumberTextBox.Text == "" || serialNumberTextBox.Text == null) { efficency.SerialNumber = ""; } else { efficency.SerialNumber = serialNumberTextBox.Text; } if (styleNumberTextBox.Text == "" || styleNumberTextBox.Text == null) { System.Windows.Forms.MessageBox.Show("Please enter style number"); } else { efficency.StyleNumber = styleNumberTextBox.Text; } if (sampleTypeTextBox.Text == "" || sampleTypeTextBox.Text == null) { System.Windows.Forms.MessageBox.Show("Please enter sample type"); } else { efficency.SampleType = sampleTypeTextBox.Text; } if (itemCategoryComboBox.SelectedItem == "" || itemCategoryComboBox.SelectedItem == null) { System.Windows.Forms.MessageBox.Show("Please Select buyer"); } else { efficency.ItemCategory = itemCategoryComboBox.SelectedItem.ToString(); } if (smvFactorComboBox.SelectedItem == "" || smvFactorComboBox.SelectedItem == null) { System.Windows.Forms.MessageBox.Show("Please Select buyer"); } else { efficency.SmvFactor = smvFactorComboBox.SelectedItem.ToString(); } efficency.SampleMaker = Convert.ToInt32(sampleMakerTextBox.Text); efficency.SampleMakingTime = Convert.ToInt32(sampleMakeTimeTextBox.Text); efficency.ProductQuentity = Convert.ToInt32(productQuantityTextBox.Text); efficency.SmvValue = Convert.ToDecimal(smvTextBox.Text); if (overtime105TextBox.Text == "" || overtime105TextBox.Text == null) { efficency.OverTime105Person = 0; } else { efficency.OverTime105Person = Convert.ToInt16(overtime105TextBox.Text); } if (overTime120TextBox.Text == "" || overTime120TextBox.Text == null) { efficency.OverTime120Person = 0; } else { efficency.OverTime120Person = Convert.ToInt16(overTime120TextBox.Text); } if (overTime90TextBox.Text == "" || overTime90TextBox.Text == null) { efficency.OverTime90Person = 0; } else { efficency.OverTime90Person = Convert.ToInt16(overTime90TextBox.Text); } if (machineLoseTextBox.Text == null || machineLoseTextBox.Text == "") { efficency.MachineLostTime = 0; } else { efficency.MachineLostTime = Convert.ToInt32(machineLoseTextBox.Text); } if (merchantLostTextBox.Text == null || merchantLostTextBox.Text == "") { efficency.MerchantLostTime = 0; } else { efficency.MerchantLostTime = Convert.ToInt32(merchantLostTextBox.Text); } if (patternLostTextBox.Text == null || patternLostTextBox.Text == "") { efficency.PatternLostTime = 0; } else { efficency.PatternLostTime = Convert.ToInt32(patternLostTextBox.Text); } if (EmbiLostTextBox.Text == null || EmbiLostTextBox.Text == "") { efficency.EmbiLostTime = 0; } else { efficency.EmbiLostTime = Convert.ToInt32(EmbiLostTextBox.Text); } if (otherLostTextBox.Text == null || otherLostTextBox.Text == "") { efficency.OtherLostTime = 0; } else { efficency.OtherLostTime = Convert.ToInt32(otherLostTextBox.Text); } efficency.TotalLostTime = efficency.MachineLostTime + efficency.MerchantLostTime + efficency.PatternLostTime + efficency.EmbiLostTime + efficency.OtherLostTime; if (overTime90TextBox.Text == "" || overTime90TextBox.Text == null) { efficency.OverTime90Person = 0; } else { efficency.OverTime90Person = Convert.ToInt32(overTime90TextBox.Text); } if (overtime105TextBox.Text == "" || overtime105TextBox.Text == null) { efficency.OverTime105Person = 0; } else { efficency.OverTime105Person = Convert.ToInt32(overtime105TextBox.Text); } if (overTime120TextBox.Text == "" || overTime120TextBox.Text == null) { efficency.OverTime120Person = 0; } else { efficency.OverTime120Person = Convert.ToInt32(overTime120TextBox.Text); } if (departmentComboBox.SelectedItem == "" || departmentComboBox.SelectedItem == null) { efficency.Department = ""; } else { efficency.Department = departmentComboBox.SelectedItem.ToString(); } efficency.OverTime90 = 90 * efficency.OverTime90Person; efficency.OverTime105 = 105 * efficency.OverTime105Person; efficency.OverTime120 = 120 * efficency.OverTime120Person; efficency.TotalOverTime = efficency.OverTime90 + efficency.OverTime105 + efficency.OverTime120; efficency.TotalOfficialTime = efficency.Attendance * Convert.ToDecimal(480); efficency.TotalTime = efficency.TotalOfficialTime + efficency.TotalOverTime; //A = 5,B = 7,C = 8,D = 9,E = 10,F = 11,G = 12 switch (efficency.SmvFactor) { case "A": efficency.SmvFactorValue = 5; break; case "B": efficency.SmvFactorValue = 7; break; case "C": efficency.SmvFactorValue = 8; break; case "D": efficency.SmvFactorValue = 9; break; case "E": efficency.SmvFactorValue = 10; break; case "F": efficency.SmvFactorValue = 11; break; case "G": efficency.SmvFactorValue = 12; break; default: efficency.SmvFactorValue = 0; break; } efficency.Rating = (Convert.ToDecimal(efficency.SmvFactorValue) / Convert.ToDecimal(efficency.SampleMaker)); efficency.EstimatedTime = ((efficency.SmvValue * efficency.Rating) + ((efficency.ProductQuentity - 1) * ((efficency.SmvValue * efficency.Rating) / 2))); efficency.TotalProduceMinute = efficency.EstimatedTime * efficency.SampleMaker; if (efficency.ProductQuentity <= 20) { efficency.Fact1Below21 = efficency.TotalProduceMinute; } else { efficency.Fact1Below21 = 0; } if (efficency.ProductQuentity >= 21) { efficency.Fact2Above20 = efficency.TotalProduceMinute; } else { efficency.Fact2Above20 = 0; } efficency.TotalFact = efficency.Fact1Below21 + efficency.Fact2Above20; efficency.ActualTakenTime = efficency.SampleMaker * efficency.SampleMakingTime; if (efficency.ActualTakenTime == 0) { efficency.PerformancePercentage = 0; } else { efficency.PerformancePercentage = (efficency.TotalProduceMinute / efficency.ActualTakenTime) * 100; } efficency.MinimumProduceTime = efficency.TotalTime * Convert.ToDecimal(0.45); efficency.NonProductiveTime = efficency.TotalTime - efficency.ActualTakenTime; efficency.ProductionDate = Convert.ToString(Convert.ToDateTime(productionDateTimePicker.Text).ToShortDateString()); efficency.Comments = commentTextBox.Text; if (efficency.EfficencyId == 0) { dt = efficencyBLL.InsertEfficencyData(efficency); if (dt.Rows.Count > 0) { returnValue = Convert.ToInt32(dt.Rows[0]["ReturnValue"]); if (returnValue > 0) { massageLabel.Text = "Provided Information Already Exists!!!"; } else { System.Windows.Forms.MessageBox.Show("Information Successfully Saved"); //massageLabel.Text = "Information Successfully Saved"; LoadEfficencyInformation(); ClearEfficencyInfo(); } } } else { int actionResult = 0; actionResult = efficencyBLL.UpdateEfficencyInfo(efficency); if (actionResult > 0) { massageLabel.Text = "Information Successfully Updated"; LoadEfficencyInformation(); ClearEfficencyInfo(); } else { massageLabel.Text = "Provided Information Already Exists!!!"; } } }
public DataTable InsertEfficencyData(EfficencyInput efficency) { DataTable dt = new DataTable(); try { OpenConnection(); ArrayList arlSqlParameter = new ArrayList(); arlSqlParameter.Add(new SqlParameter("@Plant", efficency.Plant)); arlSqlParameter.Add(new SqlParameter("@SewingTeam", efficency.SewingTeam)); arlSqlParameter.Add(new SqlParameter("@Supervisor", efficency.Supervisor)); arlSqlParameter.Add(new SqlParameter("@Attendance", efficency.Attendance)); arlSqlParameter.Add(new SqlParameter("@BuyerName", efficency.BuyerName)); arlSqlParameter.Add(new SqlParameter("@SerialNumber", efficency.SerialNumber)); arlSqlParameter.Add(new SqlParameter("@StyleNumber", efficency.StyleNumber)); arlSqlParameter.Add(new SqlParameter("@SampleType", efficency.SampleType)); arlSqlParameter.Add(new SqlParameter("@ItemCategory", efficency.ItemCategory)); arlSqlParameter.Add(new SqlParameter("@SmvFactor", efficency.SmvFactor)); arlSqlParameter.Add(new SqlParameter("@SmvFactorValue", efficency.SmvFactorValue)); arlSqlParameter.Add(new SqlParameter("@SampleMaker", efficency.SampleMaker)); arlSqlParameter.Add(new SqlParameter("@SampleMakingTime", efficency.SampleMakingTime)); arlSqlParameter.Add(new SqlParameter("@ProductQuentity", efficency.ProductQuentity)); arlSqlParameter.Add(new SqlParameter("@SmvValue", efficency.SmvValue)); arlSqlParameter.Add(new SqlParameter("@MachineLostTime", efficency.MachineLostTime)); arlSqlParameter.Add(new SqlParameter("@MerchantLostTime", efficency.MerchantLostTime)); arlSqlParameter.Add(new SqlParameter("@PatternLostTime", efficency.PatternLostTime)); arlSqlParameter.Add(new SqlParameter("@EmbiLostTime", efficency.EmbiLostTime)); arlSqlParameter.Add(new SqlParameter("@OtherLostTime", efficency.OtherLostTime)); arlSqlParameter.Add(new SqlParameter("@TotalLostTime", efficency.TotalLostTime)); arlSqlParameter.Add(new SqlParameter("@OverTime90Person", efficency.OverTime90Person)); arlSqlParameter.Add(new SqlParameter("@OverTime105Person", efficency.OverTime105Person)); arlSqlParameter.Add(new SqlParameter("@OverTime120Person", efficency.OverTime120Person)); arlSqlParameter.Add(new SqlParameter("@OverTime90", efficency.OverTime90)); arlSqlParameter.Add(new SqlParameter("@OverTime105", efficency.OverTime105)); arlSqlParameter.Add(new SqlParameter("@OverTime120", efficency.OverTime120)); arlSqlParameter.Add(new SqlParameter("@TotalOverTime", efficency.TotalOverTime)); arlSqlParameter.Add(new SqlParameter("@TotalOfficialTime", efficency.TotalOfficialTime)); arlSqlParameter.Add(new SqlParameter("@TotalTime", efficency.TotalTime)); arlSqlParameter.Add(new SqlParameter("@Rating", efficency.Rating)); arlSqlParameter.Add(new SqlParameter("@EstimatedTime", efficency.EstimatedTime)); arlSqlParameter.Add(new SqlParameter("@TotalProduceMinute", efficency.TotalProduceMinute)); arlSqlParameter.Add(new SqlParameter("@Fact1Below21", efficency.Fact1Below21)); arlSqlParameter.Add(new SqlParameter("@Fact2Above20", efficency.Fact2Above20)); arlSqlParameter.Add(new SqlParameter("@TotalFact", efficency.TotalFact)); arlSqlParameter.Add(new SqlParameter("@ActualTakenTime", efficency.ActualTakenTime)); arlSqlParameter.Add(new SqlParameter("@PerformancePercentage", efficency.PerformancePercentage)); arlSqlParameter.Add(new SqlParameter("@MinimumProduceTime", efficency.MinimumProduceTime)); arlSqlParameter.Add(new SqlParameter("@NonProductiveTime", efficency.NonProductiveTime)); arlSqlParameter.Add(new SqlParameter("@Department", efficency.Department)); //arlSqlParameter.Add(new SqlParameter("@Wip", efficency.Wip)); //arlSqlParameter.Add(new SqlParameter("@MaterialCostAvg", efficency.MaterialCostAvg)); //arlSqlParameter.Add(new SqlParameter("@OverHeadCost", efficency.OverHeadCost)); arlSqlParameter.Add(new SqlParameter("@ProductionDate", efficency.ProductionDate)); arlSqlParameter.Add(new SqlParameter("@Comments", efficency.Comments)); dt = this.ExecuteQuery("[effi].[USP_InsertEfficencyInfo]", arlSqlParameter); } catch (Exception ex) { } finally { CloseConnection(); } return(dt); }