コード例 #1
0
        private void PopulatePageCntrls(int argsBGID)
        {
            Int32 iCount           = 0;
            GetSOPDataResponse ret = null;

            log4net.ILog logger = log4net.LogManager.GetLogger("File");
            try
            {
                AdminBLL   objAdminBLL = new AdminBLL();
                GetSOPData objGetBillingTableRequest = new GetSOPData();
                objGetBillingTableRequest.SOP_ID = argsBGID.ToString();

                objGetBillingTableRequest.WhereClause = " where SOP_ID =" + argsBGID.ToString();

                ret = objAdminBLL.GetSOPData(objGetBillingTableRequest);

                hdnBTID.Value = ret.SOPNo[iCount].SOP_ID.ToString();
                hdnBTID.Value = ret.SOPNo[iCount].SOP_Title.ToString();
                hdnBTID.Value = ret.SOPNo[iCount].SOP_Subject.ToString();
                hdnBTID.Value = ret.SOPNo[iCount].ImagePathName.ToString();
                hdnBTID.Value = ret.SOPNo[iCount].Location.ToString();

                txtUpdateSOPNo.Text      = ret.SOPNo[iCount].SOP_ID.ToString();
                txtUpdateSOPTitle.Text   = ret.SOPNo[iCount].SOP_Title.ToString();
                txtUpdateSOPSubject.Text = ret.SOPNo[iCount].SOP_Subject.ToString();
                //ddllocation.Items.Insert(0,ret.SOPNo[iCount].Location.ToString());

                Session.Add("ImagePath", ret.SOPNo[iCount].ImagePathName.ToString());
            }
            catch (Exception ex)
            {
                logger.Info(ex.Message);
            }
        }
コード例 #2
0
        private void BindGridWithFilter()
        {
            log4net.ILog logger = log4net.LogManager.GetLogger("File");
            try
            {
                getLocationIDByName(ddllocation.Text.Trim());
                AdminBLL   ws     = new AdminBLL();
                GetSOPData objReq = new GetSOPData();
                if (ddllocation.Text.ToString() == "")
                {
                }
                else
                {
                    objReq.WhereClause = " Where Location = '" + searchid.Text + "' ";
                }

                GetSOPDataResponse ret = ws.GetSOPData(objReq);
                int pageSize           = ContextKeys.GRID_PAGE_SIZE;
                gvSOPTable.PageSize   = pageSize;
                gvSOPTable.DataSource = ret.SOPNo;
                gvSOPTable.DataBind();

                // ShowHide();
            }
            catch (Exception ex)
            {
                logger.Info(ex.Message);
            }
        }
コード例 #3
0
        private void BindGridWithFilter()
        {
            log4net.ILog logger = log4net.LogManager.GetLogger("File");
            try
            {
                AdminBLL   ws     = new AdminBLL();
                GetSOPData objReq = new GetSOPData();

                string WhereClause = ReturnWhere();

                if (!string.IsNullOrEmpty(txtSOPID.Text))
                {
                    objReq.SOP_ID = txtSOPID.Text;
                }
                if (!string.IsNullOrEmpty(txtSOPSubjectSearch.Text))
                {
                    objReq.SOP_Subject = txtSOPSubjectSearch.Text;
                }
                if (!string.IsNullOrEmpty(txtSOPtitle.Text))
                {
                    objReq.SOP_Title = txtSOPtitle.Text;
                }
                if (!string.IsNullOrEmpty(WhereClause))
                {
                    objReq.WhereClause = WhereClause;
                }


                if (!string.IsNullOrEmpty(txtdatefrom.Text))
                {
                    if (string.IsNullOrEmpty(txtdateto.Text))
                    {
                        objReq.Date_From = txtdatefrom.Text;
                    }
                }
                if (!string.IsNullOrEmpty(txtdateto.Text))
                {
                    if (!string.IsNullOrEmpty(txtdatefrom.Text))
                    {
                        objReq.Date_From = txtdatefrom.Text;
                        objReq.Date_From = txtdateto.Text;
                    }
                }



                GetSOPDataResponse ret = ws.GetSOPData(objReq);
                int pageSize           = ContextKeys.GRID_PAGE_SIZE;
                gvSOPTable.PageSize   = pageSize;
                gvSOPTable.DataSource = ret.SOPNo;
                gvSOPTable.DataBind();

                ShowHide();
            }
            catch (Exception ex)
            {
                logger.Info(ex.Message);
            }
        }
コード例 #4
0
ファイル: AdminBLL.cs プロジェクト: Alpharitzi/SpaSecure
 public GetSOPDataResponse GetAllSOPData(GetSOPData objGetSOPDataRequest)
 {
     try
     {
         AdminDAL           objAdminDAL = new AdminDAL();
         GetSOPDataResponse ret         = new GetSOPDataResponse();
         List <SOP>         lst         = objAdminDAL.GetAllSOPData(objGetSOPDataRequest);
         ret.SOPNo = lst;
         return(ret);
     }
     catch (Exception ex)
     {
         throw ex;
     }
 }
コード例 #5
0
        private void PopulatePageCntrls(int argsBGID)
        {
            Int32 iCount           = 0;
            GetSOPDataResponse ret = null;

            log4net.ILog logger = log4net.LogManager.GetLogger("File");
            try
            {
                AdminBLL   objAdminBLL = new AdminBLL();
                GetSOPData objGetBillingTableRequest = new GetSOPData();
                objGetBillingTableRequest.SOP_ID = argsBGID.ToString();

                objGetBillingTableRequest.WhereClause = " where SOP_ID =" + argsBGID.ToString();

                ret = objAdminBLL.GetSOPData(objGetBillingTableRequest);

                hdnBTID.Value = ret.SOPNo[iCount].SOP_ID.ToString();
                hdnBTID.Value = ret.SOPNo[iCount].SOP_Title.ToString();
                hdnBTID.Value = ret.SOPNo[iCount].SOP_Subject.ToString();
                //hdnBTID.Value = ret.SOPNo[iCount].ImagePathName.ToString();
                hdnBTID.Value = ret.SOPNo[iCount].Location.ToString();
                cn            = db.getconnection();
                cn.Open();
                SqlCommand _cmd = new SqlCommand("select Location_name from location where Location_id=@id", cn);
                _cmd.Parameters.AddWithValue("@id", hdnBTID.Value);
                SqlDataReader dr = _cmd.ExecuteReader();
                if (dr.Read())
                {
                    ddllocation.Items.Insert(0, dr.GetString(0));
                    //========================//
                    dr.Close();
                    dr.Dispose();
                    //========================//
                    cn.Close();
                }

                txtUpdateSOPNo.Text      = ret.SOPNo[iCount].SOP_ID.ToString();
                txtUpdateSOPTitle.Text   = ret.SOPNo[iCount].SOP_Title.ToString();
                txtUpdateSOPSubject.Text = ret.SOPNo[iCount].SOP_Subject.ToString();
                Session.Add("ImagePath", ret.SOPNo[iCount].ImagePathName.ToString());
            }
            catch (Exception ex)
            {
                logger.Info(ex.Message);
            }
        }
コード例 #6
0
ファイル: SOPAdmin.aspx.cs プロジェクト: Alpharitzi/SpaSecure
        private void BindGrid()
        {
            log4net.ILog logger = log4net.LogManager.GetLogger("File");
            try
            {
                AdminBLL           ws    = new AdminBLL();
                GetSOPData         _req  = new GetSOPData();
                GetSOPDataResponse _resp = ws.GetSOPData(_req);


                gvSOPTable.DataSource = _resp.SOPNo;
                gvSOPTable.DataBind();
                ShowHide();
            }
            catch (Exception ex)
            {
                logger.Info(ex.Message);
            }
        }
コード例 #7
0
ファイル: SOPAdmin.aspx.cs プロジェクト: Alpharitzi/SpaSecure
        private void BindGridWithFilter()
        {
            log4net.ILog logger = log4net.LogManager.GetLogger("File");
            try
            {
                AdminBLL   ws     = new AdminBLL();
                GetSOPData objReq = new GetSOPData();

                // string WhereClause = ReturnWhere();

                GetSOPDataResponse ret = ws.GetSOPData(objReq);

                gvSOPTable.DataSource = ret.SOPNo;
                gvSOPTable.DataBind();

                ShowHide();
            }
            catch (Exception ex)
            {
                logger.Info(ex.Message);
            }
        }