public ActionResult Create(BusinessDirectory Obj_BusinessDirectory, string command, HttpPostedFileBase Businessimage, HttpPostedFileBase BusinessLogo, string Categories) { try { string BusinessLogoName = string.Empty; string BusinessimageName = string.Empty; using (var context = new ChossonKallahAdmin.EF6.ChossonKallah()) { var EmailPara = new SqlParameter("@Email", Obj_BusinessDirectory.Email); var result = context.Database.SqlQuery <BusinessDirectory>("sp_Admin_CheckBusinessDirectoryExists @Email", EmailPara).ToList(); if (result.Count > 0) { Int32?Categoryid = 0; var CategoryidPara = new SqlParameter("@Categoryid", Categoryid); var CategoryResult = context.Database.SqlQuery <Category>("sp_Categories_Id_Name_selectall @Categoryid", CategoryidPara).ToList(); List <SelectListItem> CategoryIdName = new List <SelectListItem>(); for (int i = 0; i < CategoryResult.Count; i++) { SelectListItem obj = new SelectListItem(); obj.Text = Convert.ToString(CategoryResult[i].CategoryName); obj.Value = Convert.ToString(CategoryResult[i].CategoryId); CategoryIdName.Add(obj); } ViewBag.Categories = CategoryIdName; var LocationResult = context.Database.SqlQuery <Location>("sp_Location_Id_Name_selectall").ToList(); List <SelectListItem> LocationIdName = new List <SelectListItem>(); for (int i = 0; i < LocationResult.Count; i++) { SelectListItem obj = new SelectListItem(); obj.Text = Convert.ToString(LocationResult[i].LocationName); obj.Value = Convert.ToString(LocationResult[i].LocationId); LocationIdName.Add(obj); } ViewBag.Locations = LocationIdName; ViewBag.BusinessDirectoryExists = "Email is already exists."; return(View(Obj_BusinessDirectory)); } else { Int32?Categoryid = 0; var CategoryidPara = new SqlParameter("@Categoryid", Categoryid); var CategoryResult = context.Database.SqlQuery <Category>("sp_Categories_Id_Name_selectall @Categoryid", CategoryidPara).ToList(); List <SelectListItem> CategoryIdName = new List <SelectListItem>(); for (int i = 0; i < CategoryResult.Count; i++) { SelectListItem obj = new SelectListItem(); obj.Text = Convert.ToString(CategoryResult[i].CategoryName); obj.Value = Convert.ToString(CategoryResult[i].CategoryId); CategoryIdName.Add(obj); } ViewBag.Categories = CategoryIdName; var LocationResult = context.Database.SqlQuery <Location>("sp_Location_Id_Name_selectall").ToList(); List <SelectListItem> LocationIdName = new List <SelectListItem>(); for (int i = 0; i < LocationResult.Count; i++) { SelectListItem obj = new SelectListItem(); obj.Text = Convert.ToString(LocationResult[i].LocationName); obj.Value = Convert.ToString(LocationResult[i].LocationId); LocationIdName.Add(obj); } ViewBag.Locations = LocationIdName; if (SessionUtilities.SaveImage(Businessimage, "BusinessImage", Obj_BusinessDirectory.BusinessName.Trim())) { BusinessimageName = Path.GetFileName(Businessimage.FileName); Obj_BusinessDirectory.BusinessImage = BusinessimageName; } if (SessionUtilities.SaveImage(BusinessLogo, "Logo", Obj_BusinessDirectory.BusinessName.Trim())) { BusinessLogoName = Path.GetFileName(BusinessLogo.FileName); Obj_BusinessDirectory.BusinessLogo = BusinessLogoName; } Obj_BusinessDirectory.CreatedOn = System.DateTime.Now; Obj_BusinessDirectory.IsDeleted = false; context.BusinessDirectories.Add(Obj_BusinessDirectory); context.SaveChanges(); var BusinessIdPara = new SqlParameter("@businessid", Obj_BusinessDirectory.BusinessID); var CategoriesPara = new SqlParameter("@Categories", Categories); context.Database.ExecuteSqlCommand("sp_BusinessDirectory_Category_insert @Categories,@businessid", CategoriesPara, BusinessIdPara); List <BusinessGallery> lstGallery = new List <BusinessGallery>(); if (!string.IsNullOrEmpty(Convert.ToString(Session["NewListingGallery"]))) { var BusinessGalleryidDeletePara = new SqlParameter("@businessgalleryid", Obj_BusinessDirectory.BusinessID); context.Database.ExecuteSqlCommand("sp_BusinessGallery_delete @businessgalleryid", BusinessGalleryidDeletePara); lstGallery = (List <BusinessGallery>)Session["NewListingGallery"]; } BusinessGallery GalObj = new BusinessGallery(); for (int i = 0; i < lstGallery.Count; i++) { GalObj.BusinessID = Obj_BusinessDirectory.BusinessID; GalObj.IsActive = true; GalObj.Sequence = i + 1; context.BusinessGalleries.Add(GalObj); context.SaveChanges(); } TempData["BusinessSuccess"] = "Record has been added successfully."; return(RedirectToAction("Index")); } } } catch (Exception ex) { return(View(Obj_BusinessDirectory)); } }
public ActionResult UploadImages() { using (var context = new ChossonKallahAdmin.EF6.ChossonKallah()) { try { BusinessDirectory obj_BusinessDirectory = new BusinessDirectory(); Int32? BusinessId = 0; for (int i = 0; i < Request.Form.Count; i++) { if (Request.Form.Keys[i] == "Businessid") { BusinessId = Convert.ToInt32(Request.Form[i]); if (BusinessId == 0) { Session.Remove("NewListingGallery"); List <BusinessGallery> lstGallery = new List <BusinessGallery>(); for (int k = 0; k < Request.Form.Count; k++) { if (Request.Form.Keys[k] != "Businessid" && Request.Form.Keys[k] != "BusinessName") { if (!Directory.Exists(Server.MapPath("~/WebsiteImages/" + "BusinessGallery/" + Convert.ToString(Request.Form["BusinessName"].Trim()) + "/"))) { Directory.CreateDirectory(Server.MapPath("~/WebsiteImages/" + "BusinessGallery/" + Convert.ToString(Request.Form["BusinessName"].Trim()) + "/")); } string actFolder = Server.MapPath("~/WebsiteImages/" + "BusinessGallery/" + Convert.ToString(Request.Form["BusinessName"].Trim()) + "/"); if (Convert.ToString(Request.Form[k]).Contains("WebsiteImages/BusinessGallery")) { } else { byte[] imageBytes = Convert.FromBase64String(Request.Form[k].ToString().Replace("data:image/png;base64,", "").Replace("data:image/jpg;base64,", "").Replace("data:image/jpeg;base64,", "").Replace(" ", "+")); MemoryStream ms = new MemoryStream(imageBytes, 0, imageBytes.Length); ms.Write(imageBytes, 0, imageBytes.Length); System.Drawing.Image image2 = System.Drawing.Image.FromStream(ms, true); image2.Save(actFolder + Request.Form.Keys[k]); } BusinessGallery bgc = new BusinessGallery(); bgc.BusinessID = BusinessId; bgc.ImageName = Request.Form.Keys[k]; bgc.Sequence = i + 1; lstGallery.Add(bgc); } } Session["NewListingGallery"] = lstGallery; return(Json("Success", JsonRequestBehavior.AllowGet)); } var BusinessidPara = new SqlParameter("@Businessid", Request.Form[i]); obj_BusinessDirectory = context.Database.SqlQuery <BusinessDirectory>("sp_BusinessDirectory_select @Businessid", BusinessidPara).FirstOrDefault(); } } var BusinessGalleryidPara = new SqlParameter("@businessgalleryid", BusinessId); var obj_BusinessGallery = context.Database.SqlQuery <BusinessGallery>("sp_BusinessGallery_select @businessgalleryid", BusinessGalleryidPara).ToList(); if (obj_BusinessGallery.Count > 0) { for (int i = 0; i < obj_BusinessGallery.Count; i++) { string ImageName = Convert.ToString(obj_BusinessGallery[i].ImageName); Boolean HaveDelte = true; for (int k = 0; k < Request.Form.Count; k++) { if (ImageName.Trim() == Request.Form.Keys[k].Trim()) { HaveDelte = false; } } if (HaveDelte && System.IO.File.Exists(Server.MapPath("~/WebsiteImages/" + "BusinessGallery/" + obj_BusinessDirectory.BusinessName.Trim() + "/" + ImageName))) { System.IO.File.Delete(Server.MapPath("~/WebsiteImages/" + "BusinessGallery/" + obj_BusinessDirectory.BusinessName.Trim() + "/" + ImageName)); } } var BusinessGalleryidDeletePara = new SqlParameter("@businessgalleryid", BusinessId); context.Database.ExecuteSqlCommand("sp_BusinessGallery_delete @businessgalleryid", BusinessGalleryidDeletePara); } for (int i = 0; i < Request.Form.Count; i++) { if (Request.Form.Keys[i] != "Businessid" && Request.Form.Keys[i] != "BusinessName") { if (!Directory.Exists(Server.MapPath("~/WebsiteImages/" + "BusinessGallery/" + obj_BusinessDirectory.BusinessName.Trim() + "/"))) { Directory.CreateDirectory(Server.MapPath("~/WebsiteImages/" + "BusinessGallery/" + obj_BusinessDirectory.BusinessName.Trim() + "/")); } string actFolder = Server.MapPath("~/WebsiteImages/" + "BusinessGallery/" + obj_BusinessDirectory.BusinessName.Trim() + "/"); if (Convert.ToString(Request.Form[i]).Contains("WebsiteImages/BusinessGallery")) { } else { byte[] imageBytes = Convert.FromBase64String(Request.Form[i].ToString().Replace("data:image/png;base64,", "").Replace("data:image/jpg;base64,", "").Replace("data:image/jpeg;base64,", "").Replace(" ", "+")); MemoryStream ms = new MemoryStream(imageBytes, 0, imageBytes.Length); ms.Write(imageBytes, 0, imageBytes.Length); System.Drawing.Image image2 = System.Drawing.Image.FromStream(ms, true); image2.Save(actFolder + Request.Form.Keys[i]); } BusinessGallery bgc = new BusinessGallery(); bgc.BusinessID = BusinessId; bgc.ImageName = Request.Form.Keys[i]; bgc.Sequence = i + 1; bgc.IsActive = true; context.BusinessGalleries.Add(bgc); context.SaveChanges(); } } return(Json("Success", JsonRequestBehavior.AllowGet)); } catch (Exception ex) { return(Json("Exception: " + ex.Message, JsonRequestBehavior.AllowGet)); } } }