public int DeleteCategory(int Category_ID)
{
Ent_Category ent = new Ent_Category();
ent.Category_ID = Category_ID;
HttpCookie UserID = Request.Cookies["User_ID"];
var UserId = UserID != null?UserID.Value.Split('=')[1] : "";
ent.Modified_By = Convert.ToInt32(UserId);
DateTime indianTime = TimeZoneInfo.ConvertTimeFromUtc(DateTime.UtcNow, INDIAN_ZONE);
DateTime indiTime = Convert.ToDateTime(indianTime.ToString("yyyy-MM-dd h:m:s"));
ent.Modified_Date = indiTime;
SafeTransaction trans = new SafeTransaction();
int i = balCategory.DeleteCategory(ent, trans);
if (i > 0)
{
trans.Commit();
}
else
{
trans.Rollback();
}
return(i);
}
public int RegisterGuest(Ent_Guest model)
{
int result = 0;
SafeTransaction trans = new SafeTransaction();
DateTime indianTime = TimeZoneInfo.ConvertTimeFromUtc(DateTime.UtcNow, INDIAN_ZONE);
DateTime indiTime = Convert.ToDateTime(indianTime.ToString("yyyy-MM-dd h:m:s"));
model.Created_Date = indiTime;
string uniqueId = Guid.NewGuid().ToString();
model.Unique_ID = uniqueId;
result = balGuest.SaveGuest(model, trans);
if (result > 0)
{
trans.Commit();
var lnkHref = "<a href='https://acsadmin.atintellilabs.live/" + @Url.Action("ActivateAccount", "Login", new { id = uniqueId }) + "' target='_blank' style='display: inline-block; padding: 16px 36px; font-family: 'Source Sans Pro', Helvetica, Arial, sans-serif; font-size: 16px; color: #ffffff; text-decoration: none; border-radius: 6px;'>Confirm Your Mail</a>";
string body = string.Empty;
using (StreamReader reader = new StreamReader(Server.MapPath("~/confirm.html")))
{
body = reader.ReadToEnd();
}
body = body.Replace("{Url}", lnkHref);
Email email = new Email();
email.SendMail(body, model.Guest_Username, "Account Activation");
}
else
{
trans.Rollback();
}
return(result);
}
public int UpdateOrderStatus(Ent_Order ent)
{
int result = 0;
SafeTransaction trans = new SafeTransaction();
DateTime indianTime = TimeZoneInfo.ConvertTimeFromUtc(DateTime.UtcNow, INDIAN_ZONE);
DateTime indiTime = Convert.ToDateTime(indianTime.ToString("yyyy-MM-dd h:m:s"));
ent.Created_Date = indiTime;
result = balOrder.UpdateOrderStatus(ent, trans);
if (result > 0)
{
trans.Commit();
string body = string.Empty; var lnkHref = "";
if (ent.Is_Active == 2)
{
if (ent.Guest_ID == 0)
{
lnkHref = "<a href='https://acsadmin.atintellilabs.live/" + @Url.Action("TrackOrder", "Order", new { Order_ID = ent.Order_ID }) + "' target = '_blank' style = 'color: #fc7ca0;' > here </a>";
}
else
{
lnkHref = "<a href='https://acsadmin.atintellilabs.live/" + @Url.Action("Register", "Login") + "' target = '_blank' style = 'color: #fc7ca0;' > here </a>";
}
using (StreamReader reader = new StreamReader(Server.MapPath("~/Shipping.html")))
{
body = reader.ReadToEnd();
}
body = body.Replace("{Url}", lnkHref);
Email em = new Email();
em.SendConfirmationMail(ent.Order_ID, body, "Order Shipped");
}
else if (ent.Is_Active == 3)
{
if (ent.Guest_ID == 0)
{
lnkHref = "<a href='https://acsadmin.atintellilabs.live/" + @Url.Action("TrackOrder", "Order", new { Order_ID = ent.Order_ID }) + "' target = '_blank' style = 'color: #fc7ca0;' > here </a>";
}
else
{
lnkHref = "<a href='https://acsadmin.atintellilabs.live/" + @Url.Action("Register", "Login") + "' target = '_blank' style = 'color: #fc7ca0;' > here </a>";
}
using (StreamReader reader = new StreamReader(Server.MapPath("~/Delivered.html")))
{
body = reader.ReadToEnd();
}
body = body.Replace("{Url}", lnkHref);
Email eml = new Email();
eml.SendConfirmationMail(ent.Order_ID, body, "Order Delivered");
}
}
else
{
trans.Rollback();
}
return(result);
}
// GET: Category
public int SaveCategory(Ent_Category model)
{
SafeTransaction trans = new SafeTransaction();
DateTime indianTime = TimeZoneInfo.ConvertTimeFromUtc(DateTime.UtcNow, INDIAN_ZONE);
DateTime indiTime = Convert.ToDateTime(indianTime.ToString("yyyy-MM-dd h:m:s"));
model.Created_Date = indiTime;
HttpCookie C_UserID = Request.Cookies["User_ID"];
string User_ID = C_UserID != null?C_UserID.Value.Split('=')[1] : "";
model.Created_By = Convert.ToInt32(User_ID);
int i = balCategory.SaveCategory(model, trans);
if (i > 0)
{
trans.Commit();
}
else
{
trans.Rollback();
}
return(i);
}
public int UpdatePayment(Ent_Order entOrder)
{
SafeTransaction trans = new SafeTransaction();
HttpCookie Guest_ID = Request.Cookies["Guest_ID"];
int ID = Guest_ID != null?Convert.ToInt32(Guest_ID.Value.Split('=')[1]) : 0;
entOrder.Guest_ID = ID;
int i = balOrder.UpdatePayment(entOrder, trans);
if (i > 0)
{
trans.Commit();
if (entOrder.Payment_Status == "CAPTURED")
{
string body = string.Empty; var lnkHref = "";
if (ID == 0)
{
lnkHref = "<a href='https://acsadmin.atintellilabs.live/" + @Url.Action("TrackOrder", "Order", new { Order_ID = entOrder.Order_ID }) + "' target = '_blank' style = 'color: #fc7ca0;' > here </ a >";
}
else
{
lnkHref = "<a href='https://acsadmin.atintellilabs.live/" + @Url.Action("Register", "Login") + "' target = '_blank' style = 'color: #fc7ca0;' > here </ a >";
}
using (StreamReader reader = new StreamReader(Server.MapPath("~/OrderConfirmation.html")))
{
body = reader.ReadToEnd();
}
body = body.Replace("{Url}", lnkHref);
Email em = new Email();
em.SendConfirmationMail(entOrder.Order_ID, body, "Order Confirmation");
if (ID != 0)
{
SafeTransaction transac = new SafeTransaction();
int result = balOrder.DeleteCart(0, ID, transac);
if (result > 0)
{
transac.Commit();
}
else
{
transac.Rollback();
}
}
Session["Cart"] = null;
Session["Total"] = null;
Session["SubTotal"] = null;
Session["Shipping"] = null;
}
}
else
{
trans.Rollback();
}
return(i);
}
public int SaveCategory(Ent_Category entGuest, SafeTransaction trans)
{
int dataResult = 0;
try
{
Dal_Category dal = new Dal_Category();
dataResult = dal.SaveCategory(entGuest, trans);
return(dataResult);
}
catch
{
return(0);
}
}
public int ActivateGuest(Ent_Guest entGuest, string token, SafeTransaction trans)
{
int dataResult = 0;
try
{
Dal_Guest dal = new Dal_Guest();
dataResult = dal.ActivateGuest(entGuest, token, trans);
return(dataResult);
}
catch
{
return(0);
}
}
public int SaveGuest(Ent_Guest entGuest, SafeTransaction trans)
{
int dataResult = 0;
try
{
Dal_Guest dal = new Dal_Guest();
dataResult = dal.SaveGuest(entGuest, trans);
return(dataResult);
}
catch
{
return(0);
}
}
public int UpdateAddress(Ent_GuestAddress entGuest, SafeTransaction trans)
{
int dataResult = 0;
try
{
Dal_Guest dal = new Dal_Guest();
dataResult = dal.UpdateAddress(entGuest, trans);
return(dataResult);
}
catch
{
return(0);
}
}
public int DeleteProduct(Ent_Product ent, SafeTransaction trans)
{
int dataResult;
try
{
Dal_Product dal = new Dal_Product();
dataResult = dal.DeleteProduct(ent, trans);
return(dataResult);
}
catch
{
return(-1);
}
}
public int SaveOrder(Ent_Order ent, SafeTransaction trans)
{
int dataResult = 0;
try
{
Dal_Order dal = new Dal_Order();
dataResult = dal.SaveOrder(ent, trans);
return(dataResult);
}
catch
{
return(0);
}
}
public int DeleteBrand(Ent_Brand ent, SafeTransaction trans)
{
int dataResult;
try
{
Dal_Master dal = new Dal_Master();
dataResult = dal.DeleteBrand(ent, trans);
return(dataResult);
}
catch
{
return(-1);
}
}
public int UpdatePayment(Ent_Order entOrder, SafeTransaction trans)
{
int dataResult = 0;
try
{
Dal_Order dal = new Dal_Order();
dataResult = dal.UpdatePayment(entOrder, trans);
return(dataResult);
}
catch
{
return(0);
}
}
public int DeleteCategory(Ent_Category ent, SafeTransaction trans)
{
int dataResult;
try
{
Dal_Category dal = new Dal_Category();
dataResult = dal.DeleteCategory(ent, trans);
return(dataResult);
}
catch
{
return(-1);
}
}
public int SaveBrand(Ent_Brand entGuest, SafeTransaction trans)
{
int dataResult = 0;
try
{
Dal_Master dal = new Dal_Master();
dataResult = dal.SaveBrand(entGuest, trans);
return(dataResult);
}
catch
{
return(0);
}
}
public int InsertCart(Ent_OrderDetail entGuest, SafeTransaction trans)
{
int dataResult = 0;
try
{
Dal_Order dal = new Dal_Order();
dataResult = dal.InsertCart(entGuest, trans);
return(dataResult);
}
catch
{
return(0);
}
}
public int DeleteCart(int productId, int GuestID, SafeTransaction trans)
{
int dataResult = 0;
try
{
Dal_Order dal = new Dal_Order();
dataResult = dal.DeleteCart(productId, GuestID, trans);
return(dataResult);
}
catch
{
return(0);
}
}
public int InsertCartList(List <Ent_OrderDetail> entGuest, int guestID, SafeTransaction trans)
{
int dataResult = 0;
try
{
Dal_Order dal = new Dal_Order();
dataResult = dal.InsertCartList(entGuest, guestID, trans);
return(dataResult);
}
catch
{
return(0);
}
}
public int UpdateCart(List <Ent_Product> CartList)
{
float total = 0;
List <Ent_OrderDetail> item = new List <Ent_OrderDetail>();
for (int i = 0; i < CartList.Count; i++)
{
item.Add(new Ent_OrderDetail()
{
Product_ID = CartList[i].Product_ID,
Product_Name = CartList[i].Product_Name,
Quantity = CartList[i].Quantity,
Product_Price = CartList[i].Product_Price,
Product_Image = CartList[i].Product_Image,
Product_Total = CartList[i].Quantity * CartList[i].Product_Price,
});
HttpCookie Guest_ID = Request.Cookies["Guest_ID"];
string GuestID = Guest_ID != null?Guest_ID.Value.Split('=')[1] : "";
if (!string.IsNullOrEmpty(GuestID))
{
Ent_OrderDetail entP = new Ent_OrderDetail();
entP.Cart_ID = 1;
entP.Product_ID = CartList[i].Product_ID;
entP.Quantity = CartList[i].Quantity;
entP.Guest_ID = Convert.ToInt32(GuestID);
SafeTransaction trans = new SafeTransaction();
int result = balOrder.InsertCart(entP, trans);
if (result > 0)
{
trans.Commit();
}
else
{
trans.Rollback();
}
}
total = total + (CartList[i].Quantity * CartList[i].Product_Price);
Session["Cart"] = item;
item = (List <Ent_OrderDetail>)Session["Cart"];
}
Session["SubTotal"] = Session["Total"] = total;
return(1);
}
public int UpdateAddress(Ent_GuestAddress ent, SafeTransaction trans)
{
int dataresult = 0;
try
{
if (con.State == ConnectionState.Closed)
{
con.Open();
}
using (SqlCommand cmd = new SqlCommand("EC_UpdateAddress", trans.DatabaseConnection, trans.Transaction))
{
cmd.CommandType = CommandType.StoredProcedure;
cmd.Parameters.Add(new SqlParameter("@Address_ID", ent.Address_ID));
cmd.Parameters.Add(new SqlParameter("@Guest_ID", ent.Guest_ID));
cmd.Parameters.Add(new SqlParameter("@First_Name", ent.First_Name));
cmd.Parameters.Add(new SqlParameter("@Last_Name", ent.Last_Name));
cmd.Parameters.Add(new SqlParameter("@Guest_Address1", ent.Guest_Address1));
cmd.Parameters.Add(new SqlParameter("@Guest_Address2", ent.Guest_Address2));
cmd.Parameters.Add(new SqlParameter("@Guest_Town", ent.Guest_Town));
cmd.Parameters.Add(new SqlParameter("@Guest_State", ent.Guest_State));
cmd.Parameters.Add(new SqlParameter("@Guest_Country", ent.Guest_Country));
cmd.Parameters.Add(new SqlParameter("@Address_Type", ent.Address_Type));
cmd.Parameters.Add(new SqlParameter("@Address_Default", ent.Address_Default));
try
{
dataresult = Convert.ToInt32(cmd.ExecuteScalar());
if (dataresult > 0)
{
cmd.Dispose();
}
}
catch (Exception ex)
{
dataresult = -2;
InsertException(ex.Message, "UpdateAddress", ent.Guest_ID);
}
}
}
catch (Exception e)
{
dataresult = -2;
}
finally { con.Close(); }
return(dataresult);
}
public ActionResult DeleteCart(int CartID)
{
List <Ent_OrderDetail> list = (List <Ent_OrderDetail>)Session["Cart"];
Ent_Product ent = new Ent_Product();
ent = balProduct.SelectProduct(CartID);
var qty = list.Where(l => l.Product_ID == CartID).FirstOrDefault().Quantity;
Session["Cart"] = list.Where(l => l.Product_ID != CartID).ToList <Ent_OrderDetail>();
int count = list.Count - 1;
Session["SubTotal"] = Convert.ToInt32(Session["SubTotal"]) - ((ent.Product_Price - ent.Product_Discount) * qty);
Session["Total"] = Convert.ToInt32(Session["Total"]) - ((ent.Product_Price - ent.Product_Discount) * qty);
if (list.Count == 1)
{
Session["Cart"] = null;
Session["Total"] = "0.00";
Session["SubTotal"] = "0.00";
Session["Shipping"] = "0.00";
}
HttpCookie Guest_ID = Request.Cookies["Guest_ID"];
string GuestID = Guest_ID != null?Guest_ID.Value.Split('=')[1] : "";
if (!string.IsNullOrEmpty(GuestID))
{
SafeTransaction trans = new SafeTransaction();
int result = balOrder.DeleteCart(CartID, Convert.ToInt32(GuestID), trans);
if (result > 0)
{
trans.Commit();
}
else
{
trans.Rollback();
}
}
string[] Result = { count.ToString(), Session["Total"].ToString(), Session["SubTotal"].ToString() };
return(Json(Result, JsonRequestBehavior.AllowGet));
}
public int UpdateAddress(Ent_GuestAddress model)
{
int result = 0;
HttpCookie Guest_ID = Request.Cookies["Guest_ID"];
int GuestID = Guest_ID != null?Convert.ToInt32(Guest_ID.Value.Split('=')[1]) : 0;
model.Guest_ID = GuestID;
SafeTransaction trans = new SafeTransaction();
result = balGuest.UpdateAddress(model, trans);
if (result > 0)
{
trans.Commit();
}
else
{
trans.Rollback();
}
return(result);
}
public int InsertCartList(List <Ent_OrderDetail> ent, int guestID, SafeTransaction trans)
{
int dataresult = 0;
try
{
if (con.State == ConnectionState.Closed)
{
con.Open();
}
for (int k = 0; k < ent.Count; k++)
{
using (SqlCommand cmd = new SqlCommand("EC_InsertCart", trans.DatabaseConnection, trans.Transaction))
{
cmd.CommandType = CommandType.StoredProcedure;
cmd.Parameters.Add(new SqlParameter("@Cart_ID", ent[k].Cart_ID));
cmd.Parameters.Add(new SqlParameter("@Product_ID", ent[k].Product_ID));
cmd.Parameters.Add(new SqlParameter("@Quantity", ent[k].Quantity));
cmd.Parameters.Add(new SqlParameter("@Guest_ID", guestID));
try
{
dataresult = Convert.ToInt32(cmd.ExecuteScalar());
if (dataresult > 0)
{
cmd.Dispose();
}
}
catch (Exception ex)
{
dataresult = -2;
}
}
}
}
catch (Exception e)
{
dataresult = -2;
}
finally { con.Close(); }
return(dataresult);
}
// GET: Category
public int SaveProduct(Ent_Product model)
{
SafeTransaction trans = new SafeTransaction();
DateTime indianTime = TimeZoneInfo.ConvertTimeFromUtc(DateTime.UtcNow, INDIAN_ZONE);
DateTime indiTime = Convert.ToDateTime(indianTime.ToString("yyyy-MM-dd h:m:s"));
model.Created_Date = indiTime;
//HttpCookie C_UserID = Request.Cookies["User_ID"];
//string User_ID = C_UserID != null ? C_UserID.Value.Split('=')[1] : "";
//model.Created_By = Convert.ToInt32(User_ID);
model.Created_By = 1;
HttpFileCollectionBase files = Request.Files;
if (files.Count > 0)
{
HttpPostedFileBase file = files["Product_ImageFile"];
if (file != null)
{
file.SaveAs(Server.MapPath("~/ProductImages/" + model.Product_Image));
model.Product_Image = model.Product_Image;
}
}
else if (!System.IO.File.Exists(Server.MapPath("~/ProductImages/" + model.Product_Image)))
{
model.Product_Image = "";
}
int i = balProduct.SaveProduct(model, trans);
if (i > 0)
{
trans.Commit();
}
else
{
trans.Rollback();
}
return(i);
}
public int SaveOrganization(Ent_Organization model)
{
int result = 0;
SafeTransaction trans = new SafeTransaction();
DateTime indianTime = TimeZoneInfo.ConvertTimeFromUtc(DateTime.UtcNow, INDIAN_ZONE);
DateTime indiTime = Convert.ToDateTime(indianTime.ToString("yyyy-MM-dd h:m:s"));
model.Created_Date = indiTime;
//HttpCookie User_ID = Request.Cookies["User_ID"];
//model.Created_By = Convert.ToInt32(User_ID.Value.Split('=')[1]);
model.Created_By = 1;
result = balMaster.SaveOrganization(model, trans);
if (result > 0)
{
trans.Commit();
}
else
{
trans.Rollback();
}
return(result);
}
public int ActivateGuest(Ent_Guest ent, string token, SafeTransaction trans)
{
int dataresult = 0;
try
{
if (con.State == ConnectionState.Closed)
{
con.Open();
}
using (SqlCommand cmd = new SqlCommand("EC_ActivateGuest", trans.DatabaseConnection, trans.Transaction))
{
cmd.CommandType = CommandType.StoredProcedure;
cmd.Parameters.Add(new SqlParameter("@Created_Date", ent.Created_Date));
cmd.Parameters.Add(new SqlParameter("@token", token));
try
{
dataresult = Convert.ToInt32(cmd.ExecuteScalar());
if (dataresult > 0)
{
cmd.Dispose();
}
}
catch (Exception ex)
{
dataresult = -2;
InsertException(ex.Message, "ActivateGuest", 0);
}
}
}
catch (Exception e)
{
dataresult = -2;
}
finally { con.Close(); }
return(dataresult);
}
public int UpdateOrderStatus(Ent_Order ent, SafeTransaction trans)
{
int dataresult = 0;
try
{
if (con.State == ConnectionState.Closed)
{
con.Open();
}
using (SqlCommand cmd = new SqlCommand("EC_UpdateOrderStatus", trans.DatabaseConnection, trans.Transaction))
{
cmd.CommandType = CommandType.StoredProcedure;
cmd.Parameters.Add(new SqlParameter("@Created_Date", ent.Created_Date));
cmd.Parameters.Add(new SqlParameter("@status", ent.Is_Active));
cmd.Parameters.Add(new SqlParameter("@Order_ID", ent.Order_ID));
try
{
dataresult = Convert.ToInt32(cmd.ExecuteScalar());
if (dataresult > 0)
{
cmd.Dispose();
}
}
catch (Exception ex)
{
dataresult = -2;
}
}
}
catch (Exception e)
{
dataresult = -2;
}
finally { con.Close(); }
return(dataresult);
}
public int DeleteCart(int productId, int GuestID, SafeTransaction trans)
{
int dataResult = 0;
try
{
if (con.State == ConnectionState.Closed)
{
con.Open();
}
using (SqlCommand cmd = new SqlCommand("EC_DeleteCart", trans.DatabaseConnection, trans.Transaction))
{
cmd.CommandType = CommandType.StoredProcedure;
cmd.Parameters.Add(new SqlParameter("@Product_ID", productId));
cmd.Parameters.Add(new SqlParameter("@Guest_ID", GuestID));
try
{
dataResult = Convert.ToInt32(cmd.ExecuteScalar());
cmd.Dispose();
}
catch (Exception e)
{
InsertException(e.Message, "DeleteCart", GuestID);
dataResult = -1;
}
}
}
catch (Exception)
{
dataResult = -1;
}
finally
{
con.Close();
}
return(dataResult);
}
public ActionResult ActivateAccount(string id)
{
SafeTransaction trans = new SafeTransaction();
int result = 0;
if (id != null)
{
Ent_Guest ent = new Ent_Guest();
DateTime indianTime = TimeZoneInfo.ConvertTimeFromUtc(DateTime.UtcNow, INDIAN_ZONE);
DateTime indiTime = Convert.ToDateTime(indianTime.ToString("yyyy-MM-dd h:m:s"));
ent.Created_Date = indiTime;
result = balGuest.ActivateGuest(ent, id, trans);
if (result > 0)
{
trans.Commit();
}
else
{
trans.Rollback();
}
}
string message = "";
if (result > 0)
{
message = "Your Email Has Been Confirmed ! Please Login.";
}
else if (result != -2)
{
message = "Your Email Not Confirmed.";
}
return(RedirectToAction("Register", new { msg = message }));
//ViewBag.Result = result;
//return View();
}
public int DeleteUser(Ent_User ent, SafeTransaction trans)
{
int dataResult = 0;
int dataresult1 = 0;
try
{
if (con.State == ConnectionState.Closed)
{
con.Open();
}
using (SqlCommand cmd = new SqlCommand("EC_DeleteUser", trans.DatabaseConnection, trans.Transaction))
{
cmd.CommandType = CommandType.StoredProcedure;
cmd.Parameters.Add(new SqlParameter("@User_ID", ent.User_ID));
cmd.Parameters.Add(new SqlParameter("@Modified_By", ent.Modified_By));
cmd.Parameters.Add(new SqlParameter("@Modified_Date", ent.Modified_Date));
try
{
dataResult = Convert.ToInt32(cmd.ExecuteScalar());
cmd.Dispose();
}
catch (Exception e)
{
InsertException(e.Message, "DeleteUser", ent.User_ID);
dataResult = -1;
}
}
if (dataResult > 0)
{
using (SqlCommand cmd = new SqlCommand("EC_InsertLog", trans.DatabaseConnection, trans.Transaction))
{
cmd.CommandType = CommandType.StoredProcedure;
cmd.Parameters.Add(new SqlParameter("@Created_By", ent.Modified_By));
cmd.Parameters.Add(new SqlParameter("@Created_Date", ent.Modified_Date));
cmd.Parameters.Add(new SqlParameter("@Primary_Id", ent.User_ID));
cmd.Parameters.Add(new SqlParameter("@Log_Action", "Delete User"));
cmd.Parameters.Add(new SqlParameter("@Log_Status", "Admin"));
try
{
dataresult1 = Convert.ToInt32(cmd.ExecuteScalar());
if (dataresult1 > 0)
{
cmd.Dispose();
}
}
catch (Exception ex)
{
dataresult1 = -2;
}
}
}
}
catch (Exception)
{
dataResult = -1;
}
finally
{
con.Close();
}
return(dataResult);
}
