private void btmOK_Click(object sender, EventArgs e)
{
this.mfiInsert.strEquipTagPty = this.tbTag.Text.Trim();
this.mfiInsert.tsDurationPty = TimeSpan.Parse(this.tbDuration.Text.Trim());
this.mfiInsert.strTipPty = this.tbTip.Text.Trim();
this.mfiInsert.tsTimePty = TimeSpan.Parse(this.tbTime.Text.Trim());
this.mfiInsert.intIDPty = this.mfiInsert.Insert(this.cnConnection);
foreach (DataRow drPerson in this.dsPersons.Tables["tabMaintenanceFurnacePersons"].Rows)
{
drPerson["intTabItemsID"] = this.mfiInsert.intIDPty;
}
foreach (DataRow drEquip in this.dsEquips.Tables["tabMaintenanceFurnaceEquips"].Rows)
{
drEquip["intTabItemsID"] = this.mfiInsert.intIDPty;
}
MaintenanceFurnaceItem.InsertItemEquip(this.cnConnection, this.dsEquips);
MaintenanceFurnaceItem.InsertItemPerson(this.cnConnection, this.dsPersons);
MaintenanceElectricalFurnace frmMfi = (MaintenanceElectricalFurnace)this.Owner;
frmMfi.GetCurrentMaintenanceShiftAndItems();
this.Close();
}
private void btmSearchItems_Click(object sender, EventArgs e)
{
try
{
this.dsShifts.Clear();
}
catch (System.NullReferenceException)
{ }
this.mfiSearch.strEquipTagPty = this.tbTag.Text;
this.mfiSearch.strTipPty = this.tbTip.Text;
this.dsItems = MaintenanceFurnaceItem.GetMFIs(this.cnConnection, this.mfiSearch, this.tbStoreCode.Text.Trim(), this.tbPersonCoID.Text.Trim());
this.dgvItems.DataSource = this.dsItems;
this.dgvItems.DataMember = "tabMaintenanceFurnaceItems";
}
private void dgvShifts_CellClick(object sender, DataGridViewCellEventArgs e)
{
if (e.ColumnIndex == -1 && e.RowIndex != -1)
{
int intIDLoc = (int)this.dgvShifts.Rows[e.RowIndex].Cells["intID"].Value;
this.mfiSearch = new MaintenanceFurnaceItem();
this.mfiSearch.intIDPty = intIDLoc;
this.dsItems = MaintenanceFurnaceItem.GetMFIs(this.cnConnection, this.mfiSearch, this.tbStoreCode.Text.Trim(), this.tbPersonCoID.Text.Trim());
this.dgvItems.DataSource = this.dsItems;
this.dgvItems.DataMember = "tabMaintenanceFurnaceItems";
foreach (DataRow drEmployee in this.dsItems.Tables["tabMaintenanceFurnaceItems"].Rows)
{
drEmployee["nvcPersonCoID"] = Employee.GetNameByCoID(this.cnConnection, drEmployee["nvcPersonCoID"].ToString());
}
}
}
private void btmOK_Click(object sender, EventArgs e)
{
this.mfiUpdate.strEquipTagPty = this.tbTag.Text.Trim();
this.mfiUpdate.tsDurationPty = TimeSpan.Parse(this.tbDuration.Text.Trim());
this.mfiUpdate.strTipPty = this.tbTip.Text.Trim();
this.mfiUpdate.tsTimePty = TimeSpan.Parse(this.tbTime.Text.Trim());
this.mfiUpdate.Update(this.cnConnection);
MaintenanceFurnaceItem.DeleteItemEquips(this.cnConnection, this.dsPrimaryEquips);
MaintenanceFurnaceItem.DeleteItemPerson(this.cnConnection, this.dsPrimaryPersons);
MaintenanceFurnaceItem.InsertItemEquip(this.cnConnection, this.dsEquips);
MaintenanceFurnaceItem.InsertItemPerson(this.cnConnection, this.dsPersons);
MaintenanceElectricalFurnace frmMfi = (MaintenanceElectricalFurnace)this.Owner;
frmMfi.GetCurrentMaintenanceShiftAndItems();
this.Close();
}
private void dgvItems_CellMouseDoubleClick(object sender, DataGridViewCellMouseEventArgs e)
{
if (e.ColumnIndex == -1)
{
MaintenanceFurnaceItem mfiUpdate = new MaintenanceFurnaceItem();
mfiUpdate.intIDPty = (int)this.dsItems.Tables["tabMaintenanceFurnaceItems"].Rows[e.RowIndex]["intID"];
mfiUpdate.intTabShiftIDPty = this.mfsCurrent.intIDPty;
mfiUpdate.strEquipTagPty = this.dsItems.Tables["tabMaintenanceFurnaceItems"].Rows[e.RowIndex]["nvcEquipTag"].ToString();
mfiUpdate.tsTimePty = (TimeSpan)this.dsItems.Tables["tabMaintenanceFurnaceItems"].Rows[e.RowIndex]["timTime"];
mfiUpdate.tsDurationPty = (TimeSpan)this.dsItems.Tables["tabMaintenanceFurnaceItems"].Rows[e.RowIndex]["timDuration"];
mfiUpdate.strTipPty = this.dsItems.Tables["tabMaintenanceFurnaceItems"].Rows[e.RowIndex]["nvcTip"].ToString();
MaintenanceElectricalFurnaceUpdate frmMefUpdate = new MaintenanceElectricalFurnaceUpdate();
frmMefUpdate.Owner = this;
frmMefUpdate.cnConnection = this.cnConnection;
//frmMefUpdate.mfsUpdate = this.mfsCurrent;
frmMefUpdate.mfiUpdate = mfiUpdate;
frmMefUpdate.ShowDialog();
}
}
private void MaintenanceElectricalFurnaceUpdate_Load(object sender, EventArgs e)
{
this.tbTag.Text = this.mfiUpdate.strEquipTagPty;
this.tbTime.Text = this.mfiUpdate.tsTimePty.ToString();
this.tbDuration.Text = this.mfiUpdate.tsDurationPty.ToString();
this.tbTip.Text = this.mfiUpdate.strTipPty;
this.dsPersons = MaintenanceFurnaceItem.GetItemPersons(this.cnConnection, this.mfiUpdate.intIDPty);
this.dsPrimaryPersons = this.dsPersons.Copy();
this.dsPersons.Tables["tabMaintenanceFurnacePersons"].Columns.Add("nvcName");
this.dgvPersons.DataSource = this.dsPersons;
this.dgvPersons.DataMember = "tabMaintenanceFurnacePersons";
this.dgvPersons.Columns["intID"].Visible = false;
foreach (DataRow drPerson in this.dsPersons.Tables["tabMaintenanceFurnacePersons"].Rows)
{
drPerson["nvcName"] = Employee.GetNameByCoID(this.cnConnection, drPerson["nvcPersonCoID"].ToString());
}
this.dsEquips = MaintenanceFurnaceItem.GetItemEquips(this.cnConnection, this.mfiUpdate.intIDPty);
this.dsPrimaryEquips = this.dsEquips.Copy();
this.dsEquips.Tables["tabMaintenanceFurnaceEquips"].Columns.Add("nvcName");
this.dgvEquips.DataSource = this.dsEquips;
this.dgvEquips.DataMember = "tabMaintenanceFurnaceEquips";
this.dgvEquips.Columns["intID"].Visible = false;
foreach (DataRow drEquip in this.dsEquips.Tables["tabMaintenanceFurnaceEquips"].Rows)
{
Stuff parSearch = new Stuff();
//parSearch.strStoreCode = this.tbEquip.Text.Trim();
//DataSet dsEquipResult = Part.GetParts(this.cnConnection, parSearch);
//if (dsEquipResult.Tables["tabParts"].Rows.Count != 0)
//{
// String strEquipNameCode = dsEquipResult.Tables["tabParts"].Rows[0]["nvcName"].ToString();
// //String strEquipName = EquipName.GetEquipnameByCode(this.cnConnection, strEquipNameCode);
// drEquip["nvcName"] = strEquipName;
//}
}
}
public void GetCurrentMaintenanceShiftAndItems()
{
this.dsShifts.Clear();
this.dsItems.Clear();
this.mfsCurrent.dtDatePty = siShiftInfo.GetDate(DateTime.Now);
this.mfsCurrent.shiShiftPty = siShiftInfo.GetShift(DateTime.Now.TimeOfDay);
this.mfsCurrent.strCaltegoryPty = "01";
this.dsShifts = MaintenanceFurnaceShift.GetMFSs(this.cnConnection, this.mfsCurrent);
//Shift Already Inserted
if (this.dsShifts.Tables["tabMaintenanceFurnaceShifts"].Rows.Count != 0)
{
this.mfsCurrent.intIDPty = (int)this.dsShifts.Tables["tabMaintenanceFurnaceShifts"].Rows[0]["intID"];
this.mfsCurrent.strGroupPty = this.dsShifts.Tables["tabMaintenanceFurnaceShifts"].Rows[0]["nvcGroup"].ToString();
this.dgvShifts.DataSource = this.dsShifts;
this.dgvShifts.DataMember = "tabMaintenanceFurnaceShifts";
this.mfiCurrent.intTabShiftIDPty = this.mfsCurrent.intIDPty;
this.dsItems = MaintenanceFurnaceItem.GetMFIs(this.cnConnection, this.mfiCurrent, this.tbStoreCode.Text.Trim(), this.tbPersonCoID.Text.Trim());
if (this.dsItems.Tables["tabMaintenanceFurnaceItems"].Rows.Count != 0)
{
this.dgvItems.DataSource = this.dsItems;
this.dgvItems.DataMember = "tabMaintenanceFurnaceItems";
}
}
//Insert Shift
else
{
this.mfsCurrent.strGroupPty = siShiftInfo.GetGroup(siShiftInfo.GetDate(DateTime.Now)).ToString();
this.mfsCurrent.Insert(this.cnConnection);
GetCurrentMaintenanceShiftAndItems();
}
}
private void btmDelete_Click(object sender, EventArgs e)
{
MaintenanceFurnaceItem.DeleteItems(this.cnConnection, this.dsItems);
GetCurrentMaintenanceShiftAndItems();
}
