Example #1
0
        /// <summary>
        /// Load data
        /// </summary>
        private void LoadData()
        {
            BD_VisitorData data = new BD_VisitorData();
            ITransaction tran = factory.GetLoadObject(data, id);
            Execute(tran);
            if (!HasError)
            {
                //Get Data
                data = (BD_VisitorData)tran.Result;
                txtId.Text = data.id;
                txtName.Text = data.Name;
                txtAddress.Text = data.Address;
                txtContact.Text = data.Contact;
                txtPhone.Text = data.Phone;
                txtVisitDate.Text = Func.Formatdmyhms(data.VisitDate);
                txtComment.Text = data.Comment;
                chkDelFlag.Checked = "1".Equals(data.DelFlag) ? false : true;

                txtRequiredRegion.Text = data.RequiredRegion;
                txtRequiredFloor.Text = data.RequiredFloor;
                txtRequiredArea.Text = data.RequiredArea;
                txtBroker.Text = data.Broker;

                lblCreated.Text = !"".Equals(data.Created) ? data.CreatedBy + "(" + Func.Formatdmyhms(data.Created) + ")" : "";
                lblModified.Text = !"".Equals(data.Modified) ? data.ModifiedBy + "(" + Func.Formatdmyhms(data.Modified) + ")" : "";

                hidId.Value = id;
            }
        }
Example #2
0
        /// <summary>
        /// Update
        /// </summary>
        private void UpdateData()
        {
            BD_VisitorData data = new BD_VisitorData();
            ITransaction tran = factory.GetLoadObject(data, txtId.Text.Trim());
            Execute(tran);
            if (!HasError)
            {
                //Get Data
                data = (BD_VisitorData)tran.Result;
                data.Name = txtName.Text.Trim();
                data.Address = txtAddress.Text.Trim();
                data.Contact = txtContact.Text.Trim();
                data.Phone = txtPhone.Text.Trim();
                data.VisitDate = Func.FormatYYYYmmdd(txtVisitDate.Text.Trim().Substring(0,10));
                data.Comment = txtComment.Text.Trim();

                data.RequiredRegion = txtRequiredRegion.Text.Trim();
                data.RequiredFloor = txtRequiredFloor.Text.Trim();
                data.RequiredArea = txtRequiredArea.Text.Trim().Replace(',', '.');

                data.ModifiedBy = Page.User.Identity.Name;
                data.Modified = DateTime.Now.ToString("yyyyMMddHHmmss");
                data.DelFlag = true.Equals(chkDelFlag.Checked) ? "0" : "1";
                data.Broker = txtBroker.Text.Trim();

                tran = factory.GetUpdateObject(data);

                Execute(tran);

                if (!HasError)
                {
                    OperationLogger.WriteInfo(Constants.LogOperationAlbumId, Constants.LogActionUpdateId, updateSuccess, Page.User.Identity.Name);
                    mvMessage.SetCompleteMessage(updateSuccess);
                    ScriptManager.RegisterClientScriptBlock(this.btnRegister, this.GetType(), key, postback, true);

                    lblCreated.Text = !"".Equals(data.Created) ? data.CreatedBy + "(" + Func.Formatdmyhms(data.Created) + ")" : "";
                    lblModified.Text = !"".Equals(data.Modified) ? data.ModifiedBy + "(" + Func.Formatdmyhms(data.Modified) + ")" : "";
                }
                else
                {
                    OperationLogger.WriteError(Constants.LogOperationAlbumId, Constants.LogActionUpdateId, updateUnSuccess, Page.User.Identity.Name);
                    //mvMessage.AddError(updateUnSuccess);
                }
            }
        }
Example #3
0
        /// <summary>
        /// Insert data
        /// </summary>
        private void InsertData()
        {
            //Get and Insert Data
            BD_VisitorData data = new BD_VisitorData();
            ITransaction tran = factory.GetInsertObject(data);
            data.Name = txtName.Text.Trim();
            data.Address = txtAddress.Text.Trim();
            data.Contact = txtContact.Text.Trim();
            data.Phone = txtPhone.Text.Trim();
            data.VisitDate = Func.FormatYYYYmmdd(txtVisitDate.Text.Trim().Substring(0,10));
            data.Comment = txtComment.Text.Trim();

            data.RequiredRegion = txtRequiredRegion.Text.Trim();
            data.RequiredFloor = txtRequiredFloor.Text.Trim();
            data.RequiredArea = txtRequiredArea.Text.Trim().Replace(',','.');

            data.ModifiedBy = Page.User.Identity.Name;
            data.CreatedBy = Page.User.Identity.Name;
            data.Created = DateTime.Now.ToString("yyyyMMddHHmmss");
            data.Modified = DateTime.Now.ToString("yyyyMMddHHmmss");
            data.DelFlag = true.Equals(chkDelFlag.Checked) ? "0" : "1";
            //data.VisitorId = txtId.Text.Trim();
            data.Broker = txtBroker.Text.Trim();
            data.BuildingId = Func.ParseString(Session["__BUILDINGID__"]);

            Execute(tran);

            if (!HasError)
            {
                OperationLogger.WriteInfo(Constants.LogOperationAlbumId, Constants.LogActionInsertId, addSuccess, Page.User.Identity.Name);
                mvMessage.SetCompleteMessage(addSuccess);
                ScriptManager.RegisterClientScriptBlock(this.btnRegister, this.GetType(), key, postback, true);

                btnRegister.CommandName = "Register";
                hidId.Value = data.id;
                hidAction.Value = "Edit";

                txtId.Enabled = false;

                lblCreated.Text = !"".Equals(data.Created) ? data.CreatedBy + "(" + Func.Formatdmyhms(data.Created) + ")" : "";
                lblModified.Text = !"".Equals(data.Modified) ? data.ModifiedBy + "(" + Func.Formatdmyhms(data.Modified) + ")" : "";
            }
            else
            {
                OperationLogger.WriteError(Constants.LogOperationAlbumId, Constants.LogActionInsertId, addUnSuccess, Page.User.Identity.Name);
                mvMessage.AddError(addUnSuccess);
            }
        }