private void InitializeDropDownValues(int itemId)
{
DataTable dt = new DataTable();
dt = ButtonsUtility.InitializeItemDropDownMaterials(itemId);
comboBoxMaterials.Items.Clear();
for (int i = 0; i < dt.Rows.Count; i++)
{
comboBoxMaterials.Items.Add(dt.Rows[i][0]);
}
}
private void GetObervationActivities()
{
DataSet ds = new DataSet("TimeRanges");
ds = ButtonsUtility.GetActivitesObservationOEE(Item_Id);
dataGridViewObsOEEKPI.DataSource = ds.Tables[0];
dataGridViewObsOEEKPI.Columns[1].AutoSizeMode = DataGridViewAutoSizeColumnMode.Fill;
dataGridViewAcitvityOEEKPI.DataSource = ds.Tables[1];
dataGridViewAcitvityOEEKPI.Columns[1].AutoSizeMode = DataGridViewAutoSizeColumnMode.Fill;
}
private void GetPreviousEntriesDownTime(string dateTime)
{
int downTime = ButtonsUtility.GetDownTime(dateTime, MachineId, WorkShopId, ItemId, ProcessId);
if (downTime > 0)
{
textBoxDownTimeDailyEntry.Text = downTime.ToString();
decimal ratio = (downTime / Convert.ToDecimal(textBoxShitTimeMachinedailyEntryMachine.Text)) * 100;
decimal ratioRounded = (Math.Round(ratio, 2));
textBoxRatioDailyTimeEntry.Text = ratioRounded.ToString();
}
}
private void dataGridViewMachineDetails_CellContentClick(object sender, DataGridViewCellEventArgs e)
{
string MachineCode = dataGridViewMachineDetails.CurrentRow.Cells[0].Value.ToString();
int rows = ButtonsUtility.RemoveMachineAssociationWithItem(MachineCode, Item_Id);
if (rows > 0)
{
labelMachineinfoUpdateSucessful.Visible = true;
GetGridData();
}
}
private void GetProcess()
{
DataTable dt = new DataTable();
dt = ButtonsUtility.GetProcesses(Item_Id);
comboBoxSelectProcess.Items.Clear();
for (int i = 0; i < dt.Rows.Count; i++)
{
comboBoxSelectProcess.Items.Add(dt.Rows[i][0]);
}
}
private void buttonSaveTarget_Click(object sender, EventArgs e)
{
int row = ButtonsUtility.InsertTargetEquipmentFailureWorkShop(WorkShop_Id, Month_Id, Convert.ToDecimal(textBoxTarget.Text), Convert.ToInt32(textBoxNoOfDays.Text), dateTimePickerEquipFailRate.Value.Year);
if (row > 0)
{
labelTargetSaved.Visible = true;
buttonEdit.Visible = true;
buttonSaveTarget.Visible = false;
GetGridCalculations();
this.Refresh();
}
}
private void GetProcess()
{
comboBoxProcess.Items.Clear();
DataTable dt = new DataTable();
dt = ButtonsUtility.GetProcessesForMachine(ItemId, MachineId);
for (int i = 0; i < dt.Rows.Count; i++)
{
comboBoxProcess.Items.Add(dt.Rows[i][0]);
}
}
private void TextBoxesCalculatedValuesofItemSelectedbyCombo(string itemName)
{
Item_Id = ButtonsUtility.GetITemId(itemName);
if (comboBoxDie.Visible == true)
{
InitializeComboBoxDie(Item_Id);
}
labelRecordupdatedSucessfully.Visible = false;
labelPleaseSelectItem.Visible = false;
}
private void textBoxTotalUnits_TextChanged(object sender, EventArgs e)
{
if (textBoxCostofEachUnit.Text != "" && textBoxTotalMaterial.Text != "")
{
//decimal costofEachUnitOfMultiple = Convert.ToDecimal(textBoxCostofEachUnit.Text) / Convert.ToDecimal(textBoxMultiple.Text);
//textBoxTotalCost.Text = (costofEachUnitOfMultiple * Convert.ToDecimal(textBoxTotalMaterial.Text)).ToString();
decimal costofEachUnitOfMultiple = ButtonsUtility.CalculateTotalCostofMaterial(Convert.ToDecimal(textBoxCostofEachUnit.Text), Convert.ToDecimal(textBoxMultiple.Text), Convert.ToDecimal(textBoxTotalMaterial.Text));
textBoxTotalCost.Text = (costofEachUnitOfMultiple).ToString();
}
labelPleaseEnterTotalMaterialUsed.Visible = false;
labelRecordupdatedSucessfullyDailyEntry.Visible = false;
}
private void buttonSaveTarget_Click(object sender, EventArgs e)
{
int row = ButtonsUtility.InsertTargetCustRejcectionkCost(Item_Id, Month_Id, Convert.ToDecimal(textBoxTarget.Text), dateTimePickerCostCustRej.Value.Year);
if (row > 0)
{
labelTargetSaved.Visible = true;
buttonEdit.Visible = true;
buttonSaveTarget.Visible = false;
GetGridCalculations();
this.Refresh();
}
}
private void GetWorkShops()
{
DataTable dt = new DataTable();
dt = ButtonsUtility.ViewShops();
comboBoxWorkShopMachine.Items.Clear();
for (int i = 0; i < dt.Rows.Count; i++)
{
comboBoxWorkShopMachine.Items.Add(dt.Rows[i][0]);
}
}
private void comboBoxProcess_SelectedIndexChanged(object sender, EventArgs e)
{
DataTable dt = new DataTable();
dt = ButtonsUtility.GetProcessIdAndCapacity(comboBoxProcess.Text, ItemId);
ProcessId = Convert.ToInt32(dt.Rows[0][0]);
textBoxDownTimeDailyEntry.Text = "";
labelPleaseSelectProcess.Visible = false;
GetPreviousEntriesDownTime(dateTimePickerDailyEntryMachine.Text);
labelPleasePresseditButtonforalreadyseavedentry.Visible = false;
}
private void comboBoxWorkShop_SelectedIndexChanged(object sender, EventArgs e)
{
labelPleaseCreateAMachine.Visible = false;
labelSelectWSFirstMachinedailyEntryMachine.Visible = false;
textBoxDownTimeDailyEntry.Text = "";
textBoxRatioDailyTimeEntry.Text = "";
labelPleasePresseditButtonforalreadyseavedentry.Visible = false;
WorkShopId = ButtonsUtility.GetWorkShopId(comboBoxWorkShopMachinedailyEntryMachine.Text);
labelMachineinfoUpdateSucessful.Visible = false;
labelMachineInfoInsertSucess.Visible = false;
comboBoxMachineSelectiondailyEntryMachine.Text = "";
GetMachines();
labelPleasePresseditButtonforalreadyseavedentry.Visible = false;
}
private void Delete()
{
if (textBoxID.Text != "")
{
int rows = ButtonsUtility.RemoveEmployee(empId);
if (rows > 0)
{
textBoxID.Clear();
textBoxName.Clear();
textBoxStatus.Clear();
labelDelete.Visible = true;
}
}
}
private void GetDetails(string id)
{
DataTable dt = ButtonsUtility.GetEmpDetails(id);
if (dt.Rows[0][0].ToString() != "0")
{
textBoxName.Text = dt.Rows[0][0].ToString();
textBoxID.Text = dt.Rows[0][1].ToString();
textBoxContactNumber.Text = dt.Rows[0][2].ToString();
textBoxAddress.Text = dt.Rows[0][3].ToString();
textBoxEmail.Text = dt.Rows[0][4].ToString();
empId = dt.Rows[0][1].ToString();
}
}
private void buttonDelete_Click(object sender, EventArgs e)
{
int rows = ButtonsUtility.DeleteWorkShop(WorkShopId);
if (rows > 0)
{
textBoxWorkShopName.Clear();
comboBoxWorkShop.Text = "";
labelDelete.Visible = true;
GetWorkShop();
}
}
private void buttonSaveTarget_Click(object sender, EventArgs e)
{
int row = ButtonsUtility.InsertTargetDelivaryComplianceRatio(Item_Id, Month_Id, Convert.ToDecimal(textBoxTarget.Text), dateTimePickerDelComp.Value.Year);
if (row > 0)
{
labelTargetSaved.Visible = true;
buttonEdit.Visible = true;
buttonSaveTarget.Visible = false;
GetGridCalculations();
// this.Refresh();
labelMonthlyDelivaryComplianceKPI.Select();
}
}
private void InitializeDropDownWorkShop()
{
DataTable dt = new DataTable();
dt = ButtonsUtility.ViewShops();
comboBoxShop.Items.Clear();
for (int i = 0; i < dt.Rows.Count; i++)
{
comboBoxShop.Items.Add(dt.Rows[i][0]);
}
}
private void GetMaterialDetails(string Code)
{
DataTable dt = new DataTable();
DataTable dtdaily = new DataTable();
dt = ButtonsUtility.GetMaterials(Material_Code, Item_Id);
dtdaily = ButtonsUtility.GetMaterialsDaily(Material_Code, Item_Id, dateTimePickerMaterial.Text);
if (dt.Rows.Count > 0)
{
textBoxUnit.Text = dt.Rows[0][2].ToString(); //unit
textBoxMultiple.Text = dt.Rows[0][3].ToString(); //Multiple
textBoxCostofEachUnit.Text = dt.Rows[0][4].ToString(); //costofEach
decimal Multiples = Convert.ToDecimal(dt.Rows[0][3]);
if (!string.IsNullOrEmpty(textBoxDailyProduction.Text))
{
//textBoxPlannedMaterialUsed
textBoxPlannedMaterialUsed.Text = (Multiples * Convert.ToInt32(textBoxDailyProduction.Text)).ToString();
//Planned cost
textBoxPlannedCost.Text = ((Convert.ToInt32(textBoxDailyProduction.Text)) * (Convert.ToDecimal(dt.Rows[0][4]))).ToString();
}
if (textBoxTotalMaterial.Text != "")
{
decimal costofEachUnitOfMultiple = Convert.ToDecimal(dt.Rows[0][4]) / Multiples;
textBoxTotalCost.Text = (costofEachUnitOfMultiple * Convert.ToDecimal(textBoxTotalMaterial.Text)).ToString();
}
Material_Id = Convert.ToInt32(dt.Rows[0][5]);
}
if (dtdaily.Rows.Count > 0)
{
textBoxTotalMaterial.Text = dtdaily.Rows[0][0].ToString();
textBoxTotalCost.Text = dtdaily.Rows[0][1].ToString();
labelPleaseEnterdailyEntry.Visible = false;
buttonDailyEntry.Visible = false;
buttonEdit.Visible = true;
}
else
{
textBoxTotalMaterial.Text = "";
textBoxTotalCost.Text = "";
labelPleaseEnterTotalMaterialUsed.Visible = true;
//labelPleaseEnterdailyEntry.Visible = true;
//buttonDailyEntry.Visible = true;
}
}
private void buttonDelete_Click(object sender, EventArgs e)
{
if (dataGridViewWorkerDetails.SelectedRows.Count == 1)
{
int rowsAffected = ButtonsUtility.DeleteWorker(workerId);
if (rowsAffected > 0)
{
MessageBox.Show("Worker deleted Successfully.", "Success");
}
}
else
{
MessageBox.Show("Please Select a single row to Edit.", "Warning");
}
}
private void buttonBackCostOfRejectionKPI_Click(object sender, EventArgs e)
{
//if (Back == 0)
//{
// OverAll_KPIs KPI = new OverAll_KPIs(0);
// KPI.Show();
// this.Close();
//}
//else
//{
ButtonsUtility.Menu(Item_Id);
this.Close();
//}
}
private void dateTimePicker_ValueChanged(object sender, EventArgs e)
{
if ((textBoxName.Text != "" || textBoxName.Text != "No Record Found") && textBoxID.Text != "")
{
string Attendance = ButtonsUtility.GetEmployeeAttendance(textBoxID.Text, dateTimePicker.Text);
textBoxStatus.Text = Attendance;
buttonArrival.Visible = true;
buttonEditInfo.Visible = true;
textBoxID.Clear();
textBoxName.Clear();
textBoxStatus.Clear();
// buttonStatus.Visible = true;
// buttonAbsent.Visible = true;
}
}
private void FetchUserDetails(int User_Id)
{
DataTable dt = new DataTable();
dt = ButtonsUtility.FetchUserDetails(User_Id);
if (dt.Rows.Count > 0)
{
textBoxUserName.Text = dt.Rows[0][0].ToString();
textBoxPassword.Text = dt.Rows[0][1].ToString();
comboBoxUserType.Text = dt.Rows[0][2].ToString();
textBoxContactNumber.Text = dt.Rows[0][3].ToString();
textBoxEmail.Text = dt.Rows[0][4].ToString();
textBoxAddress.Text = dt.Rows[0][5].ToString();
}
}
private void TextBoxesCalculatedValues(int itemId)
{
DataTable dt = new DataTable();
dt = ButtonsUtility.TotalUnitsMadeDetails(itemId);
if (dt.Rows.Count == 0)
{
}
else
{
textBoxTotalUnitsReworkRatio.Text = dt.Rows[0][1].ToString();
textBoxCostofEachUnitReworkRatio.Text = dt.Rows[0][2].ToString();
// textBoxTotalCostReworkRatio.Text = dt.Rows[0][3].ToString();
}
}
private void FetchItemDetails(int ItemId)
{
DataTable dt = new DataTable();
dt = ButtonsUtility.FetchItemDetails(ItemId);
textBoxNameOfItem.Text = dt.Rows[0][0].ToString();
textBoxtemDescription.Text = dt.Rows[0][1].ToString();
textBoxItemCode.Text = dt.Rows[0][2].ToString();
labelItemCode.Text = dt.Rows[0][2].ToString();
textBoxUOM.Text = dt.Rows[0][3].ToString();
textBoxCostofEachUnit.Text = dt.Rows[0][4].ToString();
textBoxRework.Text = dt.Rows[0][5].ToString();
textBoxInhouseRej.Text = dt.Rows[0][6].ToString();
}
private void GetMaterialDetails(string Code)
{
DataTable dt = new DataTable();
dt = ButtonsUtility.GetMaterials(Material_Code, Item_Id);
textBoxName.Text = dt.Rows[0][0].ToString();
textBoxCode.Text = dt.Rows[0][1].ToString();
textBoxUnit.Text = dt.Rows[0][2].ToString();
textBoxMultiple.Text = dt.Rows[0][3].ToString();
textBoxCost.Text = dt.Rows[0][4].ToString();
Material_Id = Convert.ToInt32(dt.Rows[0][5]);
}
public DailyEntry_CustomerClaims(int itemId)
{
InitializeComponent();
Item_Id = itemId;
if (itemId > 0)
{
string ItemName = ButtonsUtility.ItemNameUtility(itemId);
labelItemNameCustomerClaims.Text = ItemName;
comboBoxItemsDailyEntryDelivaryCompliance.Visible = false;
labelSelectItemDailyEntryCustomerClaims.Visible = false;
}
else if (Item_Id == 0)
{
InitializeDropDownItemValues();
}
}
private void GetMoldData(int moldId)
{
DataTable dt = new DataTable();
dt = ButtonsUtility.GetDieAndMoldDataToEdit(moldId);
if (dt.Rows.Count > 0)
{
textBoxName.Text = dt.Rows[0][0].ToString();
textBoxCode.Text = dt.Rows[0][1].ToString();
textBoxPlannedShots.Text = dt.Rows[0][2].ToString();
comboBoxItems.Text = dt.Rows[0][3].ToString();
buttonDailyEntrySave.Visible = false;
}
Mold_Code = textBoxCode.Text;
}
private void InitializeDropDownItemValues()
{
DataTable dt = new DataTable();
dt = ButtonsUtility.InitializeItemByMachineDropDown(MachineId);
if (dt.Rows.Count < 1)
{
labelAssociateMachineWithItem.Visible = true;
comboBoxItem.Text = "";
}
comboBoxItem.Items.Clear();
for (int i = 0; i < dt.Rows.Count; i++)
{
comboBoxItem.Items.Add(dt.Rows[i][0]);
}
}
private void btnExport_Click(object sender, EventArgs e)
{
string Path = Environment.GetFolderPath(Environment.SpecialFolder.MyDocuments);
DataTable dt = new DataTable();
if (dateTimePickerFrom.Value < dateTimePickerTo.Value)
{
dt = ButtonsUtility.GetEmployeeAttendanceDetails(textBoxID.Text, dateTimePickerFrom.Text, dateTimePickerTo.Text);
labelReportisGenerating.Visible = true;
Reports.ExportDataSetToExcel(dt, Path, dt.Rows[0][0].ToString());
labelReportisGenerating.Visible = false;
}
else
{
DialogResult dialog = MessageBox.Show("From Date is always less then To Date. ", "Error", MessageBoxButtons.OK, MessageBoxIcon.Error);
}
}
