protected void btnSave_Click(object sender, EventArgs e) { GCTransaction gc = (from tr in db.GCTransactions where tr.GCNumber == Request.QueryString["gcId"] select tr).FirstOrDefault(); //chk if modified gc number from prev if (txtGCNumber.Text != hfGCNumber.Value) { var gcs = (from gctran in db.GCTransactions where gctran.GCNumber == txtGCNumber.Text.Trim() select gctran).ToList(); if (gcs.Count > 0) { //show duplicate gc Javascript.ShowModal(this, this, "duplicateGCModal"); } else { gc.GCNumber = txtGCNumber.Text; } } gc.DateIssued = Convert.ToDateTime(txtDateIssued.Text); gc.GCType = ddlGCType.SelectedItem.Text; if (txtExpirationDate.Text != String.Empty) { gc.ExpirationDate = Convert.ToDateTime(txtExpirationDate.Text); } else { gc.ExpirationDate = null; } gc.Remarks = txtRemarks.Text; //gc.RequestedBy = txtRequestedBy.Text; //chk if rooms if (gc.RoomId != null) { gc.RoomId = Convert.ToInt32(ddlRooms.SelectedValue); gc.WithBreakfast = Convert.ToBoolean(rblRoomBreakfast.SelectedValue); gc.HeadCount = Convert.ToInt32(txtRoomHeadCount.Text); } else if (gc.DiningId != null) { gc.DiningId = Convert.ToInt32(ddlDining.SelectedValue); gc.DiningTypeId = Convert.ToInt32(ddlDiningType.SelectedValue); gc.HeadCount = Convert.ToInt32(txtDiningHeadCount.Text); } db.SubmitChanges(); //audit trail DBLogger.Log("Update", "Updated GC", gc.GCNumber); Response.Redirect("~/gcapproval/default.aspx"); }
protected void btnSave_Click(object sender, EventArgs e) { //insert rooms var tmpRoom = (from tmp in db.tmpRooms where tmp.UserId == Guid.Parse(Membership.GetUser().ProviderUserKey.ToString()) select tmp).ToList(); foreach (var t in tmpRoom) { GCTransaction tran = new GCTransaction(); tran.GuestId = Convert.ToInt32(Request.QueryString["guestid"]); tran.Property = t.Property; tran.GCNumber = t.GCNumber; tran.DateIssued = Convert.ToDateTime(txtDateIssued.Text); tran.GCType = ddlGCType.SelectedItem.Text; if (txtExpirationDate.Text != String.Empty) { tran.ExpirationDate = Convert.ToDateTime(txtExpirationDate.Text); } tran.CreatedBy = Guid.Parse(Membership.GetUser().ProviderUserKey.ToString()); tran.StatusGC = "Pending"; tran.ApprovalStatus = "Pending"; tran.IsArchive = false; tran.RoomId = t.RoomId; tran.DiningId = t.DiningId; tran.DiningTypeId = t.DiningTypeId; tran.WithBreakfast = t.WithBreakfast; tran.HeadCount = t.HeadCount; tran.Remarks = t.Remarks; db.GCTransactions.InsertOnSubmit(tran); db.SubmitChanges(); //audit trail DBLogger.Log("Create", "Created GC", tran.GCNumber); } Response.Redirect("~/guest/default.aspx"); }