コード例 #1
0
        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");
        }
コード例 #2
0
        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");
        }