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));
}
}
}
