示例#1
0
 public ActionResult DeleteMappingCity(string data)
 {
     if (asset.Delete)
     {
         try
         {
             string[] separators = { "@@" };
             var      listRowID  = data.Split(separators, StringSplitOptions.RemoveEmptyEntries);
             foreach (var item in listRowID)
             {
                 var check = new DC_Location_City();
                 check.CityID = item;
                 check.Delete();
             }
         }
         catch (Exception e)
         {
             ModelState.AddModelError("Error", e.Message);
             return(Json(new { success = false }));
         }
         return(Json(new { success = true }));
     }
     else
     {
         return(Json(new { success = false, alert = "You don't have permission to delete record" }));
     }
 }
示例#2
0
        public ActionResult ListRegionMappingedAll_Read([DataSourceRequest] DataSourceRequest request, string RegionID)
        {
            var data = new List <DC_Location_City>();

            data = DC_Location_City.GetDC_Location_Citys("1=1", "").Where(s => s.RegionID == RegionID).ToList();
            return(Json(data.ToDataSourceResult(request)));
        }
示例#3
0
 public ActionResult Delete(string data)
 {
     if (asset.Delete)
     {
         try
         {
             string[] separators = { "@@" };
             var      listRowID  = data.Split(separators, StringSplitOptions.RemoveEmptyEntries);
             foreach (var item in listRowID)
             {
                 var checkexist = DC_Location_City.GetDC_Location_Citys("1=1", "").Where(s => s.RegionID == item);
                 if (checkexist.Count() > 0)
                 {
                     return(Json(new { success = false, alert = "Region exist in City" }));
                 }
                 var check = new DC_Location_Region();
                 check.RegionID = item;
                 check.Delete();
             }
         }
         catch (Exception ex)
         {
             return(Json(new { success = false, alert = ex.Message }));
         }
         return(Json(new { success = true }));
     }
     else
     {
         return(Json(new { success = false, alert = "You don't have permission to delete record" }));
     }
 }
 public ActionResult City_Update([DataSourceRequest] DataSourceRequest request, [Bind(Prefix = "models")]  IEnumerable <DC_Location_City> listEx)
 {
     if (asset.Update)
     {
         try
         {
             if (listEx != null && ModelState.IsValid)
             {
                 foreach (var regis in listEx)
                 {
                     if (String.IsNullOrEmpty(regis.CityName))
                     {
                         ModelState.AddModelError("", "Please input City Name ");
                         return(Json(listEx.ToDataSourceResult(request, ModelState)));
                     }
                     //if (String.IsNullOrEmpty(regis.RegionID))
                     //{
                     //    ModelState.AddModelError("", "Please input Region Name");
                     //    return Json(listEx.ToDataSourceResult(request, ModelState));
                     //}
                     var write = new DC_Location_City();
                     var check = DC_Location_City.GetDC_Location_Citys("1=1", "").Where(s => s.CityName.Trim().ToLower() == regis.CityName.Trim().ToLower() && s.RegionID == regis.RegionID && s.Active == regis.Active);
                     if (check.Count() > 0)
                     {
                         ModelState.AddModelError("", "Region Name is exists.");
                         return(Json(listEx.ToDataSourceResult(request, ModelState)));
                     }
                     write.CityID             = regis.CityID;
                     write.CityName           = regis.CityName.Trim();
                     write.Active             = regis.Active;
                     write.RowLastUpdatedTime = DateTime.Now;
                     write.RowLastUpdatedUser = currentUser.UserName;
                     write.RegionID           = regis.RegionID != null ? regis.RegionID : "";
                     write.Update();
                 }
             }
             else
             {
                 ModelState.AddModelError("error", "");
                 return(Json(new { success = false }));
             }
         }
         catch (Exception e)
         {
             ModelState.AddModelError("error", e.Message);
             return(Json(listEx.ToDataSourceResult(request, ModelState)));
         }
     }
     else
     {
         ModelState.AddModelError("", "You don't have permission to update record");
         return(Json(listEx.ToDataSourceResult(request, ModelState)));
     }
     return(Json(listEx.ToDataSourceResult(request, ModelState)));
 }
        public ActionResult City_Read([DataSourceRequest] DataSourceRequest request)
        {
            var data = new List <DC_Location_City>();

            if (request.Filters.Any())
            {
                var where = KendoApplyFilter.ApplyFilter(request.Filters[0], "data.");
                data      = DC_Location_City.GetDC_Location_Citys(where, "CityID DESC");
            }
            else
            {
                data = DC_Location_City.GetDC_Location_Citys("1=1", "CityID DESC");
            }
            return(Json(data.ToDataSourceResult(request)));
        }
示例#6
0
        //
        // GET: /DistrictDefinition/


        public ActionResult Index()
        {
            if (asset.View)
            {
                ViewData["AllowCreate"] = asset.Create;
                ViewData["AllowUpdate"] = asset.Update;
                ViewData["AllowDelete"] = asset.Delete;
                ViewData["AllowExport"] = asset.Export;
                ViewBag.listalias       = DC_Location_Alias.GetDC_Location_Alias("1=1", "AliasName ASC");
                ViewBag.listcountry     = DC_Location_Countries.GetDC_Location_Countries("1=1", "CountryName ASC");
                ViewBag.listregion      = DC_Location_Region.GetDC_Location_Regions("1=1", "RegionName ASC");
                ViewBag.listcity        = DC_Location_City.GetDC_Location_Citys("1=1", "CityName ASC");
                return(View());
            }
            else
            {
                return(RedirectToAction("NoAccessRights", "Error"));
            }
        }
示例#7
0
 //public ActionResult ListPortalCityAll_Read([DataSourceRequest] DataSourceRequest request, string RegionID)
 //{
 //    var data = new List<DC_Location_MappingLocation>();
 //    data = DC_Location_MappingLocation.GetAllDC_Location_Portal_City(RegionID).ToList();
 //    return Json(data.ToDataSourceResult(request));
 //}
 public ActionResult SaveMappingCity(string data, string RegionID)
 {
     if (asset.Create)
     {
         try
         {
             string[] separators = { "@@" };
             var      listRowID  = data.Split(separators, StringSplitOptions.RemoveEmptyEntries);
             string   id         = "";
             //var check = new DC_Location_MappingLocation();
             var write = new DC_Location_City();
             foreach (var item in listRowID)
             {
                 //var checkClass = DC_Location_MappingLocation.GetAllDC_Location_Mappinged_City().Where(s => s.RegionID == RegionID && s.CityName == item.Trim()).FirstOrDefault();
                 //if (checkClass != null)
                 //{
                 //    ModelState.AddModelError("Error", "City exists");
                 //    return Json(new { success = false, alert = item + " exists" });
                 //}
                 //var checkID = DC_Location_MappingLocation.GetAllDC_Location_Mapping_Citys().OrderByDescending(m => m.RowID).FirstOrDefault();
                 //if (checkID != null )
                 //{
                 //    var nextNo = Int32.Parse(checkID.CityID.Substring(1, checkID.CityID.Length - 1)) + 1;
                 //    id = "A" + String.Format("{0:0000}", nextNo);
                 //}
                 //else
                 //{
                 //    id = "A0001";
                 //}
                 //check.CityID = id;
                 //check.CityName = item.Trim();
                 //check.RowCreatedUser = currentUser.UserName;
                 //check.RowCreatedTime = DateTime.Now;
                 //check.RegionID = RegionID;
                 //check.Active = true;
                 //check.Save();
                 var checkClass = DC_Location_City.GetDC_Location_Citys("1=1", "").Where(s => s.RegionID == RegionID && s.CityName == item.Trim()).FirstOrDefault();
                 if (checkClass != null)
                 {
                     ModelState.AddModelError("Error", "City exists");
                     return(Json(new { success = false, alert = item + " exists City" }));
                 }
                 var checkID = DC_Location_City.GetDC_Location_Citys("1=1", "").OrderByDescending(m => m.RowID).FirstOrDefault();
                 if (checkID != null)
                 {
                     var nextNo = Int32.Parse(checkID.CityID.Substring(1, checkID.CityID.Length - 1)) + 1;
                     id = "A" + String.Format("{0:0000}", nextNo);
                 }
                 else
                 {
                     id = "A0001";
                 }
                 write.CityID         = id;
                 write.CityName       = item.Trim();
                 write.Active         = true;
                 write.RowCreatedTime = DateTime.Now;
                 write.RowCreatedUser = currentUser.UserName;
                 write.RegionID       = RegionID != null ? RegionID : "";
                 write.Save();
             }
         }
         catch (Exception e)
         {
             ModelState.AddModelError("", e.Message);
             return(Json(new { success = false }));
         }
         return(Json(new { success = true }));
     }
     else
     {
         return(Json(new { success = false, alert = "You don't have permission to delete record" }));
     }
 }
 public ActionResult City_Create([DataSourceRequest] DataSourceRequest request, [Bind(Prefix = "models")]  IEnumerable <DC_Location_City> listEx)
 {
     if (asset.Create)
     {
         try
         {
             if (listEx != null && ModelState.IsValid)
             {
                 foreach (var regis in listEx)
                 {
                     if (String.IsNullOrEmpty(regis.CityName))
                     {
                         ModelState.AddModelError("", "Please input City Name ");
                         return(Json(listEx.ToDataSourceResult(request, ModelState)));
                     }
                     if (String.IsNullOrEmpty(regis.RegionID))
                     {
                         ModelState.AddModelError("", "Please input Region Name");
                         return(Json(listEx.ToDataSourceResult(request, ModelState)));
                     }
                     string id      = "";
                     var    write   = new DC_Location_City();
                     var    checkID = DC_Location_City.GetDC_Location_Citys("1=1", "").OrderByDescending(m => m.RowID).FirstOrDefault();
                     if (checkID != null)
                     {
                         var nextNo = Int32.Parse(checkID.CityID.Substring(1, checkID.CityID.Length - 1)) + 1;
                         id = "A" + String.Format("{0:0000}", nextNo);
                     }
                     else
                     {
                         id = "A0001";
                     }
                     var check = DC_Location_City.GetDC_Location_Citys("1=1", "").Where(s => s.CityName.Trim().ToLower() == regis.CityName.Trim().ToLower() && s.RegionID == regis.RegionID && s.Active == regis.Active).FirstOrDefault();
                     if (check != null)
                     {
                         ModelState.AddModelError("", " Region Name  is exists.");
                         return(Json(listEx.ToDataSourceResult(request, ModelState)));
                     }
                     write.CityID         = id;
                     write.CityName       = regis.CityName.Trim();
                     write.Active         = regis.Active;
                     write.RowCreatedTime = DateTime.Now;
                     write.RowCreatedUser = currentUser.UserName;
                     write.RegionID       = regis.RegionID != null ? regis.RegionID : "";
                     write.Save();
                 }
             }
             else
             {
                 ModelState.AddModelError("error", "");
                 return(Json(new { success = false }));
             }
         }
         catch (Exception e)
         {
             ModelState.AddModelError("error", e.Message);
             return(Json(listEx.ToDataSourceResult(request, ModelState)));
         }
     }
     else
     {
         ModelState.AddModelError("", "You don't have permission to create record");
         return(Json(listEx.ToDataSourceResult(request, ModelState)));
     }
     return(Json(listEx.ToDataSourceResult(request, ModelState)));
 }
        public ActionResult ImportFromExcel()
        {
            try
            {
                if (Request.Files["FileUpload"] != null && Request.Files["FileUpload"].ContentLength > 0)
                {
                    string fileExtension =
                        System.IO.Path.GetExtension(Request.Files["FileUpload"].FileName);

                    if (fileExtension == ".xlsx")
                    {
                        string fileLocation      = string.Format("{0}/{1}", Server.MapPath("~/Excel"), "[" + currentUser.UserName + "-" + DateTime.Now.ToString("yyyyMMddHHmmss") + "]" + Request.Files["FileUpload"].FileName);
                        string errorFileLocation = string.Format("{0}/{1}", Server.MapPath("~/Excel"), "[" + currentUser.UserName + "-" + DateTime.Now.ToString("yyyyMMddHHmmss") + "-Error]" + Request.Files["FileUpload"].FileName);

                        if (System.IO.File.Exists(fileLocation))
                        {
                            System.IO.File.Delete(fileLocation);
                        }

                        Request.Files["FileUpload"].SaveAs(fileLocation);
                        //Request.Files["fileUpload"].SaveAs(errorFileLocation);

                        var rownumber = 2;
                        var total     = 0;

                        FileInfo fileInfo = new FileInfo(fileLocation);
                        var      excelPkg = new ExcelPackage(fileInfo);

                        FileInfo template = new FileInfo(Server.MapPath(@"~\ExportExcelFile\DC_Location_City.xlsx"));
                        template.CopyTo(errorFileLocation);
                        FileInfo _fileInfo = new FileInfo(errorFileLocation);
                        var      _excelPkg = new ExcelPackage(_fileInfo);

                        ExcelWorksheet oSheet = excelPkg.Workbook.Worksheets["DC_Location_City"];
                        ExcelWorksheet eSheet = _excelPkg.Workbook.Worksheets["DC_Location_City"];

                        //remove row
                        int totalRows = oSheet.Dimension.End.Row;
                        for (int i = 2; i <= totalRows; i++)
                        {
                            string cityID     = oSheet.Cells[i, 1].Value != null ? oSheet.Cells[i, 1].Value.ToString() : "";
                            string cityName   = oSheet.Cells[i, 2].Value != null ? oSheet.Cells[i, 2].Value.ToString() : "";
                            string regionName = oSheet.Cells[i, 3].Value != null ? oSheet.Cells[i, 3].Value.ToString() : "";
                            //string countryName = oSheet.Cells[i, 3].Value != null ? oSheet.Cells[i, 3].Value.ToString() : "";
                            string active     = oSheet.Cells[i, 6].Value != null ? oSheet.Cells[i, 6].Value.ToString() : "TRUE";
                            string id_country = !String.IsNullOrEmpty(regionName) ? regionName.Substring(0, regionName.LastIndexOf("-")).Trim() : "";

                            try
                            {
                                var write        = new DC_Location_City();
                                var checkRegion  = DC_Location_City.GetDC_Location_Citys("[CityName] = N'" + cityName + "' AND [RegionID] = '" + id_country + "'", "").FirstOrDefault();
                                var checkCountry = DC_Location_City.GetDC_Location_Citys("[RegionID] = '" + id_country + "'", "").FirstOrDefault();
                                if (string.IsNullOrEmpty(regionName.ToString()) || string.IsNullOrEmpty(cityName.ToString()))
                                {
                                    eSheet.Cells[rownumber, 2].Value  = cityName;
                                    eSheet.Cells[rownumber, 3].Value  = regionName;
                                    eSheet.Cells[rownumber, 6].Value  = active;
                                    eSheet.Cells[rownumber, 11].Value = "regionName, countryName required";
                                    rownumber++;
                                }
                                else if (checkRegion != null)
                                {
                                    write.CityID             = cityID;
                                    write.CityName           = cityName;
                                    write.Active             = Convert.ToBoolean(active);
                                    write.RowLastUpdatedTime = DateTime.Now;
                                    write.RowLastUpdatedUser = currentUser.UserName;
                                    write.RegionID           = id_country;
                                    write.Update();
                                    total++;
                                }
                                //else if (checkCountry == null)
                                //{
                                //    eSheet.Cells[rownumber, 2].Value = cityName;
                                //    eSheet.Cells[rownumber, 3].Value = regionName;
                                //    eSheet.Cells[rownumber, 6].Value = active;
                                //    eSheet.Cells[rownumber, 11].Value = "countryName not exist in system";
                                //    rownumber++;
                                //}
                                else
                                {
                                    string id      = "";
                                    var    checkID = DC_Location_City.GetDC_Location_Citys("1=1", "").OrderByDescending(m => m.RowID).FirstOrDefault();
                                    if (checkID != null)
                                    {
                                        var nextNo = Int32.Parse(checkID.CityID.Substring(1, checkID.CityID.Length - 1)) + 1;
                                        id = "A" + String.Format("{0:0000}", nextNo);
                                    }
                                    else
                                    {
                                        id = "A0001";
                                    }

                                    write.CityID         = id;
                                    write.CityName       = cityName;
                                    write.Active         = bool.Parse(active);
                                    write.RowCreatedTime = DateTime.Now;
                                    write.RowCreatedUser = currentUser.UserName;
                                    write.RegionID       = id_country;
                                    write.Save();
                                    total++;
                                }
                            }
                            catch (Exception e)
                            {
                                eSheet.Cells[rownumber, 2].Value  = cityName;
                                eSheet.Cells[rownumber, 3].Value  = regionName;
                                eSheet.Cells[rownumber, 5].Value  = active;
                                eSheet.Cells[rownumber, 10].Value = e.Message;
                                rownumber++;
                                continue;
                            }
                        }
                        _excelPkg.Save();

                        return(Json(new { success = true, total = total, totalError = rownumber - 2, link = errorFileLocation }));
                    }
                    else
                    {
                        return(Json(new { success = false, error = "File extension is not valid. *.xlsx please." }));
                    }
                }
                else
                {
                    return(Json(new { success = false, error = "File upload null" }));
                }
            }
            catch (Exception ex)
            {
                return(Json(new { success = false, error = ex.Message }));
            }
        }
示例#10
0
        public FileResult ExportExcel([DataSourceRequest] DataSourceRequest request)
        {
            if (asset.Export)
            {
                var country = DC_Location_City.GetDC_Location_Citys("1=1", "").OrderByDescending(s => s.CityID).ToList();

                //using (ExcelPackage excelPkg = new ExcelPackage())
                FileInfo fileInfo = new FileInfo(Server.MapPath(@"~\ExportExcelFile\DC_Location_City.xlsx"));
                var      excelPkg = new ExcelPackage(fileInfo);

                //data sheet
                ExcelWorksheet dataSheet = excelPkg.Workbook.Worksheets["DC_Location_City"];

                IEnumerable listData = country.ToDataSourceResult(request).Data;

                int rowData = 1;
                foreach (DC_Location_City data in listData)
                {
                    int i = 1;
                    rowData++;
                    dataSheet.Cells[rowData, i++].Value = data.CityID;
                    dataSheet.Cells[rowData, i++].Value = data.CityName;
                    dataSheet.Cells[rowData, i++].Value = (!String.IsNullOrEmpty(data.RegionID) ? data.RegionID : "") + " - " + (!String.IsNullOrEmpty(data.RegionName) ? data.RegionName : "");
                    dataSheet.Cells[rowData, i++].Value = data.CountryName;
                    dataSheet.Cells[rowData, i++].Value = data.AliasName;
                    dataSheet.Cells[rowData, i++].Value = data.Active;
                    dataSheet.Cells[rowData, i++].Value = data.RowCreatedTime.ToString();
                    dataSheet.Cells[rowData, i++].Value = data.RowCreatedUser;
                    if (data.RowLastUpdatedTime.ToString("dd/MM/yyyy") != "01/01/1900")
                    {
                        dataSheet.Cells[rowData, i++].Value = data.RowLastUpdatedTime.ToString();
                    }
                    else
                    {
                        dataSheet.Cells[rowData, i++].Value = "";
                    }
                    dataSheet.Cells[rowData, i++].Value = data.RowLastUpdatedUser;
                }

                //data sheet
                var            alias            = DC_Location_Region.GetDC_Location_Regions("1=1", "CountryID DESC").ToList();
                ExcelWorksheet dataSheetAliasID = excelPkg.Workbook.Worksheets["List"];
                IEnumerable    listDataAliasID  = alias.ToDataSourceResult(request).Data;
                int            rowDataAliasID   = 1;
                foreach (DC_Location_Region data in listDataAliasID)
                {
                    int i = 1;
                    rowDataAliasID++;
                    dataSheetAliasID.Cells[rowDataAliasID, i++].Value = (!String.IsNullOrEmpty(data.RegionID) ? data.RegionID : "") + " - " + (!String.IsNullOrEmpty(data.RegionName) ? data.RegionName : "");
                }

                MemoryStream output = new MemoryStream();
                excelPkg.SaveAs(output);
                string fileName    = "DC_Location_City_" + DateTime.Now.ToString("yyyyMMdd_HHmmss") + ".xlsx";
                string contentType = "application/vnd.openxmlformats-officedocument.spreadsheetml.sheet";

                output.Position = 0;
                return(File(output.ToArray(), contentType, fileName));
            }
            else
            {
                string fileName    = "DC_Location_City_" + DateTime.Now.ToString("yyyyMMdd_HHmmss") + ".xlsx";
                string contentType = "application/vnd.openxmlformats-officedocument.spreadsheetml.sheet";
                return(File("", contentType, fileName));
            }
        }