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"); } }