WEB_CORE/Swift.web/SwiftSystem/UserManagement/AdminUserSetup/UserZoneMapping.aspx.cs

using Swift.DAL.BL.SwiftSystem;
using Swift.DAL.SwiftDAL;
using Swift.web.Component.Grid;
using Swift.web.Component.Grid.gridHelper;
using Swift.web.Library;
using System;
using System.Collections.Generic;
using System.Data;
using System.Linq;
using System.Web;
using System.Web.UI;
using System.Web.UI.WebControls;

namespace Swift.web.SwiftSystem.UserManagement.AdminUserSetup
{
    public partial class UserZoneMapping : System.Web.UI.Page
    {
        private const string GridName = "grd_user_zone";
        private const string ViewFunctionId = "10101300";
        private readonly SwiftGrid grid = new SwiftGrid();
        private readonly UserGroupMappingDao _obj = new UserGroupMappingDao();
        private readonly RemittanceLibrary _sl = new RemittanceLibrary();
        private readonly StaticDataDdl _sdd = new StaticDataDdl();
        protected void Page_Load(object sender, EventArgs e)
        {
            Authenticate();
            if (!IsPostBack)
            {
                GetStatic.PrintMessage(Page);
                PopulateDdl(null);
                if (GetId() > 0)
                {
                    PopulateDataById();
                }
            }
            DeleteRow();
            LoadGrid();
        }
        private void PopulateDdl(DataRow dr)
        {
            string sql = "EXEC proc_countryStateMaster @flag = 'csl', @countryId = '151'";
            _sdd.SetDDL(ref zone, sql, "stateName", "stateName", GetStatic.GetRowData(dr, "zoneName"), "Select");
        }

        private void PopulateDataById()
        {
            DataRow dr = _obj.SelectByIdUserZone(GetStatic.GetUser(), GetId().ToString());
            if (dr == null)
                return;
            PopulateDdl(dr);
        }
        private void Authenticate()
        {
            _sl.CheckAuthentication(ViewFunctionId);
        }
        protected long GetId()
        {
            return GetStatic.ReadNumericDataFromQueryString("id");
        }
        protected long GetUserId()
        {
            return GetStatic.ReadNumericDataFromQueryString("userId");
        }
        protected string GetUserName()
        {
            return GetStatic.ReadQueryString("userName", "");
        }
        private void ManageMessage(DbResult dbResult)
        {
            GetStatic.SetMessage(dbResult);
            if (dbResult.ErrorCode == "0")
                Response.Redirect("UserZoneMapping.aspx?userId=" + GetUserId() + "&userName=" + GetUserName());
            else
                GetStatic.AlertMessage(Page);
        }
        private void Update()
        {
            DbResult dbResult = _obj.UpdateUserZone(GetStatic.GetUser(), GetId().ToString(), zone.Text, GetUserName());
            ManageMessage(dbResult);
        }
        private void DeleteRow()
        {
            string id = grid.GetCurrentRowId(GridName);
            if (string.IsNullOrEmpty(id))
                return;
            DbResult dbResult = _obj.DeleteUserZone(GetStatic.GetUser(), id);
            ManageMessage(dbResult);
        }
        private void LoadGrid()
        {
            grid.ColumnList = new List<GridColumn>
                                  {
                                      new GridColumn("userFullName", "User Full Name", "", "T"),
                                      new GridColumn("userName", "UserName", "", "T"),
                                      new GridColumn("zoneName", "Zone", "", "T"),
                                      new GridColumn("createdBy", "Created By", "", "T"),
                                      new GridColumn("createdDate", "Created Date", "", "T")
                                  };

            grid.GridName = GridName;
            grid.GridType = 1;
            grid.DisableJsFilter = true;
            grid.DisableSorting = true;
            grid.ShowAddButton = true;
            grid.ShowFilterForm = false;
            grid.ShowPagingBar = true;
            grid.AddButtonTitleText = "Add New";
            grid.RowIdField = "id";
            grid.AddPage = "UserZoneMapping.aspx?userId=" + GetUserId() + "&userName=" + _sl.FilterString(GetUserName());
            grid.GridDataSource = SwiftGrid.GridDS.RemittanceDB;
            grid.AllowEdit = true;
            grid.AllowDelete = true;
            grid.GridWidth = 1020;
            string sql = "EXEC proc_userZoneMapping @flag = 's', @userName = " + _sl.FilterString(GetUserName());
            grid.SetComma();
            rpt_grid.InnerHtml = grid.CreateGrid(sql);
        }
        protected void bntSubmit_Click(object sender, EventArgs e)
        {
            Update();
        }
    }
}