public ActionResult CheckPhoneNoAvailability(string PhoneNum) { try { DataTable dt = new DataTable(); using (var db = new MyAamdhaniEntities()) { using (SqlConnection con = new SqlConnection(db.Database.Connection.ConnectionString)) { using (SqlCommand cmd = new SqlCommand("Sp_CheckAvailability", con)) { SqlDataAdapter adapter = new SqlDataAdapter(cmd); adapter.SelectCommand.CommandType = CommandType.StoredProcedure; adapter.SelectCommand.Parameters.Add(new SqlParameter("@Email", "")); adapter.SelectCommand.Parameters.Add(new SqlParameter("PhoneNumber", PhoneNum)); adapter.Fill(dt); } } } if (dt.Rows.Count > 0) { return(Json(new { success = true })); } else { return(Json(new { success = false })); } } catch (Exception ex) { var error = ex.ToString(); return(Json("Sorry,Please try again.")); } }
// GET: Admin/Categories/Delete/5 public ActionResult DeleteCategory(int CategoryId) { if (Convert.ToString(CategoryId) == null) { return(new HttpStatusCodeResult(HttpStatusCode.BadRequest)); } using (var db = new MyAamdhaniEntities()) { if (CategoryId != 0) { int Response = cem.DeleteCategory(CategoryId); if (Response > 0) { TempData["SuccessMsg"] = true; TempData["Msg"] = "Category Deleted Sucessfully"; return(Json(new { sucess = true, msg = "Category Deleted Successfully" })); } else { TempData["SuccessMsg"] = false; TempData["Msg"] = "Category is in use can't Deleted"; return(Json(new { sucess = false, msg = "Category is in use can't Deleted" })); } } else { TempData["SuccessMsg"] = false; TempData["Msg"] = "Something went Wrong"; return(Json(new { sucess = false, msg = "Something went Wrong" })); } } }
public ActionResult UpdateStatus(int CategoryId, bool status) { try { using (var db = new MyAamdhaniEntities()) { if (CategoryId != 0) { bool response = cem.UpdateStatus(CategoryId, status); if (response) { return(Json(new { success = true, msg = "Category Updated Successfully" })); } else { return(Json(new { success = false, msg = "Something Went Wrong" })); } } else { return(Json(new { success = false, msg = "Something Went Wrong" })); } } } catch (Exception ex) { throw; } }
public ActionResult AddToCart(AddToCartModel model) { var repoHelper = new HelperClasses.RepoHelper(); using (MyAamdhaniEntities context = new MyAamdhaniEntities()) { using (var transaction = context.Database.BeginTransaction()) { try { var ProductDetails = repoHelper.GetProductDetails(null, productUniqueId: model.ProductKey); var cartItem = new CartItem { ProductId = ProductDetails.ProductId, UnitPrice = ProductDetails.PiecePrice, Quantity = model.Quantity, DateAdded = DateTime.Now, DateModified = DateTime.Now, IsActive = true, IsDelete = false, UserId = 1 }; context.CartItems.Add(cartItem); context.SaveChanges(); transaction.Commit(); return(Json( new AlertModal { IsError = false, Message = "Product Added To Cart Successfully.", AlertClass = "success", RedirectUrl = Url.Action(nameof(Index), "Cart") }, JsonRequestBehavior.AllowGet )); } catch (Exception ex) { transaction.Rollback(); return(Json( new AlertModal { IsError = true, Message = ex.Message, AlertClass = "error", RedirectUrl = Url.Action(nameof(Index), "ShowProduct") }, JsonRequestBehavior.AllowGet )); } } } }
public static DbCommand LoadStoredProcedure(this MyAamdhaniEntities dbContext, string StoredProcedure) { try { var cmd = dbContext.Database.Connection.CreateCommand(); cmd.CommandText = StoredProcedure; cmd.CommandTimeout = 0; cmd.CommandType = System.Data.CommandType.StoredProcedure; return(cmd); } catch (Exception ex) { throw ex; } }