protected void btnUpdate_Click(object sender, EventArgs e)
{
Page.Validate("vgAdd");
if (Page.IsValid)
{
var q = (from ir in dbIR.IRTransactions
where ir.Id == Convert.ToInt32(Request.QueryString["Id"])
select ir).FirstOrDefault();
q.TicketNo = txtTicketNo.Text;
q.CrisisId = Convert.ToInt32(ddlCrisis.SelectedValue);
q.From = txtFrom.Text;
q.Subject = txtSubject.Text;
q.Room = txtRoom.Text;
q.Date = Convert.ToDateTime(txtDate.Text);
q.Status = ddlStatus.SelectedValue;
q.WhenIncidentHappen = Convert.ToDateTime(txtWhenIncident.Text);
q.WhenAware = rblWhenAware.SelectedValue;
q.WhoInvolved = txtWhosInvolved.Text;
q.WhatHappened = txtWhatHappened.Text;
q.Investigation = txtInvestigation.Text;
q.ActionTaken = txtActionTaken.Text;
q.Recommendation = txtRecommendation.Text;
q.PreparedBy = Guid.Parse(Membership.GetUser().ProviderUserKey.ToString());
//chk if solved
if (ddlStatus.SelectedValue == "Solved")
{
q.DateSolved = DateTime.Now;
q.ResolvedTime = String.Format("{0} hours, {1} minutes",
DateTime.Now.Subtract(q.StartDate.Value).Hours,
DateTime.Now.Subtract(q.StartDate.Value).Minutes);
}
//dbIR.SubmitChanges();
int tranId = q.Id;
//uploaded imgs
if (FileUpload1.HasFiles)
{
foreach (HttpPostedFile postedFile in FileUpload1.PostedFiles)
{
string fileName = Path.GetFileName(postedFile.FileName);
postedFile.SaveAs(Server.MapPath("~/photo-evidence/") + tranId + "_" + fileName);
//create thumbnail
System.Drawing.Image image = System.Drawing.Image.FromFile(Server.MapPath("~/photo-evidence/") + tranId + "_" + fileName);
System.Drawing.Image bmp1 = image.GetThumbnailImage(100, 100, null, IntPtr.Zero);
bmp1.Save(Server.MapPath("~/photo-evidence/") + tranId + "_" + "thumb_" + fileName);
//record to db
EvidencePhoto ep = new EvidencePhoto();
ep.IrId = tranId;
ep.ImagePath = fileName;
dbIR.EvidencePhotos.InsertOnSubmit(ep);
}
//dbIR.SubmitChanges();
}
//delete associated depts
var deleteDepts = (from d in dbIR.DepartmentsInvolveds
where d.IRId == Convert.ToInt32(Request.QueryString["Id"])
select d).ToList();
dbIR.DepartmentsInvolveds.DeleteAllOnSubmit(deleteDepts);
//re-add selected
foreach (ListItem item in lstDepartments.Items)
{
if (item.Selected)
{
DepartmentsInvolved di = new DepartmentsInvolved();
di.IRId = Convert.ToInt32(Request.QueryString["Id"]);
di.DepartmentId = Convert.ToInt32(item.Value);
dbIR.DepartmentsInvolveds.InsertOnSubmit(di);
}
}
dbIR.SubmitChanges();
//audit trail
DBLogger.Log("Update", "Updated IR with status of: " + q.Status,
q.TicketNo);
Response.Redirect("~/ir/ir.aspx");
}
}
protected void btnSave_Click(object sender, EventArgs e)
{
Page.Validate("vgAdd");
if (Page.IsValid)
{
IRTransaction ir = new IRTransaction();
ir.TicketNo = txtTicketNo.Text;
ir.CrisisId = Convert.ToInt32(ddlCrisis.SelectedValue);
ir.From = txtFrom.Text;
ir.Subject = txtSubject.Text;
ir.Room = txtRoom.Text;
ir.Date = Convert.ToDateTime(txtDate.Text);
ir.Status = ddlStatus.SelectedValue;
ir.WhenIncidentHappen = Convert.ToDateTime(txtWhenIncident.Text);
ir.WhenAware = rblWhenAware.SelectedValue;
ir.WhoInvolved = txtWhosInvolved.Text;
ir.WhatHappened = txtWhatHappened.Text;
ir.Investigation = txtInvestigation.Text;
ir.ActionTaken = txtActionTaken.Text;
ir.Recommendation = txtRecommendation.Text;
ir.PreparedBy = Guid.Parse(Membership.GetUser().ProviderUserKey.ToString());
ir.StartDate = DateTime.Now;
dbIR.IRTransactions.InsertOnSubmit(ir);
dbIR.SubmitChanges();
//audit trail
DBLogger.Log("Create", "Created IR with initial status of: " + ir.Status,
ir.TicketNo);
int tranId = ir.Id;
//chk for uploaded photos
if (FileUpload1.HasFiles)
{
foreach (HttpPostedFile postedFile in FileUpload1.PostedFiles)
{
string fileName = Path.GetFileName(postedFile.FileName);
postedFile.SaveAs(Server.MapPath("~/photo-evidence/") + tranId + "_" + fileName);
//create thumbnail
System.Drawing.Image image = System.Drawing.Image.FromFile(Server.MapPath("~/photo-evidence/") + tranId + "_" + fileName);
System.Drawing.Image bmp1 = image.GetThumbnailImage(100, 100, null, IntPtr.Zero);
bmp1.Save(Server.MapPath("~/photo-evidence/") + tranId + "_" + "thumb_" + fileName);
//record to db
EvidencePhoto ep = new EvidencePhoto();
ep.IrId = tranId;
ep.ImagePath = fileName;
dbIR.EvidencePhotos.InsertOnSubmit(ep);
}
dbIR.SubmitChanges();
}
//insert departments involved
foreach (ListItem item in lstDepartments.Items)
{
if (item.Selected)
{
DepartmentsInvolved dept = new DepartmentsInvolved();
dept.IRId = tranId;
dept.DepartmentId = Convert.ToInt32(item.Value);
dbIR.DepartmentsInvolveds.InsertOnSubmit(dept);
}
}
dbIR.SubmitChanges();
Response.Redirect("~/ir/ir.aspx");
}
}
