private void btmSearchShifts_Click(object sender, EventArgs e)
{
try
{
this.dsItems.Clear();
}
catch (System.NullReferenceException)
{ }
DateTime dtFromDate = new DateTime();
DateTime dtToDate = new DateTime();
if (this.cekDate.Checked)
{
dtFromDate = new DateTime(this.dtpFromDate.Value.Year, this.dtpFromDate.Value.Month, this.dtpFromDate.Value.Day);
dtToDate = new DateTime(this.dtpToDate.Value.Year, this.dtpToDate.Value.Month, this.dtpToDate.Value.Day);
}
this.mfsSearch.shiShiftPty = ShiftInfo.ConvertTextToShift(this.cbShift.Text);
this.mfsSearch.strGroupPty = this.cbGroup.Text;
this.dsShifts = MaintenanceFurnaceShift.GetMFSs(this.cnConnection, mfsSearch, dtFromDate, dtToDate);
this.dgvShifts.DataSource = this.dsShifts;
this.dgvShifts.DataMember = "tabMaintenanceFurnaceShifts";
for (int i = 0; i < this.dsShifts.Tables["tabMaintenanceFurnaceShifts"].Rows.Count; i++)
{
int intShift = int.Parse(this.dsShifts.Tables["tabMaintenanceFurnaceShifts"].Rows[i]["nvcShift"].ToString());
this.dsShifts.Tables["tabMaintenanceFurnaceShifts"].Rows[i]["nvcShift"] = ((ShiftInfo.Shift)intShift).ToString();
}
}
private void dgvItems_CellClick(object sender, DataGridViewCellEventArgs e)
{
if (e.ColumnIndex == -1 && e.RowIndex != -1)
{
MaintenanceFurnaceShift mfsSearchLoc = new MaintenanceFurnaceShift();
int intIDLoc = (int)this.dgvItems.Rows[e.RowIndex].Cells["intTabShiftID"].Value;
mfsSearchLoc.intIDPty = intIDLoc;
this.dsShifts = MaintenanceFurnaceShift.GetMFSs(this.cnConnection, mfsSearchLoc);
this.dgvShifts.DataSource = this.dsShifts;
this.dgvShifts.DataMember = "tabMaintenanceFurnaceShifts";
for (int i = 0; i < this.dsShifts.Tables["tabMaintenanceFurnaceShifts"].Rows.Count; i++)
{
int intShift = int.Parse(this.dsShifts.Tables["tabMaintenanceFurnaceShifts"].Rows[i]["nvcShift"].ToString());
this.dsShifts.Tables["tabMaintenanceFurnaceShifts"].Rows[i]["nvcShift"] = ((ShiftInfo.Shift)intShift).ToString();
}
}
}
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();
}
}
