public Ent_GuestAddress SelectGuestAddress(int ID) { Ent_GuestAddress ent = new Ent_GuestAddress(); try { Dal_Guest dal = new Dal_Guest(); ent = dal.SelectGuestAddress(ID); return(ent); } catch { return(ent); } }
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 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 List <Ent_GuestAddress> SelectGuestAddressList(int ID) { List <Ent_GuestAddress> list = new List <Ent_GuestAddress>(); Ent_GuestAddress ent = new Ent_GuestAddress(); try { string query = "select * from EC_GuestAddress where Guest_ID=" + ID; using (SqlCommand cmd = new SqlCommand(query, con)) { if (con.State == ConnectionState.Closed) { con.Open(); } IDataReader dr = cmd.ExecuteReader(); while (dr.Read()) { ent = new Ent_GuestAddress(); ent.Address_ID = Convert.ToInt32(dr["Address_ID"]); ent.Guest_ID = Convert.ToInt32(dr["Guest_ID"]); ent.First_Name = Convert.ToString(dr["First_Name"]); ent.Last_Name = Convert.ToString(dr["Last_Name"]); ent.Guest_Address1 = Convert.ToString(dr["Guest_Address1"]); ent.Guest_Address2 = Convert.ToString(dr["Guest_Address2"]); ent.Guest_Town = Convert.ToString(dr["Guest_Town"]); ent.Guest_State = Convert.ToString(dr["Guest_State"]); ent.Guest_Country = Convert.ToString(dr["Guest_Country"]); ent.Address_Type = Convert.ToString(dr["Address_Type"]); ent.Address_Default = Convert.ToInt32(dr["Address_Default"]); list.Add(ent); } } } catch (Exception ex) { InsertException(ex.Message, "SelectGuestAddressList", ID); } finally { con.Close(); } return(list); }
public ActionResult MyAccount() { HttpCookie Guest_ID = Request.Cookies["Guest_ID"]; int GuestID = Guest_ID != null?Convert.ToInt32(Guest_ID.Value.Split('=')[1]) : 0; List <Ent_Order> list = new List <Ent_Order>(); List <Ent_GuestAddress> AddressList = new List <Ent_GuestAddress>(); Ent_Guest entGuest = new Ent_Guest(); if (GuestID != 0) { list = balOrder.SelectGuestOrder(GuestID); entGuest = balGuest.SelectGuestDetails(GuestID); AddressList = balGuest.SelectGuestAddressList(GuestID); } ViewBag.OrderList = list; Ent_GuestAddress entHome = new Ent_GuestAddress(); Ent_GuestAddress entWork = new Ent_GuestAddress(); Ent_GuestAddress entOther = new Ent_GuestAddress(); var home = AddressList.Where(x => x.Address_Type == "Home").FirstOrDefault(); var work = AddressList.Where(x => x.Address_Type == "Work").FirstOrDefault(); var other = AddressList.Where(x => x.Address_Type == "Other").FirstOrDefault(); if (home != null) { entHome = home; } if (work != null) { entWork = work; } if (other != null) { entOther = other; } ViewBag.HomeAddress = entHome; ViewBag.WorkAddress = entWork; ViewBag.OtherAddress = entOther; return(View(entGuest)); }
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 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); }