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);
}
public int SendConfirmationMail(int Order_ID, string body, string subject)
{
Ent_Order ent = new Ent_Order();
ent = balOrder.SelectOrder(Order_ID);
body = body.Replace("{{ReceivedDate}}", ent.Received_Date);
body = body.Replace("{{ShippedDate}}", ent.Shipped_Date);
body = body.Replace("{{DeliveredDate}}", ent.Delivered_Date);
body = body.Replace("{OrderID}", Order_ID.ToString());
body = body.Replace("{Total}", ent.Order_Total.ToString());
body = body.Replace("{Billing_FirstName}", ent.Billing_FirstName);
body = body.Replace("{Billing_LastName}", ent.Billing_LastName);
body = body.Replace("{Billing_Address1}", ent.Billing_Address1);
body = body.Replace("{Billing_Address2}", ent.Billing_Address2);
body = body.Replace("{Billing_Country}", ent.Billing_Country);
body = body.Replace("{Billing_Phone}", ent.Billing_Phone);
body = body.Replace("{Shipping_FirstName}", ent.Shipping_FirstName);
body = body.Replace("{Shipping_LastName}", ent.Shipping_LastName);
body = body.Replace("{Shipping_Address1}", ent.Shipping_Address1);
body = body.Replace("{Shipping_Address2}", ent.Shipping_Address2);
body = body.Replace("{Shipping_Country}", ent.Shipping_Country);
body = body.Replace("{Shipping_Phone}", ent.Shipping_Phone);
int i = SendMail(body, ent.Billing_Email, subject);
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 ActionResult Orders()
{
int OrderID = Request.QueryString["OrderID"] != null?Convert.ToInt32(Request.QueryString["OrderID"]) : 0;
Ent_Order entOrder = new Ent_Order();
entOrder = balOrder.SelectOrder(OrderID);
List <Ent_OrderDetail> OrderList = new List <Ent_OrderDetail>();
OrderList = balOrder.SelectOrderDetails(OrderID);
ViewBag.OrderList = OrderList;
return(View(entOrder));
}
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 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 Ent_Order SelectOrder(int OrderID)
{
Ent_Order ent = new Ent_Order();
try
{
Dal_Order dal = new Dal_Order();
ent = dal.SelectOrder(OrderID);
return(ent);
}
catch
{
return(ent);
}
}
public ActionResult TrackOrder(int Order_ID)
{
List <Ent_OrderDetail> list = new List <Ent_OrderDetail>();
Ent_Order ent = new Ent_Order();
if (Order_ID != 0)
{
list = balOrder.SelectOrderDetails(Order_ID);
ViewBag.OrderDetails = list;
if (list.Count > 0)
{
ent = list[0].entOrder;
}
}
return(View(ent));
}
public ActionResult ViewOrder()
{
int Order_ID = Request.QueryString["Id"] != null?Convert.ToInt32(Request.QueryString["Id"]) : 0;
List <Ent_OrderDetail> list = new List <Ent_OrderDetail>();
Ent_Order ent = new Ent_Order();
if (Order_ID != 0)
{
list = balOrder.SelectOrderDetails(Order_ID);
ViewBag.OrderDetails = list;
if (list.Count > 0)
{
ent = list[0].entOrder;
}
}
return(View(ent));
}
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 Ent_Order SelectOrder(int OrderID)
{
Ent_Order ent = new Ent_Order();
int guestid = 0;
try
{
using (SqlCommand cmd = new SqlCommand("EC_SelectGuestOrder", con))
{
if (con.State == ConnectionState.Closed)
{
con.Open();
}
cmd.CommandType = CommandType.StoredProcedure;
cmd.Parameters.Add(new SqlParameter("@Guest_ID", guestid));
cmd.Parameters.Add(new SqlParameter("@Order_ID", OrderID));
IDataReader dr = cmd.ExecuteReader();
while (dr.Read())
{
ent = new Ent_Order();
ent.Order_ID = Convert.ToInt32(dr["Order_ID"]);
ent.Guest_ID = Convert.ToInt32(dr["Guest_ID"]);
ent.Created_Date = Convert.ToDateTime(dr["Created_Date"]);
ent.Is_Active = Convert.ToInt32(dr["Is_Active"]);
ent.Order_Total = Convert.ToDouble(dr["Order_Total"]);
ent.Order_SubTotal = Convert.ToDouble(dr["Order_SubTotal"]);
ent.Order_Shipping = Convert.ToDouble(dr["Order_Shipping"]);
ent.Total_Qty = Convert.ToInt32(dr["Total_Qty"]);
ent.Is_Active = Convert.ToInt32(dr["Is_Active"]);
if (dr["Received_Date"].ToString() == "")
{
ent.Received_Date = null;
}
else
{
ent.Received_Date = dr["Received_Date"].ToString();
}
if (dr["Shipped_Date"].ToString() == "")
{
ent.Shipped_Date = null;
}
else
{
ent.Shipped_Date = dr["Shipped_Date"].ToString();
}
if (dr["Delivered_Date"].ToString() == "")
{
ent.Delivered_Date = null;
}
else
{
ent.Delivered_Date = dr["Delivered_Date"].ToString();
}
if (dr["Cancel_Date"].ToString() == "")
{
ent.Cancel_Date = null;
}
else
{
ent.Cancel_Date = dr["Cancel_Date"].ToString();
}
if (dr["Return_Date"].ToString() == "")
{
ent.Return_Date = null;
}
else
{
ent.Return_Date = dr["Return_Date"].ToString();
}
ent.Billing_FirstName = Convert.ToString(dr["Billing_FirstName"]);
ent.Billing_LastName = Convert.ToString(dr["Billing_LastName"]);
ent.Billing_Address1 = Convert.ToString(dr["Billing_Address1"]);
ent.Billing_Address2 = Convert.ToString(dr["Billing_Address2"]);
ent.Billing_Town = Convert.ToString(dr["Billing_Town"]);
ent.Billing_State = Convert.ToString(dr["Billing_State"]);
ent.Billing_Country = Convert.ToString(dr["Billing_Country"]);
ent.Billing_Email = Convert.ToString(dr["Billing_Email"]);
ent.Billing_Phone = Convert.ToString(dr["Billing_Phone"]);
ent.Shipping_FirstName = Convert.ToString(dr["Shipping_FirstName"]);
ent.Shipping_LastName = Convert.ToString(dr["Shipping_LastName"]);
ent.Shipping_Address1 = Convert.ToString(dr["Shipping_Address1"]);
ent.Shipping_Address2 = Convert.ToString(dr["Shipping_Address2"]);
ent.Shipping_Town = Convert.ToString(dr["Shipping_Town"]);
ent.Shipping_State = Convert.ToString(dr["Shipping_State"]);
ent.Shipping_Country = Convert.ToString(dr["Shipping_Country"]);
ent.Shipping_Email = Convert.ToString(dr["Shipping_Email"]);
ent.Shipping_Phone = Convert.ToString(dr["Shipping_Phone"]);
ent.Payment_COD = Convert.ToInt32(dr["Payment_COD"]);
ent.Created_Date = Convert.ToDateTime(dr["Created_Date"]);
}
}
}
catch (Exception ex)
{
InsertException(ex.Message, "SelectOrder", OrderID);
}
finally
{
con.Close();
}
return(ent);
}
public List <Ent_Order> SelectGuestOrder(int guestID)
{
List <Ent_Order> result = new List <Ent_Order>();
Ent_Order ent = new Ent_Order();
int orderid = 0;
try
{
using (SqlCommand cmd = new SqlCommand("EC_SelectGuestOrder", con))
{
if (con.State == ConnectionState.Closed)
{
con.Open();
}
cmd.CommandType = CommandType.StoredProcedure;
cmd.Parameters.Add(new SqlParameter("@Guest_ID", guestID));
cmd.Parameters.Add(new SqlParameter("@Order_ID", orderid));
IDataReader dr = cmd.ExecuteReader();
while (dr.Read())
{
ent = new Ent_Order();
ent.Order_ID = Convert.ToInt32(dr["Order_ID"]);
ent.Created_Date = Convert.ToDateTime(dr["Created_Date"]);
ent.Is_Active = Convert.ToInt32(dr["Is_Active"]);
ent.Order_Total = Convert.ToDouble(dr["Order_Total"]);
ent.Order_SubTotal = Convert.ToDouble(dr["Order_SubTotal"]);
ent.Order_Shipping = Convert.ToDouble(dr["Order_Shipping"]);
ent.Total_Qty = Convert.ToInt32(dr["Total_Qty"]);
ent.Billing_FirstName = Convert.ToString(dr["Billing_FirstName"]);
ent.Billing_LastName = Convert.ToString(dr["Billing_LastName"]);
ent.Billing_Address1 = Convert.ToString(dr["Billing_Address1"]);
ent.Billing_Address2 = Convert.ToString(dr["Billing_Address2"]);
ent.Billing_Town = Convert.ToString(dr["Billing_Town"]);
ent.Billing_State = Convert.ToString(dr["Billing_State"]);
ent.Billing_Country = Convert.ToString(dr["Billing_Country"]);
ent.Billing_Email = Convert.ToString(dr["Billing_Email"]);
ent.Billing_Phone = Convert.ToString(dr["Billing_Phone"]);
ent.Shipping_FirstName = Convert.ToString(dr["Shipping_FirstName"]);
ent.Shipping_LastName = Convert.ToString(dr["Shipping_LastName"]);
ent.Shipping_Address1 = Convert.ToString(dr["Shipping_Address1"]);
ent.Shipping_Address2 = Convert.ToString(dr["Shipping_Address2"]);
ent.Shipping_Town = Convert.ToString(dr["Shipping_Town"]);
ent.Shipping_State = Convert.ToString(dr["Shipping_State"]);
ent.Shipping_Country = Convert.ToString(dr["Shipping_Country"]);
ent.Shipping_Email = Convert.ToString(dr["Shipping_Email"]);
ent.Shipping_Phone = Convert.ToString(dr["Shipping_Phone"]);
ent.Created_Date = Convert.ToDateTime(dr["Created_Date"]);
result.Add(ent);
}
}
}
catch (Exception ex)
{
InsertException(ex.Message, "SelectGuestOrder", guestID);
}
finally
{
con.Close();
}
return(result);
}
public int UpdatePayment(Ent_Order entOrder, SafeTransaction trans)
{
int dataresult = 0;
int dataresult1 = 0;
try
{
if (con.State == ConnectionState.Closed)
{
con.Open();
}
using (SqlCommand cmd = new SqlCommand("EC_UpdateOrder", trans.DatabaseConnection, trans.Transaction))
{
cmd.CommandType = CommandType.StoredProcedure;
cmd.Parameters.Add(new SqlParameter("@Order_ID", entOrder.Order_ID));
cmd.Parameters.Add(new SqlParameter("@Payment_Status", entOrder.Payment_Status));
cmd.Parameters.Add(new SqlParameter("@Transaction_Id", entOrder.Transaction_Id));
cmd.Parameters.Add(new SqlParameter("@Payment_Method", entOrder.Payment_Method));
try
{
dataresult = Convert.ToInt32(cmd.ExecuteScalar());
if (dataresult > 0)
{
cmd.Dispose();
dataresult1 = 1;
if (dataresult1 > 0)
{
if (entOrder.Guest_ID != 0 && entOrder.Payment_Status == "CAPTURED")
{
var query = "delete from EC_Cart where Guest_ID=" + entOrder.Guest_ID;
int k = 0;
using (SqlCommand cmd2 = new SqlCommand(query, trans.DatabaseConnection, trans.Transaction))
{
try
{
k = cmd2.ExecuteNonQuery();
cmd2.Dispose();
}
catch (Exception ex)
{
dataresult = 0;
}
}
}
}
}
}
catch (Exception ex)
{
dataresult = -2;
}
}
}
catch (Exception e)
{
dataresult = -2;
}
finally { con.Close(); }
return(dataresult);
}
public int SaveOrder(Ent_Order ent, SafeTransaction trans)
{
int dataresult = 0;
int dataresult1 = 0;
try
{
if (con.State == ConnectionState.Closed)
{
con.Open();
}
using (SqlCommand cmd = new SqlCommand("EC_InsertOrder", trans.DatabaseConnection, trans.Transaction))
{
cmd.CommandType = CommandType.StoredProcedure;
cmd.Parameters.Add(new SqlParameter("@Order_ID", ent.Order_ID));
cmd.Parameters.Add(new SqlParameter("@Guest_ID", ent.Guest_ID));
cmd.Parameters.Add(new SqlParameter("@Shipping_FirstName", ent.Shipping_FirstName));
cmd.Parameters.Add(new SqlParameter("@Shipping_LastName", ent.Shipping_LastName));
cmd.Parameters.Add(new SqlParameter("@Shipping_Address1", ent.Shipping_Address1));
cmd.Parameters.Add(new SqlParameter("@Shipping_Address2", ent.Shipping_Address2));
cmd.Parameters.Add(new SqlParameter("@Shipping_Town", ent.Shipping_Town));
cmd.Parameters.Add(new SqlParameter("@Shipping_State", ent.Shipping_State));
cmd.Parameters.Add(new SqlParameter("@Shipping_Country", ent.Shipping_Country));
cmd.Parameters.Add(new SqlParameter("@Shipping_Email", ent.Shipping_Email));
cmd.Parameters.Add(new SqlParameter("@Shipping_Phone", ent.Shipping_Phone));
cmd.Parameters.Add(new SqlParameter("@Billing_FirstName", ent.Billing_FirstName));
cmd.Parameters.Add(new SqlParameter("@Billing_LastName", ent.Billing_LastName));
cmd.Parameters.Add(new SqlParameter("@Billing_Address1", ent.Billing_Address1));
cmd.Parameters.Add(new SqlParameter("@Billing_Address2", ent.Billing_Address2));
cmd.Parameters.Add(new SqlParameter("@Billing_Town", ent.Billing_Town));
cmd.Parameters.Add(new SqlParameter("@Billing_State", ent.Billing_State));
cmd.Parameters.Add(new SqlParameter("@Billing_Country", ent.Billing_Country));
cmd.Parameters.Add(new SqlParameter("@Billing_Email", ent.Billing_Email));
cmd.Parameters.Add(new SqlParameter("@Billing_Phone", ent.Billing_Phone));
cmd.Parameters.Add(new SqlParameter("@Order_SubTotal", ent.Order_SubTotal));
cmd.Parameters.Add(new SqlParameter("@Order_Shipping", ent.Order_Shipping));
cmd.Parameters.Add(new SqlParameter("@Order_Total", ent.Order_Total));
cmd.Parameters.Add(new SqlParameter("@Created_Date", ent.Created_Date));
cmd.Parameters.Add(new SqlParameter("@Payment_COD", ent.Payment_COD));
try
{
dataresult = Convert.ToInt32(cmd.ExecuteScalar());
if (dataresult > 0)
{
cmd.Dispose();
if (ent.OrderDetailsList != null)
{
for (int i = 0; i < ent.OrderDetailsList.Count; i++)
{
using (SqlCommand cmd1 = new SqlCommand("EC_InsertOrderDetails", trans.DatabaseConnection, trans.Transaction))
{
cmd1.CommandType = CommandType.StoredProcedure;
cmd1.Parameters.Add(new SqlParameter("@OrderDetail_ID", ent.OrderDetailsList[i].OrderDetail_ID));
cmd1.Parameters.Add(new SqlParameter("@Order_ID", dataresult));
cmd1.Parameters.Add(new SqlParameter("@Product_ID", ent.OrderDetailsList[i].Product_ID));
cmd1.Parameters.Add(new SqlParameter("@Quantity", ent.OrderDetailsList[i].Quantity));
cmd1.Parameters.Add(new SqlParameter("@Product_Price", ent.OrderDetailsList[i].Product_Price));
cmd1.Parameters.Add(new SqlParameter("@Product_Total", ent.OrderDetailsList[i].Product_Total));
try
{
dataresult1 = Convert.ToInt32(cmd1.ExecuteScalar());
cmd1.Dispose();
}
catch (Exception ex)
{
dataresult = 0;
InsertException(ex.Message, "SaveOrderDetail", ent.OrderDetailsList[i].OrderDetail_ID);
}
}
}
//if (dataresult1 > 0)
//{
// if (ent.Guest_ID != 0)
// {
// var query = "delete from EC_Cart where Guest_ID=" + ent.Guest_ID;
// int k = 0;
// using (SqlCommand cmd2 = new SqlCommand(query, trans.DatabaseConnection, trans.Transaction))
// {
// try
// {
// k = cmd2.ExecuteNonQuery();
// cmd2.Dispose();
// }
// catch (Exception ex)
// {
// dataresult = 0;
// }
// }
// }
//}
}
else
{
dataresult = 0;
}
}
}
catch (Exception ex)
{
dataresult = -2;
}
}
}
catch (Exception e)
{
dataresult = -2;
}
finally { con.Close(); }
return(dataresult);
}
public int SaveOrder(Ent_Order 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 Guest_ID = Request.Cookies["Guest_ID"];
string GuestID = Guest_ID != null?Guest_ID.Value.Split('=')[1] : "";
if (!string.IsNullOrEmpty(GuestID))
{
model.Guest_ID = Convert.ToInt32(GuestID);
Ent_GuestAddress entAddress = new Ent_GuestAddress();
entAddress = balguest.SelectGuestAddress(Convert.ToInt32(GuestID));
if (entAddress.Guest_Address1 != "")
{
model.Billing_FirstName = entAddress.First_Name;
model.Billing_LastName = entAddress.Last_Name;
model.Billing_Address1 = entAddress.Guest_Address1;
model.Billing_Address2 = entAddress.Guest_Address2;
model.Billing_State = entAddress.Guest_State;
model.Billing_Town = entAddress.Guest_Town;
model.Billing_Country = entAddress.Guest_Country;
}
else
{
model.Billing_FirstName = model.Shipping_FirstName;
model.Billing_LastName = model.Shipping_LastName;
model.Billing_Address1 = model.Shipping_Address1;
model.Billing_Address2 = model.Shipping_Address2;
model.Billing_State = model.Shipping_State;
model.Billing_Town = model.Shipping_Town;
model.Billing_Country = model.Shipping_Country;
}
}
else
{
model.Guest_ID = 0;
model.Billing_FirstName = model.Shipping_FirstName;
model.Billing_LastName = model.Shipping_LastName;
model.Billing_Address1 = model.Shipping_Address1;
model.Billing_Address2 = model.Shipping_Address2;
model.Billing_State = model.Shipping_State;
model.Billing_Town = model.Shipping_Town;
model.Billing_Country = model.Shipping_Country;
}
model.Billing_Email = model.Shipping_Email;
model.Billing_Phone = model.Shipping_Phone;
model.Order_SubTotal = Convert.ToDouble(Session["SubTotal"]);
model.Order_Shipping = 0;
model.Order_Total = Convert.ToDouble(Session["Total"]);
model.OrderDetailsList = (List <Ent_OrderDetail>)Session["Cart"];
int i = balOrder.SaveOrder(model, trans);
if (i > 0)
{
trans.Commit();
if (model.Payment_COD == 1)
{
string body = string.Empty; var lnkHref = "";
if (string.IsNullOrEmpty(GuestID))
{
lnkHref = "<a href='https://acsadmin.atintellilabs.live/" + @Url.Action("TrackOrder", "Order", new { Order_ID = i }) + "' 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(i, body, "Order Confirmation");
if (!string.IsNullOrEmpty(GuestID))
{
SafeTransaction transac = new SafeTransaction();
int result = balOrder.DeleteCart(0, Convert.ToInt32(GuestID), 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);
}