public ActionResult Edit(Admin Obj_Admin)
{
try
{
using (var context = new ChossonKallahAdmin.EF6.ChossonKallah())
{
var EmailPara = new SqlParameter("@Email", Obj_Admin.Email);
var AdminIdPara = new SqlParameter("@adminid", Obj_Admin.AdminId);
var result = context.Database.SqlQuery <Admin>("sp_Admin_CheckAdminExistsUpdate @adminid,@Email", AdminIdPara, EmailPara).ToList();
if (result.Count > 0)
{
ViewBag.AdminExists = "Email is already exists.";
return(View(Obj_Admin));
}
else
{
context.Admins.Attach(Obj_Admin);
context.Entry(Obj_Admin).State = System.Data.Entity.EntityState.Modified;
context.SaveChanges();
TempData["AdminSuccess"] = "Record has been update successfully.";
return(RedirectToAction("Index"));
}
}
}
catch (Exception ex)
{
if (!ex.Message.Contains("See 'EntityValidationErrors' property"))
{
ViewBag.AdminExists = ex.Message;
}
return(View(Obj_Admin));
}
}
public ActionResult Create(Category Obj_Categories, string command)
{
try
{
using (var context = new ChossonKallahAdmin.EF6.ChossonKallah())
{
var CategorynamePara = new SqlParameter("@Categoryname", Obj_Categories.CategoryName);
var result = context.Database.SqlQuery <Category>("sp_Category_CheckCategoryExists @Categoryname", CategorynamePara).ToList();
if (result.Count > 0)
{
ViewBag.CategoryExists = "Category name is already exists.";
ViewBag.Categories = SessionUtilities.GetCategories();
return(View(Obj_Categories));
}
else
{
Obj_Categories.CreatedOn = System.DateTime.Now;
Obj_Categories.IsDeleted = false;
context.Categories.Add(Obj_Categories);
context.SaveChanges();
TempData["CategorySuccess"] = "Record has been added successfully.";
return(RedirectToAction("Index"));
}
}
}
catch (Exception ex)
{
if (!ex.Message.Contains("See 'EntityValidationErrors' property"))
{
ViewBag.Categories = ex.Message;
}
return(View(Obj_Categories));
}
}
public ActionResult Delete(Int32?Businessreviewid)
{
try
{
using (var context = new ChossonKallahAdmin.EF6.ChossonKallah())
{
var BusinessreviewidPara = new SqlParameter("@Businessreviewid", Businessreviewid);
BusinessReview obj_BusinessReview = context.Database.SqlQuery <BusinessReview>("sp_BusinessReview_select @Businessreviewid", BusinessreviewidPara).FirstOrDefault();
obj_BusinessReview.IsDeleted = true;
context.Entry(obj_BusinessReview).State = System.Data.Entity.EntityState.Modified;
context.SaveChanges();
TempData["BusinessReviewSuccess"] = "Record has been deleted successfully.";
return(RedirectToAction("Index", new { Businessid = obj_BusinessReview.BusinessID }));
}
}
catch (Exception ex)
{
if (!ex.Message.Contains("See 'EntityValidationErrors' property"))
{
ViewBag.BusinessReviewError = ex.Message;
}
return(View());
}
//using (BusinessReviewCtl db = new BusinessReviewCtl())
//{
// db.delete(Businessreviewid);
// return RedirectToAction("Index");
//}
}
public ActionResult Delete(Int32 AdsBannerId)
{
try
{
using (var context = new ChossonKallahAdmin.EF6.ChossonKallah())
{
var AdsBannerIdPara = new SqlParameter("@adsbannerid", AdsBannerId);
AdsBanner obj_AdsBanner = context.Database.SqlQuery <AdsBanner>("sp_AdsBanner_select @adsbannerid", AdsBannerIdPara).FirstOrDefault();
obj_AdsBanner.IsDeleted = true;
context.Entry(obj_AdsBanner).State = System.Data.Entity.EntityState.Modified;
context.SaveChanges();
var adsbannerSequenceidPara = new SqlParameter("@adsbannerid", obj_AdsBanner.AdsBannerID);
context.Database.ExecuteSqlCommand("sp_AdsBanner_delete @adsbannerid", AdsBannerIdPara);
TempData["AdsBannerSuccess"] = "Record has been deleted successfully.";
return(RedirectToAction("Index"));
}
}
catch (Exception ex)
{
if (!ex.Message.Contains("See 'EntityValidationErrors' property"))
{
TempData["AdsBannerError"] = ex.Message;
}
return(RedirectToAction("Index"));
}
}
public ActionResult Edit(BusinessReview Obj_BusinessReview)
{
try
{
using (var context = new ChossonKallahAdmin.EF6.ChossonKallah())
{
context.BusinessReviews.Attach(Obj_BusinessReview);
context.Entry(Obj_BusinessReview).State = System.Data.Entity.EntityState.Modified;
context.SaveChanges();
TempData["BusinessReviewSuccess"] = "Record has been update successfully.";
return(RedirectToAction("Index", new { Businessid = Obj_BusinessReview.BusinessID }));
}
}
catch (Exception ex)
{
if (!ex.Message.Contains("See 'EntityValidationErrors' property"))
{
ViewBag.BusinessReviewError = ex.Message;
}
return(View(Obj_BusinessReview));
}
//using (BusinessReviewCtl db = new BusinessReviewCtl())
//{
// db.update(Obj_BusinessReview);
// return RedirectToAction("Index", new { Businessid = Obj_BusinessReview.Businessid });
//}
}
public ActionResult Edit(Category Obj_Categories)
{
try
{
using (var context = new ChossonKallahAdmin.EF6.ChossonKallah())
{
var CategoryName = new SqlParameter("@CategoryName", Obj_Categories.CategoryName);
var CategoryId = new SqlParameter("@CategoryId", Obj_Categories.CategoryId);
var result = context.Database.SqlQuery <Category>("sp_Category_CheckCategoryExistsUpdate @CategoryId,@CategoryName", CategoryId, CategoryName).ToList();
if (result.Count > 0)
{
ViewBag.CategoryExists = "Category name is already exists.";
ViewBag.Categories = SessionUtilities.GetCategories();
return(View(Obj_Categories));
}
else
{
context.Categories.Attach(Obj_Categories);
context.Entry(Obj_Categories).State = System.Data.Entity.EntityState.Modified;
context.SaveChanges();
TempData["CategorySuccess"] = "Record has been update successfully.";
return(RedirectToAction("Index"));
}
}
}
catch (Exception ex)
{
if (!ex.Message.Contains("See 'EntityValidationErrors' property"))
{
ViewBag.CategoryExists = ex.Message;
}
return(View(Obj_Categories));
}
}
public ActionResult Edit(Location Obj_Location)
{
try
{
using (var context = new ChossonKallahAdmin.EF6.ChossonKallah())
{
var LocationidPara = new SqlParameter("@Locationid", Obj_Location.LocationId);
var LocationnamePara = new SqlParameter("@Locationname", Obj_Location.LocationName);
var LocationurlPara = new SqlParameter("@Locationurl", Obj_Location.LocationURL);
var result = context.Database.SqlQuery <Location>("sp_Location_CheckLocationExists_Update @Locationid,@Locationname,@Locationurl", LocationidPara, LocationnamePara, LocationurlPara).ToList();
if (result.Count > 0)
{
ViewBag.LocationExists = "Location name is already exists.";
ViewBag.StateData = SessionUtilities.GetState();
return(View(Obj_Location));
}
else
{
context.Locations.Attach(Obj_Location);
context.Entry(Obj_Location).State = System.Data.Entity.EntityState.Modified;
context.SaveChanges();
TempData["LocationSuccess"] = "Record has been update successfully.";
return(RedirectToAction("Index"));
}
}
}
catch (Exception ex)
{
if (!ex.Message.Contains("See 'EntityValidationErrors' property"))
{
ViewBag.LocationExists = ex.Message;
}
return(View(Obj_Location));
}
}
public ActionResult Create(Location Obj_Location, string command)
{
try
{
using (var context = new ChossonKallahAdmin.EF6.ChossonKallah())
{
var LocationnamePara = new SqlParameter("@Locationname", Obj_Location.LocationName);
var LocationurlPara = new SqlParameter("@Locationurl", Obj_Location.LocationURL);
var result = context.Database.SqlQuery <Location>("sp_Location_CheckLocationExists @Locationname,@Locationurl", LocationnamePara, LocationurlPara).ToList();
if (result.Count > 0)
{
ViewBag.LocationExists = "Location name is already exists.";
ViewBag.StateData = SessionUtilities.GetState();
return(View(Obj_Location));
}
else
{
Obj_Location.CreatedOn = System.DateTime.Now;
Obj_Location.IsDeleted = false;
context.Locations.Add(Obj_Location);
context.SaveChanges();
TempData["LocationSuccess"] = "Record has been added successfully.";
return(RedirectToAction("Index"));
}
}
}
catch (Exception ex)
{
if (!ex.Message.Contains("See 'EntityValidationErrors' property"))
{
ViewBag.LocationExists = ex.Message;
}
return(View(Obj_Location));
}
}
public ActionResult Create(Admin Obj_Admin, string command)
{
try
{
using (var context = new ChossonKallahAdmin.EF6.ChossonKallah())
{
var EmailPara = new SqlParameter("@Email", Obj_Admin.Email);
var result = context.Database.SqlQuery <Admin>("sp_Admin_CheckAdminExists @Email", EmailPara).ToList();
if (result.Count > 0)
{
ViewBag.AdminExists = "Email is already exists.";
return(View(Obj_Admin));
}
else
{
Obj_Admin.CreatedOn = System.DateTime.Now;
Obj_Admin.IsDeleted = false;
context.Admins.Add(Obj_Admin);
context.SaveChanges();
TempData["AdminSuccess"] = "Record has been added successfully.";
return(RedirectToAction("Index"));
}
}
}
catch (Exception ex)
{
if (!ex.Message.Contains("See 'EntityValidationErrors' property"))
{
ViewBag.AdminExists = ex.Message;
}
return(View(Obj_Admin));
}
}
public ActionResult Create(BusinessReview Obj_BusinessReview, string command)
{
try
{
using (var context = new ChossonKallahAdmin.EF6.ChossonKallah())
{
Obj_BusinessReview.AddedOn = System.DateTime.Now;
Obj_BusinessReview.IsDeleted = false;
context.BusinessReviews.Add(Obj_BusinessReview);
context.SaveChanges();
TempData["BusinessReviewSuccess"] = "Record has been added successfully.";
return(RedirectToAction("Index", new { Businessid = Obj_BusinessReview.BusinessID }));
}
}
catch (Exception ex)
{
if (!ex.Message.Contains("See 'EntityValidationErrors' property"))
{
ViewBag.BusinessReviewError = ex.Message;
}
return(View(Obj_BusinessReview));
}
//using (BusinessReviewCtl db = new BusinessReviewCtl())
//{
// db.insert(Obj_BusinessReview);
// return RedirectToAction("Index", new { Businessid = Obj_BusinessReview.Businessid });
//}
}
public ActionResult Edit(WebsiteBanner Obj_WebsiteBanner, HttpPostedFileBase BannerImage)
{
try
{
string BannerName = string.Empty;
using (var context = new ChossonKallahAdmin.EF6.ChossonKallah())
{
var WebsitebanneridPara = new SqlParameter("@Websitebannerid", Obj_WebsiteBanner.WebsiteBannerID);
WebsiteBanner obj_WebsiteBannerResult = context.Database.SqlQuery <WebsiteBanner>("sp_WebsiteBanner_select @Websitebannerid", WebsitebanneridPara).FirstOrDefault();
if (SessionUtilities.SaveImage(BannerImage, "Banner"))
{
BannerName = Path.GetFileName(BannerImage.FileName);
Obj_WebsiteBanner.BannerImage = BannerName;
}
else
{
Obj_WebsiteBanner.BannerImage = obj_WebsiteBannerResult.BannerImage;
}
var WebsitebannerSequenceidPara = new SqlParameter("@Websitebannerid", Obj_WebsiteBanner.WebsiteBannerID);
var WebsitebannerSequencePara = new SqlParameter("@Sequence", Obj_WebsiteBanner.Sequence);
context.Database.ExecuteSqlCommand("sp_WebsiteBanner_updateSequenceEdit @Sequence,@Websitebannerid", WebsitebannerSequencePara, WebsitebannerSequenceidPara);
context.WebsiteBanners.Attach(Obj_WebsiteBanner);
context.Entry(Obj_WebsiteBanner).State = System.Data.Entity.EntityState.Modified;
context.SaveChanges();
TempData["WebsiteBannerSuccess"] = "Record has been update successfully.";
return(RedirectToAction("Index"));
}
}
catch (Exception ex)
{
if (!ex.Message.Contains("See 'EntityValidationErrors' property"))
{
ViewBag.WebsiteBannerError = ex.Message;
}
return(View(Obj_WebsiteBanner));
}
//try
//{
// string BannerName = string.Empty;
// using (WebsiteBannerCtl db = new WebsiteBannerCtl())
// {
// if (SessionUtilities.SaveImage(BannerImage, "Banner"))
// {
// BannerName = Path.GetFileName(BannerImage.FileName);
// Obj_WebsiteBanner.BannerImage = BannerName;
// }
// db.update(Obj_WebsiteBanner);
// TempData["WebsiteBannerSuccess"] = "Record has been updated successfully.";
// }
// return RedirectToAction("Index");
//}
//catch (Exception ex)
//{
// return View(Obj_WebsiteBanner);
//}
}
public ActionResult Edit(AdsBanner Obj_AdsBanner, HttpPostedFileBase AdsBannerImage)
{
try
{
string AdsBannerName = string.Empty;
using (var context = new ChossonKallahAdmin.EF6.ChossonKallah())
{
var AdsBannerNamePara = new SqlParameter("@adsbannername", Obj_AdsBanner.AdsBannerName);
var AdsBannerVendorIdPara = new SqlParameter("@vendorid", Obj_AdsBanner.VendorID);
var AdsBannerIdPara = new SqlParameter("@adsbannerid", Obj_AdsBanner.AdsBannerID);
var result = context.Database.SqlQuery <AdsBanner>("sp_AdsBanner_CheckVendorExistsUpdate @adsbannername,@vendorid,@adsbannerid", AdsBannerNamePara, AdsBannerVendorIdPara, AdsBannerIdPara).ToList();
if (result.Count > 0)
{
ViewBag.AdsBannerExists = "Banner name is already exists.";
GetCateory();
GetVendor();
GetPosition();
return(View(Obj_AdsBanner));
}
else
{
var AdsGetBannerIdPara = new SqlParameter("@adsbannerid", Obj_AdsBanner.AdsBannerID);
AdsBanner obj_AdsBanners = context.Database.SqlQuery <AdsBanner>("sp_AdsBanner_select @adsbannerid", AdsGetBannerIdPara).FirstOrDefault();
if (SessionUtilities.SaveImage(AdsBannerImage, "AdsBanner", Obj_AdsBanner.AdsBannerName.Trim()))
{
AdsBannerName = Path.GetFileName(AdsBannerImage.FileName);
Obj_AdsBanner.AdsBannerImage = AdsBannerName;
}
else
{
Obj_AdsBanner.AdsBannerImage = obj_AdsBanners.AdsBannerImage;
}
var adsbannerSequenceidPara = new SqlParameter("@adsbannerid", Obj_AdsBanner.AdsBannerID);
var adsbannerSequencePara = new SqlParameter("@priority", Obj_AdsBanner.Priority);
context.Database.ExecuteSqlCommand("sp_AdsBanner_updateSequenceEdit @priority,@adsbannerid", adsbannerSequencePara, adsbannerSequenceidPara);
context.AdsBanners.Attach(Obj_AdsBanner);
context.Entry(Obj_AdsBanner).State = System.Data.Entity.EntityState.Modified;
context.SaveChanges();
TempData["AdsBannerSuccess"] = "Record has been update successfully.";
return(RedirectToAction("Index"));
}
}
}
catch (Exception ex)
{
if (!ex.Message.Contains("See 'EntityValidationErrors' property"))
{
ViewBag.AdsBannerExists = ex.Message;
}
return(View(Obj_AdsBanner));
}
}
public ActionResult Create(Location Obj_Location, string command)
{
try
{
using (var context = new ChossonKallahAdmin.EF6.ChossonKallah())
{
var LocationnamePara = new SqlParameter("@Locationname", Obj_Location.LocationName);
var result = context.Database.SqlQuery <Location>("sp_Location_CheckLocationExists @Locationname", LocationnamePara).ToList();
if (result.Count > 0)
{
ViewBag.LocationExists = "Location name is already exists.";
DataTable dt = new DataTable();
var Result = context.Database.SqlQuery <StateData>("sp_StateData_SelectAllForSelectInAddEditLocation").ToList();
dt = SessionUtilities.LINQResultToDataTable(Result);
List <SelectListItem> lstObj = new List <SelectListItem>();
SelectListItem sl = new SelectListItem();
sl.Text = "--Please Select--";
sl.Value = "0";
sl.Selected = true;
lstObj.Add(sl);
foreach (DataRow dr in dt.Rows)
{
sl = new SelectListItem();
sl.Text = Convert.ToString(dr["FullName"]);
sl.Value = Convert.ToString(dr["FullName"]);
sl.Selected = false;
lstObj.Add(sl);
}
ViewBag.StateData = lstObj;
return(View(Obj_Location));
}
else
{
Obj_Location.CreatedOn = System.DateTime.Now;
Obj_Location.IsDeleted = false;
context.Locations.Add(Obj_Location);
context.SaveChanges();
TempData["LocationSuccess"] = "Record has been added successfully.";
return(RedirectToAction("Index"));
}
}
}
catch (Exception ex)
{
if (!ex.Message.Contains("See 'EntityValidationErrors' property"))
{
ViewBag.LocationExists = ex.Message;
}
return(View(Obj_Location));
}
}
public ActionResult Create(WebsiteBanner Obj_WebsiteBanner, string command, HttpPostedFileBase BannerImage)
{
try
{
string BannerName = string.Empty;
using (var context = new ChossonKallahAdmin.EF6.ChossonKallah())
{
if (SessionUtilities.SaveImage(BannerImage, "Banner"))
{
BannerName = Path.GetFileName(BannerImage.FileName);
Obj_WebsiteBanner.BannerImage = BannerName;
}
Obj_WebsiteBanner.CreatedOn = System.DateTime.Now;
Obj_WebsiteBanner.IsDeleted = false;
context.WebsiteBanners.Add(Obj_WebsiteBanner);
context.SaveChanges();
var WebsitebannerSequenceidPara = new SqlParameter("@websitebannerid", Obj_WebsiteBanner.WebsiteBannerID);
context.Database.ExecuteSqlCommand("sp_WebsiteBanner_UpdateSequence @websitebannerid", WebsitebannerSequenceidPara);
TempData["WebsiteBannerSuccess"] = "Record has been added successfully.";
return(RedirectToAction("Index"));
}
}
catch (Exception ex)
{
if (!ex.Message.Contains("See 'EntityValidationErrors' property"))
{
ViewBag.WebsiteBannerError = ex.Message;
}
return(View(Obj_WebsiteBanner));
}
//try
//{
// string BannerName = string.Empty;
// using (WebsiteBannerCtl db = new WebsiteBannerCtl())
// {
// if (SessionUtilities.SaveImage(BannerImage, "Banner"))
// {
// BannerName = Path.GetFileName(BannerImage.FileName);
// Obj_WebsiteBanner.BannerImage = BannerName;
// }
// db.insert(Obj_WebsiteBanner);
// TempData["WebsiteBannerSuccess"] = "Record has been added successfully.";
// }
// return RedirectToAction("Index");
//}
//catch (Exception ex)
//{
// return View(Obj_WebsiteBanner);
//}
}
public ActionResult Create(AdsBanner Obj_AdsBanner, string command, HttpPostedFileBase AdsBannerImage)
{
try
{
string AdsBannerName = string.Empty;
using (var context = new ChossonKallahAdmin.EF6.ChossonKallah())
{
var AdsBannerNamePara = new SqlParameter("@adsbannername", Obj_AdsBanner.AdsBannerName);
var AdsBannerVendorIdPara = new SqlParameter("@vendorid", Obj_AdsBanner.VendorID);
var result = context.Database.SqlQuery <AdsBanner>("sp_AdsBanner_CheckAdminExists @adsbannername,@vendorid", AdsBannerNamePara, AdsBannerVendorIdPara).ToList();
if (result.Count > 0)
{
ViewBag.AdsBannerExists = "Banner name is already exists.";
GetCateory();
GetVendor();
GetPosition();
return(View(Obj_AdsBanner));
}
else
{
GetCateory();
GetVendor();
GetPosition();
if (SessionUtilities.SaveImage(AdsBannerImage, "AdsBanner", Obj_AdsBanner.AdsBannerName.Trim()))
{
AdsBannerName = Path.GetFileName(AdsBannerImage.FileName);
Obj_AdsBanner.AdsBannerImage = AdsBannerName;
}
Obj_AdsBanner.CreateAt = System.DateTime.Now;
Obj_AdsBanner.IsDeleted = false;
context.AdsBanners.Add(Obj_AdsBanner);
context.SaveChanges();
var adsBannersequenceIdpara = new SqlParameter("@adsbannerid", Obj_AdsBanner.AdsBannerID);
context.Database.ExecuteSqlCommand("sp_AdsBanner_UpdateSequence @adsbannerid", adsBannersequenceIdpara);
TempData["AdsBannerSuccess"] = "Record has been added successfully.";
return(RedirectToAction("Index"));
}
}
}
catch (Exception ex)
{
if (!ex.Message.Contains("See 'EntityValidationErrors' property"))
{
ViewBag.AdsBannerExists = ex.Message;
}
return(View(Obj_AdsBanner));
}
}
public ActionResult Create(Category Obj_Categories, string command)
{
try
{
using (var context = new ChossonKallahAdmin.EF6.ChossonKallah())
{
var CategorynamePara = new SqlParameter("@Categoryname", Obj_Categories.CategoryName);
var result = context.Database.SqlQuery <Category>("sp_Category_CheckCategoryExists @Categoryname", CategorynamePara).ToList();
if (result.Count > 0)
{
ViewBag.CategoryExists = "Category name is already exists.";
Int32?Categoryid = 0;
var CategoryidPara = new SqlParameter("@Categoryid", Categoryid);
var Result = context.Database.SqlQuery <Category>("sp_Categories_Id_Name_selectall @Categoryid", CategoryidPara).ToList();
List <SelectListItem> IdName = new List <SelectListItem>();
for (int i = 0; i < Result.Count; i++)
{
SelectListItem obj = new SelectListItem();
obj.Text = Convert.ToString(Result[i].CategoryName);
obj.Value = Convert.ToString(Result[i].CategoryId);
IdName.Add(obj);
}
ViewBag.Categories = IdName;
return(View(Obj_Categories));
}
else
{
Obj_Categories.CreatedOn = System.DateTime.Now;
Obj_Categories.IsDeleted = false;
context.Categories.Add(Obj_Categories);
context.SaveChanges();
TempData["AdminSuccess"] = "Record has been added successfully.";
return(RedirectToAction("Index"));
}
}
}
catch (Exception ex)
{
if (!ex.Message.Contains("See 'EntityValidationErrors' property"))
{
ViewBag.Categories = ex.Message;
}
return(View(Obj_Categories));
}
}
public ActionResult Edit(Category Obj_Categories)
{
try
{
using (var context = new ChossonKallahAdmin.EF6.ChossonKallah())
{
var CategoryName = new SqlParameter("@CategoryName", Obj_Categories.CategoryName);
var CategoryId = new SqlParameter("@CategoryId", Obj_Categories.CategoryId);
var result = context.Database.SqlQuery <Category>("sp_Category_CheckCategoryExistsUpdate @CategoryId,@CategoryName", CategoryId, CategoryName).ToList();
if (result.Count > 0)
{
ViewBag.CategoryExists = "Category name is already exists.";
var CategoryidPara = new SqlParameter("@Categoryid", Obj_Categories.CategoryId);
var Result = context.Database.SqlQuery <Category>("sp_Categories_Id_Name_selectall @Categoryid", CategoryidPara).ToList();
List <SelectListItem> IdName = new List <SelectListItem>();
for (int i = 0; i < Result.Count; i++)
{
SelectListItem obj = new SelectListItem();
obj.Text = Convert.ToString(Result[i].CategoryName);
obj.Value = Convert.ToString(Result[i].CategoryId);
IdName.Add(obj);
}
ViewBag.Categories = IdName;
return(View(Obj_Categories));
}
else
{
context.Categories.Attach(Obj_Categories);
context.Entry(Obj_Categories).State = System.Data.Entity.EntityState.Modified;
context.SaveChanges();
TempData["CategorySuccess"] = "Record has been update successfully.";
return(RedirectToAction("Index"));
}
}
}
catch (Exception ex)
{
if (!ex.Message.Contains("See 'EntityValidationErrors' property"))
{
ViewBag.CategoryExists = ex.Message;
}
return(View(Obj_Categories));
}
}
public ActionResult Delete(Int32 VendorId)
{
try
{
using (var context = new ChossonKallahAdmin.EF6.ChossonKallah())
{
var VendorIdPara = new SqlParameter("@vendorid", VendorId);
Vendor obj_Vendor = context.Database.SqlQuery <Vendor>("sp_Vendor_select @vendorid", VendorIdPara).FirstOrDefault();
obj_Vendor.IsDeleted = true;
context.Entry(obj_Vendor).State = System.Data.Entity.EntityState.Modified;
context.SaveChanges();
TempData["VendorSuccess"] = "Record has been deleted successfully.";
return(RedirectToAction("Index"));
}
}
catch (Exception ex)
{
if (!ex.Message.Contains("See 'EntityValidationErrors' property"))
{
TempData["VendorError"] = ex.Message;
}
return(RedirectToAction("Index"));
}
}
public ActionResult Edit(BusinessDirectory Obj_BusinessDirectory, 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 BusinessIdPara = new SqlParameter("@businessdirectoryid", Obj_BusinessDirectory.BusinessID);
var result = context.Database.SqlQuery <BusinessDirectory>("sp_Admin_CheckBusinessdirectoryExistsUpdate @businessdirectoryid,@Email", BusinessIdPara, 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))
{
BusinessimageName = Path.GetFileName(Businessimage.FileName);
Obj_BusinessDirectory.BusinessImage = BusinessimageName;
}
if (SessionUtilities.SaveImage(BusinessLogo, "Logo", Obj_BusinessDirectory.BusinessName))
{
BusinessLogoName = Path.GetFileName(BusinessLogo.FileName);
Obj_BusinessDirectory.BusinessLogo = BusinessLogoName;
}
context.BusinessDirectories.Attach(Obj_BusinessDirectory);
context.Entry(Obj_BusinessDirectory).State = System.Data.Entity.EntityState.Modified;
context.SaveChanges();
var BusinessCategoryIdPara = new SqlParameter("@businessid", Obj_BusinessDirectory.BusinessID);
var CategoriesPara = new SqlParameter("@Categories", Categories);
context.Database.ExecuteSqlCommand("sp_BusinessDirectory_Category_insert @Categories,@businessid", CategoriesPara, BusinessCategoryIdPara);
TempData["BusinessSuccess"] = "Record has been updated successfully.";
return(RedirectToAction("Index"));
}
}
}
catch (Exception ex)
{
return(View(Obj_BusinessDirectory));
}
}
public ActionResult Edit(BusinessDirectory Obj_BusinessDirectory, 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 BusinessIdPara = new SqlParameter("@businessdirectoryid", Obj_BusinessDirectory.BusinessID);
var result = context.Database.SqlQuery <BusinessDirectory>("sp_Admin_CheckBusinessdirectoryExistsUpdate @businessdirectoryid,@Email", BusinessIdPara, 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))
{
BusinessimageName = Path.GetFileName(Businessimage.FileName);
Obj_BusinessDirectory.BusinessImage = BusinessimageName;
}
if (SessionUtilities.SaveImage(BusinessLogo, "Logo", Obj_BusinessDirectory.BusinessName))
{
BusinessLogoName = Path.GetFileName(BusinessLogo.FileName);
Obj_BusinessDirectory.BusinessLogo = BusinessLogoName;
}
context.BusinessDirectories.Attach(Obj_BusinessDirectory);
context.Entry(Obj_BusinessDirectory).State = System.Data.Entity.EntityState.Modified;
context.SaveChanges();
var BusinessCategoryIdPara = new SqlParameter("@businessid", Obj_BusinessDirectory.BusinessID);
var CategoriesPara = new SqlParameter("@Categories", Categories);
context.Database.ExecuteSqlCommand("sp_BusinessDirectory_Category_insert @Categories,@businessid", CategoriesPara, BusinessCategoryIdPara);
List <BusinessGallery> lstGallery = new List <BusinessGallery>();
if (!string.IsNullOrEmpty(Convert.ToString(Session["NewListingGallery"])))
{
lstGallery = (List <BusinessGallery>)Session["NewListingGallery"];
}
foreach (BusinessGallery GalObj in lstGallery)
{
GalObj.BusinessID = Obj_BusinessDirectory.BusinessID;
GalObj.IsActive = true;
context.BusinessGalleries.Add(GalObj);
context.SaveChanges();
}
TempData["BusinessSuccess"] = "Record has been updated successfully.";
return(RedirectToAction("Index"));
}
}
}
catch (Exception ex)
{
return(View(Obj_BusinessDirectory));
}
//try
//{
// string BusinessLogoName = string.Empty;
// string BusinessimageName = string.Empty;
// using (BusinessDirectoryCtl db = new BusinessDirectoryCtl())
// {
// dt = db.CheckAdminExistsUpdate(Obj_BusinessDirectory.Email, Obj_BusinessDirectory.BusinessID);
// if (dt.Rows.Count > 0)
// {
// Obj_BusinessDirectory = db.selectById(Obj_BusinessDirectory.BusinessID);
// ViewBag.Locations = db.LocationDropdown();
// ViewBag.Categories = db.CategoryDropdown();
// ViewBag.BusinessDirectoryExists = "Email is already exists.";
// return View(Obj_BusinessDirectory);
// }
// else
// {
// if (SessionUtilities.SaveImage(Businessimage, "BusinessImage", Obj_BusinessDirectory.BusinessName))
// {
// BusinessimageName = Path.GetFileName(Businessimage.FileName);
// Obj_BusinessDirectory.BusinessImage = BusinessimageName;
// }
// if (SessionUtilities.SaveImage(BusinessLogo, "Logo", Obj_BusinessDirectory.BusinessName))
// {
// BusinessLogoName = Path.GetFileName(BusinessLogo.FileName);
// Obj_BusinessDirectory.BusinessLogo = BusinessLogoName;
// }
// db.update(Obj_BusinessDirectory);
// TempData["BusinessSuccess"] = "Record has been updated 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));
}
}
}
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));
}
}
