private void btnSendRequest_Click(object sender, EventArgs e)
{
Session2Entities db = new Session2Entities();
EmergencyMaintenance records = new EmergencyMaintenance();
//check has emergency closed?
Asset asset = (from x in db.Assets where x.AssetSN == lblAssetSNValue.Text select x).FirstOrDefault <Asset>();
EmergencyMaintenance em = (from x in db.EmergencyMaintenances where x.AssetID == asset.ID && x.EMEndDate == null select x).FirstOrDefault <EmergencyMaintenance>();
records.PriorityID = (cbPriority.SelectedItem as Priority).ID;
records.DescriptionEmergency = txtDescription.Text;
records.OtherConsiderations = txtOtherConsideration.Text;
records.EMReportDate = DateTime.Now.Date;
records.AssetID = asset.ID;
if (em != null)
{
MessageBox.Show("Asset is maintaining!", "Error");
return;
}
else
{
db.EmergencyMaintenances.Add(records);
db.SaveChanges();
}
}
private void LoadDataTable()
{
Session2Entities db = new Session2Entities();
dgvEmergencyMaintenance.DataSource = db.SP_GetdgvEmergency(this.username);
foreach (DataGridViewRow row in dgvEmergencyMaintenance.Rows)
{
string assetSN = row.Cells["AssetSN"].Value.ToString();
string assetName = row.Cells["AssetName"].Value.ToString();
string assetID = (from x in db.Assets where assetSN == x.AssetSN && assetName == x.AssetName select x.ID).SingleOrDefault <string>();
EmergencyMaintenance em = (from x in db.EmergencyMaintenances where assetID == x.AssetID && x.EMEndDate == null select x).FirstOrDefault <EmergencyMaintenance>();
if (em != null)
{
dgvEmergencyMaintenance.Rows[row.Index].DefaultCellStyle.BackColor = Color.Red;
}
}
}
private void btnSubmit_Click(object sender, EventArgs e)
{
Session2Entities db = new Session2Entities();
//Check date in MaskedTextBox
DateTime startDate = new DateTime(), endDate = new DateTime();
try
{
startDate = DateTime.Parse(mktStartDate.Text);
}
catch (Exception)
{
bool flag = false;
for (int i = 0; i < mktStartDate.Text.Length; i++)
{
if (mktStartDate.Text[i] <= '9' && mktStartDate.Text[i] >= '0')
{
flag = true;
break;
}
}
if (flag)
{
MessageBox.Show("Start date invalid", "Error");
}
else
{
startDate = new DateTime();
}
}
try
{
endDate = DateTime.Parse(mktCompleteOn.Text);
}
catch (Exception)
{
bool flag = false;
for (int i = 0; i < mktCompleteOn.Text.Length; i++)
{
if (mktCompleteOn.Text[i] <= '9' && mktCompleteOn.Text[i] >= '0')
{
flag = true;
break;
}
}
if (flag)
{
MessageBox.Show("End date invalid", "Error");
}
else
{
endDate = new DateTime();
}
}
//submit StartDate, CompleteDate, TextNote
if (startDate.Equals(new DateTime()))
{
MessageBox.Show("Start date is empty", "Error");
return;
}
if (!startDate.Equals(new DateTime()) && !endDate.Equals(new DateTime()))
{
if (startDate > endDate)
{
MessageBox.Show("Start date must be before Complete On date", "Error");
return;
}
}
int emid = int.Parse(dataReceived["EmergencyMaintenanceID"]);
EmergencyMaintenance one1 = (from x in db.EmergencyMaintenances where x.ID == emid select x).SingleOrDefault <EmergencyMaintenance>();
one1.EMTechnicianNote = txtNote.Text;
if (startDate.Equals(new DateTime()) == false)
{
one1.EMStartDate = startDate;
}
if (endDate.Equals(new DateTime()) == false)
{
one1.EMEndDate = endDate;
}
db.SaveChanges();
//submit dgvParts
//delete changedpart where emid
IEnumerable <ChangedPart> temp = from x in db.ChangedParts
where x.EmergencyMaintenanceID == emid
select x;
foreach (ChangedPart cp in temp)
{
db.ChangedParts.Remove(cp);
}
db.SaveChanges();
//add changedpart from dgvParts
for (int i = 0; i < dgvParts.Rows.Count; i++)
{
ChangedPart one = new ChangedPart();
one.ID = "chp" + (i + 1) * DateTime.Now.ToString().GetHashCode();
one.EmergencyMaintenanceID = int.Parse(dataReceived["EmergencyMaintenanceID"]);
one.PartID = dgvParts.Rows[i].Cells["PartID"].Value.ToString();
one.Amount = Convert.ToDouble(dgvParts.Rows[i].Cells["Amount"].Value);
db.ChangedParts.Add(one);
}
db.SaveChanges();
//LoadDataTable
LoadDataTable();
MessageBox.Show("Submit successful", "Notification");
}
