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