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 Ent_Guest SelectLogin(Ent_Guest entR)
{
Ent_Guest ent = new Ent_Guest();
try
{
string query = "select * from EC_GuestLogin where Guest_Username='******' and Guest_Password= '******' and Is_Active=1";
using (SqlCommand cmd = new SqlCommand(query, con))
{
if (con.State == ConnectionState.Closed)
{
con.Open();
}
IDataReader dr = cmd.ExecuteReader();
while (dr.Read())
{
ent.Guest_ID = Convert.ToInt32(dr["Guest_ID"]);
ent.Guest_FirstName = Convert.ToString(dr["Guest_FirstName"]);
ent.Guest_Username = Convert.ToString(dr["Guest_Username"]);
ent.Guest_Password = Convert.ToString(dr["Guest_Password"]);
}
}
}
catch (Exception ex)
{
InsertException(ex.Message, "SelectLogin", 0);
}
finally
{
con.Close();
}
return(ent);
}
public ActionResult Checkout()
{
HttpCookie Guest_ID = Request.Cookies["Guest_ID"];
int GuestID = Guest_ID != null?Convert.ToInt32(Guest_ID.Value.Split('=')[1]) : 0;
Ent_Guest ent = new Ent_Guest();
ent = balguest.SelectGuestDetails(GuestID);
return(View(ent));
}
public Ent_Guest SelectGuestDetails(int ID)
{
Ent_Guest ent = new Ent_Guest();
try
{
Dal_Guest dal = new Dal_Guest();
ent = dal.SelectGuestDetails(ID);
return(ent);
}
catch
{
return(ent);
}
}
public Ent_Guest SelectLogin(Ent_Guest entGuest)
{
Ent_Guest ent = new Ent_Guest();
try
{
Dal_Guest dal = new Dal_Guest();
ent = dal.SelectLogin(entGuest);
return(ent);
}
catch
{
return(ent);
}
}
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 ActionResult ContactUs(Ent_Guest ent)
{
try
{
using (MailMessage mail = new MailMessage())
{
int port = 587;
string host = "smtp.yandex.com.tr";
string sendmail = "*****@*****.**";
string password = "******";
mail.From = new MailAddress(sendmail, "ContactUs");
//mail.To.Add("*****@*****.**");
mail.To.Add("*****@*****.**");
mail.Subject = ent.Subject;
mail.IsBodyHtml = true;
string body = "<html><title>" + ent.Subject + "</title><body>From: " + ent.Guest_FirstName + "<br/>";
body += "Email: " + ent.Guest_Email + "<br/>";
body += "Message: " + ent.Message + "</body></html>";
AlternateView htmlView = AlternateView.CreateAlternateViewFromString(body, null, "text/html");
mail.AlternateViews.Add(htmlView);
using (SmtpClient emailClient = new SmtpClient(host, port))
{
System.Net.NetworkCredential userInfo = new System.Net.NetworkCredential(sendmail, password);
emailClient.UseDefaultCredentials = false;
emailClient.EnableSsl = true;
emailClient.DeliveryFormat = SmtpDeliveryFormat.International;
emailClient.DeliveryMethod = SmtpDeliveryMethod.Network;
if (!string.IsNullOrEmpty(userInfo.UserName.Trim()) && !string.IsNullOrEmpty(userInfo.Password.Trim()))
{
emailClient.Credentials = userInfo;
}
emailClient.Send(mail);
}
}
ViewBag.Message = "Thank you for Contacting us.";
}
catch (Exception e)
{
ViewBag.Message = "Sorry we are facing Problem here";
}
return(View());
}
public Ent_Guest SelectGuestDetails(int ID)
{
Ent_Guest ent = new Ent_Guest();
try
{
using (SqlCommand cmd = new SqlCommand("EC_SelectGuestDetails", con))
{
if (con.State == ConnectionState.Closed)
{
con.Open();
}
cmd.CommandType = CommandType.StoredProcedure;
cmd.Parameters.Add(new SqlParameter("@Guest_ID", ID));
IDataReader dr = cmd.ExecuteReader();
while (dr.Read())
{
ent.Guest_ID = Convert.ToInt32(dr["Guest_ID"]);
ent.Guest_Username = Convert.ToString(dr["Guest_Username"]);
ent.Guest_Password = Convert.ToString(dr["Guest_Password"]);
ent.Guest_FirstName = Convert.ToString(dr["Guest_FirstName"]);
ent.Guest_LastName = Convert.ToString(dr["Guest_LastName"]);
ent.Guest_Email = Convert.ToString(dr["Guest_Email"]);
ent.Guest_Phone = Convert.ToString(dr["Guest_Phone"]);
ent.entGuestAddress.First_Name = Convert.ToString(dr["First_Name"]);
ent.entGuestAddress.Last_Name = Convert.ToString(dr["Last_Name"]);
ent.entGuestAddress.Guest_Address1 = Convert.ToString(dr["Guest_Address1"]);
ent.entGuestAddress.Guest_Address2 = Convert.ToString(dr["Guest_Address2"]);
ent.entGuestAddress.Guest_Town = Convert.ToString(dr["Guest_Town"]);
ent.entGuestAddress.Guest_State = Convert.ToString(dr["Guest_State"]);
ent.entGuestAddress.Guest_Country = Convert.ToString(dr["Guest_Country"]);
}
}
}
catch (Exception ex)
{
InsertException(ex.Message, "SelectLogin", 0);
}
finally
{
con.Close();
}
return(ent);
}
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 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 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();
}
//Login
public int CreateLogin(string Username, string Password)
{
int i = 0;
if (Username != "" && Password != "")
{
Ent_Guest entu = new Ent_Guest();
Ent_Guest result = new Ent_Guest();
entu.Guest_Username = Username;
entu.Guest_Password = Password;
result = balGuest.SelectLogin(entu);
if (result != null)
{
if (result.Guest_ID > 0)
{
//Login User ID
HttpCookie Guest_ID = new HttpCookie("Guest_ID");
Guest_ID.Values["Guest_ID"] = Convert.ToString(result.Guest_ID);
Guest_ID.Expires = DateTime.Now.AddMinutes(10);
Response.Cookies.Add(Guest_ID);
//Login User Name
HttpCookie Guest_FirstName = new HttpCookie("Guest_FirstName");
if (result.Guest_FirstName != "")
{
Guest_FirstName.Values["Guest_FirstName"] = Convert.ToString(result.Guest_FirstName);
}
else
{
Guest_FirstName.Values["Guest_FirstName"] = Convert.ToString(result.Guest_Username);
}
Guest_FirstName.Expires = DateTime.Now.AddMinutes(10);
Response.Cookies.Add(Guest_FirstName);
List <Ent_OrderDetail> list = new List <Ent_OrderDetail>();
list = balOrder.SelectCart(result.Guest_ID);
if (list.Count == 0 && Session["Cart"] != null)
{
List <Ent_OrderDetail> item = (List <Ent_OrderDetail>)Session["Cart"];
SafeTransaction trans = new SafeTransaction();
int r = balOrder.InsertCartList(item, result.Guest_ID, trans);
if (r > 0)
{
trans.Commit();
}
else
{
trans.Rollback();
}
}
else
{
Session["Cart"] = list;
Session["Total"] = Session["SubTotal"] = list.Sum(y => y.Product_Total);
}
i = 1;
}
else
{
if (Request.Cookies["Guest_ID"] != null)
{
HttpCookie myCookie = new HttpCookie("Guest_ID");
myCookie.Expires = DateTime.Now.AddDays(-1);
Response.Cookies.Add(myCookie);
}
if (Request.Cookies["Guest_FirstName"] != null)
{
HttpCookie myCookie = new HttpCookie("Guest_FirstName");
myCookie.Expires = DateTime.Now.AddDays(-1);
Response.Cookies.Add(myCookie);
}
i = -1;
}
}
else
{
i = -1;
}
}
else
{
i = 0;
}
return(i);
}
public int SaveGuest(Ent_Guest ent, SafeTransaction trans)
{
int dataresult = 0;
int dataresult1 = 0;
try
{
if (con.State == ConnectionState.Closed)
{
con.Open();
}
using (SqlCommand cmd = new SqlCommand("EC_InsertGuest", trans.DatabaseConnection, trans.Transaction))
{
cmd.CommandType = CommandType.StoredProcedure;
cmd.Parameters.Add(new SqlParameter("@Guest_ID", ent.Guest_ID));
cmd.Parameters.Add(new SqlParameter("@Guest_FirstName", ent.Guest_FirstName));
cmd.Parameters.Add(new SqlParameter("@Guest_LastName", ent.Guest_LastName));
cmd.Parameters.Add(new SqlParameter("@Guest_Email", ent.Guest_Username));
cmd.Parameters.Add(new SqlParameter("@Guest_Phone", ent.Guest_Phone));
cmd.Parameters.Add(new SqlParameter("@Guest_Username", ent.Guest_Username));
cmd.Parameters.Add(new SqlParameter("@Guest_Password", ent.Guest_Password));
cmd.Parameters.Add(new SqlParameter("@Created_Date", ent.Created_Date));
cmd.Parameters.Add(new SqlParameter("@Unique_ID", ent.Unique_ID));
try
{
dataresult = Convert.ToInt32(cmd.ExecuteScalar());
if (dataresult > 0)
{
cmd.Dispose();
}
}
catch (Exception ex)
{
dataresult = -2;
InsertException(ex.Message, "SaveGuest", ent.Guest_ID);
}
}
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.Guest_ID));
cmd.Parameters.Add(new SqlParameter("@Created_Date", ent.Created_Date));
cmd.Parameters.Add(new SqlParameter("@Primary_Id", dataresult));
if (ent.Guest_ID > 0)
{
cmd.Parameters.Add(new SqlParameter("@Log_Action", "Save Guest"));
}
else
{
cmd.Parameters.Add(new SqlParameter("@Log_Action", "Update Guest"));
}
cmd.Parameters.Add(new SqlParameter("@Log_Status", "Guest"));
try
{
dataresult1 = Convert.ToInt32(cmd.ExecuteScalar());
if (dataresult1 > 0)
{
cmd.Dispose();
}
}
catch (Exception ex)
{
dataresult1 = -2;
}
}
}
}
catch (Exception e)
{
dataresult = -2;
}
finally { con.Close(); }
return(dataresult);
}
