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