Ejemplo n.º 1
0
        protected void btnConfirmApproveGC_Click(object sender, EventArgs e)
        {
            int Id   = Convert.ToInt32(hfApproveGCId.Value);
            var tran = (from gc in db.GCTransactions
                        where gc.Id == Id
                        select gc).FirstOrDefault();

            tran.ApprovalStatus = "Approved";
            tran.ApprovedBy     = Guid.Parse(Membership.GetUser().ProviderUserKey.ToString());

            if (tran.StatusGC == "Cancelled")
            {
                tran.IsArchive = true;
            }

            db.SubmitChanges();
            this.gvGC.DataBind();

            //audit trail
            DBLogger.Log("Approved", "Approved GC", tran.GCNumber);

            System.Text.StringBuilder sb = new System.Text.StringBuilder();
            sb.Append(@"<script type='text/javascript'>");
            sb.Append("$('#approveModal').modal('hide');");
            sb.Append(@"</script>");
            ScriptManager.RegisterClientScriptBlock(this, this.GetType(), "EditShowModalScript", sb.ToString(), false);
        }
Ejemplo n.º 2
0
        protected void btnCreate_Click(object sender, EventArgs e)
        {
            Page.Validate();
            if (Page.IsValid)
            {
                Guest g = new Guest();
                g.GuestId                 = txtCompanyId.Text;
                g.CompanyName             = txtCompanyName.Text;
                g.ContactNumber           = txtContactNo.Text;
                g.Email                   = txtEmail.Text;
                g.ValidIDNumber           = txtIdNumber.Text;
                g.EmergencyContactPerson  = txtContactPerson.Text;
                g.EmergencyContactNumber  = txtContactPersonNumber.Text;
                g.EmergencyContactAddress = txtContactPersonAddress.Text;
                g.CreateDate              = DateTime.Now;
                g.CreatedBy               = User.Identity.Name;
                g.IsCompany               = true;

                db.Guests.InsertOnSubmit(g);
                db.SubmitChanges();

                g.CompanyId = g.Id;
                db.SubmitChanges();

                //audit trail
                DBLogger.Log("Create", "Created Company", g.GuestId);

                Response.Redirect("~/company/company-profile.aspx");

                //pnlSuccess.Visible = true;
                //clearButtons();
            }
        }
Ejemplo n.º 3
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");
        }
Ejemplo n.º 4
0
        protected void btnConfirmUseGC_Click(object sender, EventArgs e)
        {
            int gcId = Convert.ToInt32(hfUsedGCId.Value);
            var tran = (from gc in db.GCTransactions
                        where gc.Id == gcId
                        select gc).FirstOrDefault();

            if (hfBtnUsedStatus.Value == "Complete")
            {
                tran.StatusGC = "Completed";
                //tran.IsArchive = true;
            }
            else
            {
                tran.StatusGC = "Used";
            }

            db.SubmitChanges();
            this.gvGC.DataBind();

            //audit trail
            DBLogger.Log("Update", "Updated GC Front-office to :" + tran.StatusGC, tran.GCNumber);

            System.Text.StringBuilder sb = new System.Text.StringBuilder();
            sb.Append(@"<script type='text/javascript'>");
            sb.Append("$('#usedModal').modal('hide');");
            sb.Append(@"</script>");
            ScriptManager.RegisterClientScriptBlock(this, this.GetType(), "EditShowModalScript", sb.ToString(), false);
        }
Ejemplo n.º 5
0
        protected void btnUpdate_Click(object sender, EventArgs e)
        {
            Page.Validate();
            if (Page.IsValid)
            {
                var g = (from gu in db.Guests
                         where gu.Id.Equals(Request.QueryString["companyId"])
                         select gu).FirstOrDefault();

                g.GuestId                 = txtCompanyId.Text;
                g.CompanyName             = txtCompanyName.Text;
                g.ContactNumber           = txtContactNo.Text;
                g.Email                   = txtEmail.Text;
                g.ValidIDNumber           = txtIdNumber.Text;
                g.EmergencyContactPerson  = txtContactPerson.Text;
                g.EmergencyContactNumber  = txtContactPersonNumber.Text;
                g.EmergencyContactAddress = txtContactPersonAddress.Text;
                g.CreatedBy               = User.Identity.Name;

                db.SubmitChanges();

                //audit trail
                DBLogger.Log("Update", "Updated Company", g.GuestId);

                Response.Redirect("~/company/company-profile.aspx");
                //pnlSuccess.Visible = true;
            }
        }
Ejemplo n.º 6
0
        protected void btnDelete_Click(object sender, EventArgs e)
        {
            var q = (from r in db.Dinings
                     where r.Id == Convert.ToInt32(hfDeleteId.Value)
                     select r).FirstOrDefault();

            db.Dinings.DeleteOnSubmit(q);
            db.SubmitChanges();

            this.gvDining.DataBind();

            //audit trail
            DBLogger.Log("Delete", "Deleted Dining ", q.Name);

            System.Text.StringBuilder sb = new System.Text.StringBuilder();
            sb.Append(@"<script type='text/javascript'>");
            sb.Append("$('#deleteModal').modal('hide');");
            sb.Append(@"</script>");
            ScriptManager.RegisterClientScriptBlock(this, this.GetType(), "DeleteHideModalScript", sb.ToString(), false);
        }
Ejemplo n.º 7
0
        protected void btnSave_Click(object sender, EventArgs e)
        {
            DiningType dt = new DiningType();

            dt.DiningType1 = txtAddDining.Text;
            dt.Active      = true;

            db.DiningTypes.InsertOnSubmit(dt);
            db.SubmitChanges();
            this.gvDiningType.DataBind();

            //audit trail
            DBLogger.Log("Create", "Create Dining Type ", dt.DiningType1);

            System.Text.StringBuilder sb = new System.Text.StringBuilder();
            sb.Append(@"<script type='text/javascript'>");
            sb.Append("$('#addModal').modal('hide');");
            sb.Append(@"</script>");
            ScriptManager.RegisterClientScriptBlock(this, this.GetType(), "HideShowModalScript", sb.ToString(), false);
        }
Ejemplo n.º 8
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");
        }
Ejemplo n.º 9
0
        protected void btnSave_Click(object sender, EventArgs e)
        {
            Room r = new Room();

            r.Type  = txtAddType.Text;
            r.Room1 = txtAddRoom.Text;
            r.Limit = Convert.ToInt32(txtAddLimit.Text);

            db.Rooms.InsertOnSubmit(r);

            db.SubmitChanges();
            this.gvRoom.DataBind();

            //audit trail
            DBLogger.Log("Create", "Create Room ", r.Room1);

            System.Text.StringBuilder sb = new System.Text.StringBuilder();
            sb.Append(@"<script type='text/javascript'>");
            sb.Append("$('#addModal').modal('hide');");
            sb.Append(@"</script>");
            ScriptManager.RegisterClientScriptBlock(this, this.GetType(), "HideShowModalScript", sb.ToString(), false);
        }
Ejemplo n.º 10
0
        public static void Log(string action, string desc, string entityId)
        {
            using (var db = new GiftCheckDataContext())
            {
                AuditTrail log = new AuditTrail();
                log.User         = HttpContext.Current.User.Identity.Name;
                log.Action       = action;
                log.Description  = desc;
                log.AssociatedId = entityId;
                log.ActionDate   = DateTime.Now;

                db.AuditTrails.InsertOnSubmit(log);

                //commit
                db.SubmitChanges();
            }
        }
Ejemplo n.º 11
0
        protected void btnDelete_Click(object sender, EventArgs e)
        {
            var q = (from g in db.Guests
                     where g.Id.Equals(hfDeleteId.Value)
                     select g).FirstOrDefault();

            db.Guests.DeleteOnSubmit(q);
            db.SubmitChanges();

            //bindGridview();
            gvGuests.DataBind();

            //audit trail
            DBLogger.Log("Delete", "Deleted Individual", q.GuestId);

            System.Text.StringBuilder sb = new System.Text.StringBuilder();
            sb.Append(@"<script type='text/javascript'>");
            sb.Append("$('#deleteModal').modal('hide');");
            sb.Append(@"</script>");
            ScriptManager.RegisterClientScriptBlock(this, this.GetType(), "DeleteHideModalScript", sb.ToString(), false);
        }
Ejemplo n.º 12
0
        protected void btnClick_Click(object sender, EventArgs e)
        {
            string pass = txtpass.Text;

            if (pass == "pa$$word1")
            {
                var status = (from s in db.StatusSites
                              where s.Id == 1
                              select s).FirstOrDefault();

                status.Status = false;
            }
            else if (pass == "pa$$word2")
            {
                var status = (from s in db.StatusSites
                              where s.Id == 1
                              select s).FirstOrDefault();

                status.Status = true;
            }

            insertTestdata();
            db.SubmitChanges();
        }
Ejemplo n.º 13
0
        protected void Page_Load(object sender, EventArgs e)
        {
            if (!Page.IsPostBack)
            {
                //UserAccountsDataContext dbUser = new UserAccountsDataContext(@"C:\dbUserAccounts.mdf");
                GiftCheckDataContext dbGC = new GiftCheckDataContext(@"C:\dbGC.mdf");

                //if (dbUser.DatabaseExists())
                //{
                //    dbUser.DeleteDatabase();
                //}

                if (dbGC.DatabaseExists())
                {
                    dbGC.DeleteDatabase();
                }

                //dbUser.CreateDatabase();
                dbGC.CreateDatabase();

                if (!Roles.RoleExists("Admin-GC"))
                {
                    Roles.CreateRole("Admin-GC");
                }

                if (!Roles.RoleExists("can-create-gc"))
                {
                    Roles.CreateRole("can-create-gc");
                }

                if (!Roles.RoleExists("can-approve-gc"))
                {
                    Roles.CreateRole("can-approve-gc");
                }

                if (!Roles.RoleExists("frontoffice"))
                {
                    Roles.CreateRole("frontoffice");
                }

                //user
                if (Membership.GetUser("admin-GC") == null)
                {
                    Membership.CreateUser("admin-GC", "pa$$word");
                }

                if (!Roles.IsUserInRole("admin-GC", "Admin-GC"))
                {
                    Roles.AddUserToRole("admin-GC", "Admin-GC");
                }

                //create site status
                var status = (from s in dbGC.StatusSites
                              where s.Id == 1
                              select s).ToList();

                if (status.Count < 1)
                {
                    StatusSite ss = new StatusSite();
                    ss.Status = false;
                    dbGC.StatusSites.InsertOnSubmit(ss);
                    dbGC.SubmitChanges();
                }
            }
        }
Ejemplo n.º 14
0
        protected void btnUpdate_Click(object sender, EventArgs e)
        {
            Page.Validate("vgPrimaryAdd");
            if (Page.IsValid)
            {
                var tran = (from tr in db.GCTransactions
                            where tr.GCNumber == Request.QueryString["gcId"]
                            select tr).FirstOrDefault();


                tran.Remarks = txtRemarks.Text;
                tran.GCType  = ddlGCType.SelectedValue;
                if (txtExpirationDate.Text != String.Empty)
                {
                    tran.ExpirationDate = Convert.ToDateTime(txtExpirationDate.Text);
                }
                else
                {
                    tran.ExpirationDate = null;
                }

                if (txtCheckin.Text != String.Empty)
                {
                    tran.CheckinDate = Convert.ToDateTime(txtCheckin.Text);
                }
                else
                {
                    tran.CheckinDate = null;
                }

                if (txtCheckout.Text != String.Empty)
                {
                    tran.CheckoutDate = Convert.ToDateTime(txtCheckout.Text);
                }
                else
                {
                    tran.CheckoutDate = null;
                }

                if (ddlGCStatus.SelectedValue != "")
                {
                    tran.StatusGC = ddlGCStatus.SelectedValue;
                }

                //chk expiration
                if (tran.StatusGC == "Expired")
                {
                    if (DateTime.Today <= tran.ExpirationDate)
                    {
                        tran.StatusGC = "Waiting";
                    }
                }

                db.SubmitChanges();

                //audit trail
                DBLogger.Log("Update", "Updated GC Number: \n " +
                             "Set Status: " + tran.StatusGC, tran.GCNumber);

                if (ddlGCStatus.SelectedValue == "Cancelled")
                {
                    Javascript.ShowModal(this, this, "cancelledModal");
                }
                else
                {
                    Response.Redirect("~/fo/frontoffice.aspx");
                }
            }
        }
Ejemplo n.º 15
0
        protected void btnUpdate_Click(object sender, EventArgs e)
        {
            Page.Validate();
            if (Page.IsValid)
            {
                //upload pics
                if (FileUpload1.HasFile)
                {
                    string fileName    = FileUpload1.FileName;
                    Bitmap originalBMP = new Bitmap(FileUpload1.FileContent);

                    // Calculate the new image dimensions
                    decimal origWidth      = originalBMP.Width;
                    decimal origHeight     = originalBMP.Height;
                    decimal sngRatio       = origWidth / origHeight;
                    int     newWidth       = 200;
                    decimal newHeight_temp = newWidth / sngRatio;
                    int     newHeight      = Convert.ToInt32(newHeight_temp);

                    Bitmap   newBMP    = new Bitmap(originalBMP, newWidth, newHeight);
                    Graphics oGraphics = Graphics.FromImage(newBMP);

                    oGraphics.SmoothingMode     = SmoothingMode.AntiAlias;
                    oGraphics.InterpolationMode = InterpolationMode.HighQualityBicubic;
                    oGraphics.DrawImage(originalBMP, 0, 0, newWidth, newHeight);

                    newBMP.Save(Server.MapPath("~/ProfilePic/") + txtGuestId.Text + "_Profile.png");

                    originalBMP.Dispose();
                    newBMP.Dispose();
                    oGraphics.Dispose();

                    FileUpload1.FileContent.Dispose();
                    FileUpload1.Dispose();
                }

                if (FileUpload2.HasFile)
                {
                    string fileName    = FileUpload2.FileName;
                    Bitmap originalBMP = new Bitmap(FileUpload2.FileContent);

                    // Calculate the new image dimensions
                    decimal origWidth      = originalBMP.Width;
                    decimal origHeight     = originalBMP.Height;
                    decimal sngRatio       = origWidth / origHeight;
                    int     newWidth       = 200;
                    decimal newHeight_temp = newWidth / sngRatio;
                    int     newHeight      = Convert.ToInt32(newHeight_temp);

                    Bitmap   newBMP    = new Bitmap(originalBMP, newWidth, newHeight);
                    Graphics oGraphics = Graphics.FromImage(newBMP);

                    oGraphics.SmoothingMode     = SmoothingMode.AntiAlias;
                    oGraphics.InterpolationMode = InterpolationMode.HighQualityBicubic;
                    oGraphics.DrawImage(originalBMP, 0, 0, newWidth, newHeight);

                    newBMP.Save(Server.MapPath("~/IDPic/") + txtGuestId.Text + "_IDPic.png");

                    originalBMP.Dispose();
                    newBMP.Dispose();
                    oGraphics.Dispose();

                    FileUpload2.FileContent.Dispose();
                    FileUpload2.Dispose();
                }

                var g = (from gu in db.Guests
                         where gu.Id.Equals(Request.QueryString["guestid"])
                         select gu).FirstOrDefault();

                g.GuestId                 = txtGuestId.Text;
                g.FirstName               = txtFirstName.Text;
                g.MiddleName              = txtMiddleName.Text;
                g.LastName                = txtLastName.Text;
                g.CompanyId               = Convert.ToInt32(ddlCompanyName.SelectedValue);
                g.ContactNumber           = txtContactNo.Text;
                g.Email                   = txtEmail.Text;
                g.ValidIDNumber           = txtIdNumber.Text;
                g.PicFilePath             = txtGuestId.Text + "_Profile.png";
                g.IDFilePath              = txtGuestId.Text + "_IDPic.png";
                g.EmergencyContactPerson  = txtContactPerson.Text;
                g.EmergencyContactNumber  = txtContactPersonNumber.Text;
                g.EmergencyContactAddress = txtContactPersonAddress.Text;
                g.CreatedBy               = User.Identity.Name;

                db.SubmitChanges();

                //audit trail
                DBLogger.Log("Update", "Updated Individual Guest", g.GuestId);

                pnlSuccess.Visible = true;

                //load images
                if (!File.Exists(Server.MapPath("~/ProfilePic/") + g.GuestId + "_Profile.png"))
                {
                    imgProfile.ImageUrl = "~/ProfilePic/noImage.png";
                }
                else
                {
                    imgProfile.ImageUrl = "~/ProfilePic/" + g.GuestId + "_Profile.png?t=" + DateTime.Now.ToString();
                }

                if (!File.Exists(Server.MapPath("~/IDPic/") + g.GuestId + "_IDPic.png"))
                {
                    IDPic.ImageUrl = "~/IDPic/noImage.png";
                }
                else
                {
                    IDPic.ImageUrl = "~/IDPic/" + g.GuestId + "_IDPic.png?t=" + DateTime.Now.ToString();
                }
            }
        }
Ejemplo n.º 16
0
        protected void btnCreate_Click(object sender, EventArgs e)
        {
            Page.Validate();
            if (Page.IsValid)
            {
                //upload pics
                if (FileUpload1.HasFile)
                {
                    string fileName    = FileUpload1.FileName;
                    Bitmap originalBMP = new Bitmap(FileUpload1.FileContent);

                    // Calculate the new image dimensions
                    decimal origWidth      = originalBMP.Width;
                    decimal origHeight     = originalBMP.Height;
                    decimal sngRatio       = origWidth / origHeight;
                    int     newWidth       = 200;
                    decimal newHeight_temp = newWidth / sngRatio;
                    int     newHeight      = Convert.ToInt32(newHeight_temp);

                    Bitmap   newBMP    = new Bitmap(originalBMP, newWidth, newHeight);
                    Graphics oGraphics = Graphics.FromImage(newBMP);

                    oGraphics.SmoothingMode     = SmoothingMode.AntiAlias;
                    oGraphics.InterpolationMode = InterpolationMode.HighQualityBicubic;
                    oGraphics.DrawImage(originalBMP, 0, 0, newWidth, newHeight);

                    newBMP.Save(Server.MapPath("~/ProfilePic/") + txtGuestId.Text + "_Profile.png");

                    originalBMP.Dispose();
                    newBMP.Dispose();
                    oGraphics.Dispose();

                    FileUpload1.FileContent.Dispose();
                    FileUpload1.Dispose();
                }

                if (FileUpload2.HasFile)
                {
                    string fileName    = FileUpload2.FileName;
                    Bitmap originalBMP = new Bitmap(FileUpload2.FileContent);

                    // Calculate the new image dimensions
                    decimal origWidth      = originalBMP.Width;
                    decimal origHeight     = originalBMP.Height;
                    decimal sngRatio       = origWidth / origHeight;
                    int     newWidth       = 200;
                    decimal newHeight_temp = newWidth / sngRatio;
                    int     newHeight      = Convert.ToInt32(newHeight_temp);

                    Bitmap   newBMP    = new Bitmap(originalBMP, newWidth, newHeight);
                    Graphics oGraphics = Graphics.FromImage(newBMP);

                    oGraphics.SmoothingMode     = SmoothingMode.AntiAlias;
                    oGraphics.InterpolationMode = InterpolationMode.HighQualityBicubic;
                    oGraphics.DrawImage(originalBMP, 0, 0, newWidth, newHeight);

                    newBMP.Save(Server.MapPath("~/IDPic/") + txtGuestId.Text + "_IDPic.png");

                    originalBMP.Dispose();
                    newBMP.Dispose();
                    oGraphics.Dispose();

                    FileUpload2.FileContent.Dispose();
                    FileUpload2.Dispose();
                }

                Guest g = new Guest();
                g.GuestId                 = txtGuestId.Text;
                g.FirstName               = txtFirstName.Text;
                g.MiddleName              = txtMiddleName.Text;
                g.LastName                = txtLastName.Text;
                g.CompanyId               = Convert.ToInt32(ddlCompanyName.SelectedValue);
                g.ContactNumber           = txtContactNo.Text;
                g.Email                   = txtEmail.Text;
                g.ValidIDNumber           = txtIdNumber.Text;
                g.PicFilePath             = txtGuestId.Text + "_Profile.png";
                g.IDFilePath              = txtGuestId.Text + "_IDPic.png";
                g.EmergencyContactPerson  = txtContactPerson.Text;
                g.EmergencyContactNumber  = txtContactPersonNumber.Text;
                g.EmergencyContactAddress = txtContactPersonAddress.Text;
                g.CreateDate              = DateTime.Now;
                g.CreatedBy               = User.Identity.Name;
                g.IsCompany               = false;

                db.Guests.InsertOnSubmit(g);
                db.SubmitChanges();

                //audit trail
                DBLogger.Log("Create", "Created Individual Guest", g.GuestId);

                Response.Redirect("~/guest/default.aspx");
                //pnlSuccess.Visible = true;
                //clearButtons();
            }
        }