예제 #1
0
        private void setData()
        {
            cTitle  oTitle = new cTitle();
            DataSet ds = new DataSet();
            string  strMessage = string.Empty, strCriteria = string.Empty;
            string  strTitle_code  = string.Empty,
                    strTitle_name  = string.Empty,
                    strC_active    = string.Empty,
                    strCreatedBy   = string.Empty,
                    strUpdatedBy   = string.Empty,
                    strCreatedDate = string.Empty,
                    strUpdatedDate = string.Empty;

            try
            {
                strCriteria = " and title_code = '" + ViewState["title_code"].ToString() + "' ";
                if (!oTitle.SP_SEL_TITLE(strCriteria, ref ds, ref strMessage))
                {
                    lblError.Text = strMessage;
                }
                else
                {
                    if (ds.Tables[0].Rows.Count > 0)
                    {
                        #region get Data
                        strTitle_code  = ds.Tables[0].Rows[0]["title_code"].ToString();
                        strTitle_name  = ds.Tables[0].Rows[0]["title_name"].ToString();
                        strC_active    = ds.Tables[0].Rows[0]["c_active"].ToString();
                        strCreatedBy   = ds.Tables[0].Rows[0]["c_created_by"].ToString();
                        strUpdatedBy   = ds.Tables[0].Rows[0]["c_updated_by"].ToString();
                        strCreatedDate = ds.Tables[0].Rows[0]["d_created_date"].ToString();
                        strUpdatedDate = ds.Tables[0].Rows[0]["d_updated_date"].ToString();
                        #endregion

                        #region set Control
                        txttitle_code.Text = strTitle_code;
                        txttitle_name.Text = strTitle_name;
                        if (strC_active.Equals("Y"))
                        {
                            txttitle_name.ReadOnly = false;
                            txttitle_name.CssClass = "textbox";
                            chkStatus.Checked      = true;
                        }
                        else
                        {
                            txttitle_name.ReadOnly = true;
                            txttitle_name.CssClass = "textboxdis";
                            chkStatus.Checked      = false;
                        }
                        txtUpdatedBy.Text   = strUpdatedBy;
                        txtUpdatedDate.Text = strUpdatedDate;
                        #endregion
                    }
                }
            }
            catch (Exception ex)
            {
                lblError.Text = ex.Message.ToString();
            }
        }
예제 #2
0
        protected void GridView1_RowDeleting(object sender, GridViewDeleteEventArgs e)
        {
            string strMessage    = string.Empty;
            string strCheck      = string.Empty;
            string strScript     = string.Empty;
            string strUpdatedBy  = Session["username"].ToString();
            Label  lbltitle_code = (Label)GridView1.Rows[e.RowIndex].FindControl("lbltitle_code");
            cTitle oTitle        = new cTitle();

            try
            {
                if (!oTitle.SP_DEL_TITLE(lbltitle_code.Text, "N", strUpdatedBy, ref strMessage))
                {
                    lblError.Text = strMessage;
                }
            }
            catch (Exception ex)
            {
                lblError.Text = ex.Message.ToString();
            }
            finally
            {
                oTitle.Dispose();
            }
            BindGridView(0);
        }
예제 #3
0
        /// <summary>
        /// Creates a cTitle object. It will be saved in permanent storage only
        /// on calling Save()
        /// </summary>
        /// <returns>cTitle object</returns>
        public static cTitle Create()
        {
            cTitle oObj = new cTitle();

            SecurityCheck((int)enTitle_Action.Create);

            // Create an object in memory, will be saved to storage on calling Save()
            oObj.m_bCreating = true;
            oObj.m_bInvalid  = false;
            return(oObj);
        }
예제 #4
0
        /// <summary>
        /// Ensures that an object with the specified name exists, while creating other properties are set to their default values
        /// </summary>
        /// <param name="i_sName">Name</param>
        /// <returns>cTitle object</returns>
        public static cTitle CreateIfRequiredAndGet(string i_sName)
        {
            cTitle oObj = cTitle.Get_Name(i_sName);

            if (oObj == null)
            {
                oObj       = cTitle.Create();
                oObj.sName = i_sName;
                oObj.Save();
            }
            return(oObj);
        }
예제 #5
0
        /// <summary>
        /// Finds and return cTitle objects matching the specified criteria
        /// </summary>
        /// <param name="i_oFilter">Filter criteria (WHERE clause)</param>
        /// <returns>cTitle objects</returns>
        public static List <cTitle> Find(cFilter i_oFilter)
        {
            DataTable     dt = Find_DataTable(i_oFilter, null);
            List <cTitle> l  = new List <cTitle>();
            cTitle        oObj;

            for (int i = 0; i < dt.Rows.Count; i++)
            {
                oObj                   = new cTitle();
                oObj.m_iID             = Convert.ToInt32(dt.Rows[i]["iID"]);
                oObj.m_sName           = dt.Rows[i]["sName"].ToString();
                oObj.m_dtCreatedOn     = Convert.ToDateTime(dt.Rows[i]["dtCreatedOn"]);
                oObj.m_dtLastUpdatedOn = Convert.ToDateTime(dt.Rows[i]["dtLastUpdatedOn"]);

                oObj.m_bIsActive = Convert.ToBoolean(dt.Rows[i]["bIsActive"]);
                oObj.m_bInvalid  = false;
                l.Add(oObj);
            }
            return(l);
        }
예제 #6
0
        private void BindGridView(int nPageNo)
        {
            cTitle  oTitle        = new cTitle();
            DataSet ds            = new DataSet();
            string  strMessage    = string.Empty;
            string  strCriteria   = string.Empty;
            string  strTitle_code = string.Empty;
            string  strTitle_name = string.Empty;
            string  strActive     = string.Empty;

            strTitle_code = txttitle_code.Text.Replace("'", "''").Trim();
            strTitle_name = txttitle_name.Text.Replace("'", "''").Trim();
            if (!strTitle_code.Equals("0"))
            {
                strCriteria = strCriteria + "  And  (title_code like '%" + strTitle_code + "%') ";
            }
            if (!strTitle_name.Equals("0"))
            {
                strCriteria = strCriteria + "  And  (title_name like '%" + strTitle_name + "%')";
            }
            if (RadioActive.Checked)
            {
                strCriteria = strCriteria + "  And  (c_active ='Y') ";
            }
            else if (RadioCancel.Checked)
            {
                strCriteria = strCriteria + "  And  (c_active ='N') ";
            }
            try
            {
                if (!oTitle.SP_SEL_TITLE(strCriteria, ref ds, ref strMessage))
                {
                    lblError.Text = strMessage;
                }
                else
                {
                    try
                    {
                        GridView1.PageIndex           = nPageNo;
                        txthTotalRecord.Value         = ds.Tables[0].Rows.Count.ToString();
                        ds.Tables[0].DefaultView.Sort = ViewState["sort"] + " " + ViewState["direction"];
                        GridView1.DataSource          = ds.Tables[0];
                        GridView1.DataBind();
                    }
                    catch
                    {
                        GridView1.PageIndex           = 0;
                        txthTotalRecord.Value         = ds.Tables[0].Rows.Count.ToString();
                        ds.Tables[0].DefaultView.Sort = ViewState["sort"] + " " + ViewState["direction"];
                        GridView1.DataSource          = ds.Tables[0];
                        GridView1.DataBind();
                    }
                }
            }
            catch (Exception ex)
            {
                lblError.Text = ex.Message.ToString();
            }
            finally
            {
                oTitle.Dispose();
                ds.Dispose();
                if (GridView1.Rows.Count > 0)
                {
                    GridView1.TopPagerRow.Visible = true;
                }
            }
        }
예제 #7
0
using System;
예제 #8
0
        private bool saveData()
        {
            bool   blnResult     = false;
            bool   blnDup        = false;
            string strMessage    = string.Empty;
            string strtitle_code = string.Empty,
                   strtitle_name = string.Empty,
                   strActive     = string.Empty,
                   strCreatedBy  = string.Empty,
                   strUpdatedBy  = string.Empty;
            string  strScript    = string.Empty;
            cTitle  oTitle       = new cTitle();
            DataSet ds           = new DataSet();

            try
            {
                #region set Data
                strtitle_code = txttitle_code.Text.Trim();
                strtitle_name = txttitle_name.Text;
                if (chkStatus.Checked == true)
                {
                    strActive = "Y";
                }
                else
                {
                    strActive = "N";
                }
                strCreatedBy = Session["username"].ToString();
                strUpdatedBy = Session["username"].ToString();
                #endregion
                if (ViewState["mode"].ToString().ToLower().Equals("edit"))
                {
                    #region edit
                    if (!blnDup)
                    {
                        if (oTitle.SP_UPD_TITLE(strtitle_code, strtitle_name, strActive, strUpdatedBy, ref strMessage))
                        {
                            blnResult = true;
                        }
                        else
                        {
                            lblError.Text = strMessage.ToString();
                        }
                    }
                    else
                    {
                        ScriptManager.RegisterStartupScript(Page, Page.GetType(), "frMainPage", strScript, true);
                    }
                    #endregion
                }
                else
                {
                    #region check dup
                    string strCheckDup = string.Empty;
                    strCheckDup = " and title_code = '" + strtitle_code.Trim() + "' ";
                    if (!oTitle.SP_SEL_TITLE(strCheckDup, ref ds, ref strMessage))
                    {
                        lblError.Text = strMessage;
                    }
                    else
                    {
                        if (ds.Tables[0].Rows.Count > 0)
                        {
                            strScript =
                                "alert(\"ไม่สามารถเพิ่มข้อมูล เนื่องจากข้อมูล " + strtitle_code.Trim() + " : " + strtitle_name.Trim() + "  ซ้ำ\");\n";
                            blnDup = true;
                        }
                    }
                    #endregion
                    #region insert
                    if (!blnDup)
                    {
                        if (oTitle.SP_INS_TITLE(strtitle_code, strtitle_name, strActive, strCreatedBy, ref strMessage))
                        {
                            ViewState["title_code"] = strtitle_code;
                            blnResult = true;
                        }
                        else
                        {
                            lblError.Text = strMessage.ToString();
                        }
                    }
                    else
                    {
                        ScriptManager.RegisterStartupScript(Page, Page.GetType(), "frMainPage", strScript, true);
                    }
                    #endregion
                }
            }
            catch (Exception ex)
            {
                lblError.Text = ex.Message.ToString();
            }
            finally
            {
                oTitle.Dispose();
            }
            return(blnResult);
        }