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