public async Task <ActionResult> Edit(ManageRegionModel Region)
        {
            Region.EventAction = 'U';
            Region.UserId      = CurrentUser.UserId;
            var response = await _Region.AddUpdateRegion(Region);

            TempData["response"] = response;
            return(RedirectToAction("Index"));
        }
        public async Task <ActionResult> Create()
        {
            ManageRegionModel MR = new ManageRegionModel();

            MR.StateList = new SelectList(_Dropdown.BindState(), "Value", "Text");
            if (CurrentUser.UserTypeName.ToLower() == "super admin")
            {
                MR.IsAdmin     = true;
                MR.CompanyList = new SelectList(await CommonModel.GetCompanies(), "Name", "Text");
            }
            return(View(MR));
        }
        public async Task <ActionResult> Create(ManageRegionModel Region)
        {
            Region.EventAction = 'I';
            Region.UserId      = CurrentUser.UserId;
            if (CurrentUser.UserTypeName.ToLower() == "company")
            {
                Region.CompanyId = CurrentUser.CompanyId;
            }
            var response = await _Region.AddUpdateRegion(Region);

            TempData["response"] = response;
            return(RedirectToAction("Index"));
        }
예제 #4
0
        public async Task <ResponseModel> AddUpdateRegion(ManageRegionModel Region)
        {
            var statesList = new List <StateModel>();

            if (Region.SelectedStates != null)
            {
                for (int i = 0; i < Region.SelectedStates.Count; i++)
                {
                    var state = new StateModel {
                        St_ID = Region.SelectedStates[i].ToString()
                    };
                    statesList.Add(state);
                }
            }
            string xml = "";

            if (Region.SelectedStates != null)
            {
                XmlSerializer StateDetails = new XmlSerializer(statesList.GetType());

                using (var sww = new StringWriter())
                {
                    using (XmlWriter writer = XmlWriter.Create(sww))
                    {
                        StateDetails.Serialize(writer, statesList);
                        xml = sww.ToString();
                    }
                }
                xml = xml.Replace("<?xml version=\"1.0\" encoding=\"utf-16\"?>", "");
            }

            List <SqlParameter> sp    = new List <SqlParameter>();
            SqlParameter        param = new SqlParameter("@REGIONID", ToDBNull(Region.RegionId));

            sp.Add(param);
            param = new SqlParameter("@REGIONNAME", ToDBNull(Region.RegionName));
            sp.Add(param);

            param = new SqlParameter("@REMARKS", ToDBNull(Region.Remarks));
            sp.Add(param);

            param = new SqlParameter("@User", ToDBNull(Region.UserId));
            sp.Add(param);
            param = new SqlParameter("@CompId", ToDBNull(Region.CompanyId));
            sp.Add(param);
            param = new SqlParameter("@STATEXML", ToDBNull(xml));
            sp.Add(param);
            param = new SqlParameter("@Action", (object)Region.EventAction);
            sp.Add(param);
            param = new SqlParameter("@IsActive", (object)(Region.IsActive));
            sp.Add(param);
            var sql = "ADDOREDITREGION @REGIONID,@REGIONNAME,@REMARKS,@User,@CompId, @STATEXML,@Action,@IsActive";
            var res = await _Context.Database.SqlQuery <ResponseModel>(sql, sp.ToArray()).SingleOrDefaultAsync();

            if (res.ResponseCode == 0)
            {
                res.IsSuccess = true;
            }
            else
            {
                res.IsSuccess = false;
            }
            return(res);
        }