public static int CreateOrderForUser(int ArcId, string CreatedBy, string UserName, string UserEmail, string UserId)
{
LinqToSqlDataContext db = new LinqToSqlDataContext();
int orderId = 0;
var ordr = db.USP_CreateOrderForUser(ArcId, CreatedBy, UserName, UserEmail, UserId).SingleOrDefault();
if (ordr != null)
{
if (ordr.OrderId.HasValue)
{
int.TryParse(ordr.OrderId.Value.ToString(), out orderId);
}
}
db.Dispose();
return(orderId);
}
public void LoadUserInfo()
{
if (Session[enumSessions.User_Id.ToString()] != null)
{
ARC arc = ArcBAL.GetArcInfoByUserId(new Guid(Session[enumSessions.User_Id.ToString()].ToString()));
if (arc == null)
{
ltrErrorMsg.Text = "User does not belong to any ARC.";
return;
}
if (arc.IsBulkUploadAllowed)
{
hyprLnkBulkUpload.Visible = true;
}
Session[enumSessions.ARC_Id.ToString()] = arc.ARCId;
Session[enumSessions.IsARC_AllowReturns.ToString()] = arc.AllowReturns;
lblUsername.Text = Session[enumSessions.User_Name.ToString()].ToString();
if (arc.CompanyName.Length > 30)
{
lblARCCompany.Text = arc.CompanyName.Substring(0, 30) + "...";
}
else
{
lblARCCompany.Text = arc.CompanyName;
}
LinqToSqlDataContext db = new LinqToSqlDataContext();
var OrderInfo = db.USP_CreateOrderForUser(arc.ARCId, Session[enumSessions.User_Name.ToString()].ToString(), Session[enumSessions.User_Name.ToString()].ToString(), Session[enumSessions.User_Email.ToString()].ToString(), Session[enumSessions.User_Id.ToString()].ToString()).SingleOrDefault();
if (OrderInfo != null)
{
Session[enumSessions.OrderId.ToString()] = OrderInfo.OrderId;
lblOrderTotal.Text = OrderInfo.Amount.ToString();
Session[enumSessions.HasUserAcceptedDuplicates.ToString()] = OrderInfo.HasUserAcceptedDuplicates;
lblBasket.Text = OrderInfo.Quantity.ToString();
Session[enumSessions.OrderNumber.ToString()] = OrderInfo.OrderNo.ToString();
basketProducts = db.OrderItems.Where(num => num.OrderId == Convert.ToInt32(Session[enumSessions.OrderId.ToString()])).Count().ToString();
if (basketProducts == "0")
{
basketProducts = string.Empty;
}
if (OrderInfo.InstallerId != "0")
{
Session[enumSessions.InstallerCompanyID.ToString()] = OrderInfo.InstallerId;
Session[enumSessions.SelectedInstaller.ToString()] = OrderInfo.SelectedInstaller;
}
}
db.Dispose();
if (Session[enumSessions.User_Role.ToString()] != null && Session[enumSessions.User_Role.ToString()].ToString() == enumRoles.ARC_Admin.ToString())
{
lblOrderTotal.Text = "0.00";
// AarcadminMenu.Style.Add("visibility", "visible");
}
Amyacc.Style.Add("visibility", "visible"); // Visible for all
if (Session[enumSessions.SelectedInstaller.ToString()] != null)
{
if (Session[enumSessions.SelectedInstaller.ToString()].ToString().Length > 30)
{
lblInstallerName.Text = Session[enumSessions.SelectedInstaller.ToString()].ToString().Substring(0, 30) + "...";
}
else
{
lblInstallerName.Text = Session[enumSessions.SelectedInstaller.ToString()].ToString();
}
}
if (Session[enumSessions.InstallerCompanyID.ToString()] != null)
{
HyperLink1.Enabled = true;
}
btnLogOut.Visible = true;
}
else
{
lblUsername.Text = "Guest";
lblARCCompany.Text = "Guest";
lblBasket.Text = "0";
lblOrderTotal.Text = "0.00";
lblInstallerName.Text = "";
}
}
protected void ProductsRepeater_ItemBound(object sender, RepeaterItemEventArgs args)
{
try
{
if (args.Item.ItemType == ListItemType.Item || args.Item.ItemType == ListItemType.AlternatingItem)
{
LinqToSqlDataContext db = new LinqToSqlDataContext();
if (String.IsNullOrEmpty(hidProductCode.Value))
{
hidProductCode.Value = (args.Item.FindControl("lblProductCode") as Label).Text;
}
else if (hidProductCode.Value.ToString() != (args.Item.FindControl("lblProductCode") as Label).Text)
{
hidProductCode.Value = (args.Item.FindControl("lblProductCode") as Label).Text;
count = 1;
}
HtmlControl tdManufacturer = args.Item.FindControl("tdManufacturer") as HtmlControl;
tdManufacturer.Visible = true;
//
string name = (from dcc in db.DCCCompanies
where dcc.Productcode.Contains(hidProductCode.Value)
select dcc.company_name).SingleOrDefault();
if (name != null)
{
Label lblManufacturer = args.Item.FindControl("lblManufacturer") as Label;
lblManufacturer.Visible = true;
lblManufacturer.Text = name;
}
if (Session[enumSessions.User_Role.ToString()] != null && Session[enumSessions.User_Role.ToString()].ToString() == enumRoles.ARC_Admin.ToString())
{
Label lblProductPrice = (Label)args.Item.FindControl("lblProductPrice");
lblProductPrice.Text = String.Empty; //0.00
Label lblProductPriceTotal = (Label)args.Item.FindControl("lblProductPriceTotal");
lblProductPriceTotal.Text = String.Empty; //0.00
}
Label lblProductCode = (Label)args.Item.FindControl("lblProductCode");
int rowCount = db.USP_GetBasketProductsOnCheckOut(Convert.ToInt32(Session[enumSessions.OrderId.ToString()].ToString())).Where(i => i.ProductCode == lblProductCode.Text.Trim()).Count();
if (rowCount == count)
{
USP_GetBasketProductsOnCheckOutResult product = (USP_GetBasketProductsOnCheckOutResult)args.Item.DataItem;
Repeater rep = (Repeater)args.Item.FindControl("rptrDependentProducts");
rep.DataSource = db.USP_GetBasketDependentProductsByProductId(Convert.ToInt32(Session[enumSessions.OrderId.ToString()].ToString()), product.ProductId, product.CategoryId);
rep.DataBind();
if (rep.Items.Count == 0)
{
rep.Visible = false;
}
db.Dispose();
}
count++;
}
if (args.Item.ItemType == ListItemType.Footer)
{
Label lblTotalPrice = (Label)args.Item.FindControl("lblTotalPrice");
Label lblTotalQty = (Label)args.Item.FindControl("lblTotalQty");
LinqToSqlDataContext db = new LinqToSqlDataContext();
var OrderInfo = db.USP_CreateOrderForUser(Convert.ToInt32(Session[enumSessions.ARC_Id.ToString()].ToString()), Session[enumSessions.User_Name.ToString()].ToString(), Session[enumSessions.User_Name.ToString()].ToString(), Session[enumSessions.User_Email.ToString()].ToString(), Session[enumSessions.User_Id.ToString()].ToString()).SingleOrDefault();
if (OrderInfo != null)
{
lblTotalPrice.Text = "£" + OrderInfo.Amount.ToString();
lblTotalQty.Text = OrderInfo.Quantity.ToString();
lblDtlsOrderTotal.Text = OrderInfo.Amount.ToString();
lblDtlsTotalToPay.Text = OrderInfo.Amount.ToString();
}
if (Session[enumSessions.User_Role.ToString()] != null && Session[enumSessions.User_Role.ToString()].ToString() == enumRoles.ARC_Admin.ToString())
{
lblTotalPrice.Text = String.Empty; //£0.00
lblDtlsOrderTotal.Text = String.Empty; //0.00
lblDtlsTotalToPay.Text = String.Empty; //0.00
}
db.Dispose();
}
}
catch (Exception objException)
{
CSLOrderingARCBAL.LinqToSqlDataContext db;
db = new CSLOrderingARCBAL.LinqToSqlDataContext();
db.USP_SaveErrorDetails(Request.Url.ToString(), "ProductsRepeater_ItemBound", Convert.ToString(objException.Message), Convert.ToString(objException.InnerException), Convert.ToString(objException.StackTrace), "", HttpContext.Current.Request.UserHostAddress, false, Convert.ToString(HttpContext.Current.Session[enumSessions.User_Id.ToString()]));
}
}
private void AutoLoginUser()
{
try
{
string username = Request.QueryString["User"];
string CatId = Request.QueryString["CatId"];
string userEmail = "";
if (!string.IsNullOrEmpty(username))
{
if (Roles.IsUserInRole(username, enumRoles.ARCWebSite_Admin.ToString()))
{
Session[enumSessions.User_Role.ToString()] = enumRoles.ARCWebSite_Admin.ToString();
if (Roles.IsUserInRole(username, enumRoles.ARCWebSite_SuperAdmin.ToString()))
{
Session[enumSessions.IsUserSuperAdmin.ToString()] = enumRoles.ARCWebSite_SuperAdmin.ToString();
}
}
else
{
if (Roles.IsUserInRole(username, enumRoles.ARC_Manager.ToString()))
{
Session[enumSessions.User_Role.ToString()] = enumRoles.ARC_Manager.ToString();
}
else if (Roles.IsUserInRole(username, enumRoles.ARC_Admin.ToString()))
{
Session[enumSessions.User_Role.ToString()] = enumRoles.ARC_Admin.ToString();
}
else
{
lblMsg.Text = "Login unsuccessful. Please check your username and password";
System.Web.Security.FormsAuthentication.SignOut();
return;
}
}
MembershipUser userInfo = Membership.GetUser(username);
Guid UserID = new Guid(userInfo.ProviderUserKey.ToString());
userEmail = userInfo.Email;
Session[enumSessions.User_Id.ToString()] = UserID;
Session[enumSessions.User_Name.ToString()] = username;
Session[enumSessions.User_Email.ToString()] = userEmail;
// if (Session[enumSessions.User_Role.ToString()] == enumRoles.ARCWebSite_Admin.ToString())
// Response.Redirect("ADMIN/AdminDefault.aspx");
ARC arc = ArcBAL.GetArcInfoByUserId(new Guid(Session[enumSessions.User_Id.ToString()].ToString()));
if (arc == null)
{
lblMsg.Text = "Login denied! Your account is not related to any ARC. Please contact CSL DualCom.";
System.Web.Security.FormsAuthentication.SignOut();
return;
}
Session[enumSessions.ARC_Id.ToString()] = arc.ARCId;
Session[enumSessions.IsARC_AllowReturns.ToString()] = arc.AllowReturns;
LinqToSqlDataContext db = new LinqToSqlDataContext();
var OrderInfo = db.USP_CreateOrderForUser(arc.ARCId, Session[enumSessions.User_Name.ToString()].ToString(), Session[enumSessions.User_Name.ToString()].ToString(), Session[enumSessions.User_Email.ToString()].ToString(), Session[enumSessions.User_Id.ToString()].ToString()).SingleOrDefault();
if (OrderInfo != null)
{
Session[enumSessions.OrderId.ToString()] = OrderInfo.OrderId;
Session[enumSessions.OrderNumber.ToString()] = OrderInfo.OrderNo.ToString();
Session[enumSessions.HasUserAcceptedDuplicates.ToString()] = OrderInfo.HasUserAcceptedDuplicates;
if (OrderInfo.InstallerId != "0")
{
Session[enumSessions.InstallerCompanyID.ToString()] = OrderInfo.InstallerId;
Session[enumSessions.SelectedInstaller.ToString()] = OrderInfo.SelectedInstaller;
}
}
db.Dispose();
FormsAuthentication.SetAuthCookie(username, false);
//if (Session[enumSessions.IsARC_AllowReturns.ToString()] != null && Convert.ToBoolean(Session[enumSessions.IsARC_AllowReturns.ToString()]))
// Response.Redirect("UploadOrder.aspx");
//else
if (string.IsNullOrEmpty(CatId) || CatId.Trim() == "")
{
Response.Redirect("Categories.aspx");
}
else
{
Response.Redirect("ProductList.aspx?CategoryId=" + CatId);
}
}
}
catch (System.Threading.ThreadAbortException ex)
{
//
}
catch (Exception objException)
{
CSLOrderingARCBAL.LinqToSqlDataContext db;
db = new CSLOrderingARCBAL.LinqToSqlDataContext();
db.USP_SaveErrorDetails(Request.Url.ToString(), "AutoLoginUser", Convert.ToString(objException.Message), Convert.ToString(objException.InnerException), Convert.ToString(objException.StackTrace), "", HttpContext.Current.Request.UserHostAddress, false, Convert.ToString(HttpContext.Current.Session[enumSessions.User_Id.ToString()]));
}
}
protected void MyLogin_Authenticate(object sender, AuthenticateEventArgs e)
{
try
{
lblMsg.Text = "";
string username = cslLogin.UserName;
string userEmail = "";
if (AuthenticateUser(username, cslLogin.Password))
{
if (Roles.IsUserInRole(username, enumRoles.ARCWebSite_Admin.ToString()))
{
Session[enumSessions.User_Role.ToString()] = enumRoles.ARCWebSite_Admin.ToString();
if (Roles.IsUserInRole(username, enumRoles.ARCWebSite_SuperAdmin.ToString()))
{
Session[enumSessions.IsUserSuperAdmin.ToString()] = enumRoles.ARCWebSite_SuperAdmin.ToString();
}
}
else
{
if (Roles.IsUserInRole(username, enumRoles.ARC_Manager.ToString()))
{
Session[enumSessions.User_Role.ToString()] = enumRoles.ARC_Manager.ToString();
}
else if (Roles.IsUserInRole(username, enumRoles.ARC_Admin.ToString()))
{
Session[enumSessions.User_Role.ToString()] = enumRoles.ARC_Admin.ToString();
}
else
{
e.Authenticated = false;
lblMsg.Text = "Login unsuccessful. Please check your username and password";
System.Web.Security.FormsAuthentication.SignOut();
// e.Cancel = true;
return;
}
}
MembershipUser userInfo = Membership.GetUser(username);
Guid UserID = new Guid(userInfo.ProviderUserKey.ToString());
userEmail = userInfo.Email;
Session[enumSessions.User_Id.ToString()] = UserID;
Session[enumSessions.User_Name.ToString()] = username;
Session[enumSessions.User_Email.ToString()] = userEmail;
ARC arc = ArcBAL.GetArcInfoByUserId(new Guid(Session[enumSessions.User_Id.ToString()].ToString()));
if (arc == null)
{
e.Authenticated = false;
lblMsg.Text = "Login denied! Your account is not related to any ARC. Please contact CSL DualCom.";
System.Web.Security.FormsAuthentication.SignOut();
// e.Cancel = true;
Session[enumSessions.User_Id.ToString()] = null;
return;
}
Session[enumSessions.ARC_Id.ToString()] = arc.ARCId;
Session[enumSessions.IsARC_AllowReturns.ToString()] = arc.AllowReturns;
LinqToSqlDataContext db = new LinqToSqlDataContext();
var OrderInfo = db.USP_CreateOrderForUser(arc.ARCId, Session[enumSessions.User_Name.ToString()].ToString(), Session[enumSessions.User_Name.ToString()].ToString(), Session[enumSessions.User_Email.ToString()].ToString(), Session[enumSessions.User_Id.ToString()].ToString()).SingleOrDefault();
if (OrderInfo != null)
{
Session[enumSessions.OrderId.ToString()] = OrderInfo.OrderId;
Session[enumSessions.OrderNumber.ToString()] = OrderInfo.OrderNo.ToString();
Session[enumSessions.HasUserAcceptedDuplicates.ToString()] = OrderInfo.HasUserAcceptedDuplicates;
if (OrderInfo.InstallerId != "0")
{
Session[enumSessions.InstallerCompanyID.ToString()] = OrderInfo.InstallerId;
Session[enumSessions.SelectedInstaller.ToString()] = OrderInfo.SelectedInstaller;
}
}
e.Authenticated = true;
db.Dispose();
}
else
{
e.Authenticated = false;
lblMsg.Text = "Login unsuccessful ! unable to find your details";
System.Web.Security.FormsAuthentication.SignOut();
// e.Cancel = true;
return;
}
}
catch (System.Threading.ThreadAbortException ex)
{
//
}
catch (Exception objException)
{
CSLOrderingARCBAL.LinqToSqlDataContext db;
db = new CSLOrderingARCBAL.LinqToSqlDataContext();
db.USP_SaveErrorDetails(Request.Url.ToString(), "cslLogin_LoggingIn", Convert.ToString(objException.Message), Convert.ToString(objException.InnerException), Convert.ToString(objException.StackTrace), "", HttpContext.Current.Request.UserHostAddress, false, Convert.ToString(HttpContext.Current.Session[enumSessions.User_Id.ToString()]));
}
}
