protected void LoadCategories()
{
ARC arc = ArcBAL.GetArcInfoByUserId(new Guid(Session[enumSessions.User_Id.ToString()].ToString()));
if (arc == null)
{
string script = "alertify.alert('" + ltrUser.Text + "');";
ScriptManager.RegisterStartupScript(this.Page, this.GetType(), "alert", script, true);
return;
}
List <CategoryDTO> categories = CategoryBAL.GetCategoriesByArcId(arc.ARCId);
dtCategories.DataSource = categories;
dtCategories.DataBind();
}
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 = "";
}
}
public void btnAdd_Click(object sender, EventArgs e)
{
DropDownList ddlinstaller = (DropDownList)Installers.FindControl("ddlInstallers");
if (esn_sim.Text.Length == 0 && nua_data.Text.Length == 0 && chip.Text.Length == 0 && SelectedEMNo.Text.Length == 0)
{
lblValidation.Visible = true;
lblDropValid.Visible = false;
pnlConfirm.Visible = false;
}
else if ((Session[enumSessions.SelectedInstaller.ToString()] == null && enablePostCodeSearch == true) || (ddlinstaller.SelectedValue == "" && enablePostCodeSearch == false))
{
lblValidation.Visible = false;
lblDropValid.Visible = true;
pnlConfirm.Visible = false;
}
else
{
lblValidation.Visible = false;
lblDropValid.Visible = false;
if (Request.QueryString["dr"].ToString() == "d")
{
if (SelectedEMNo.Text.Length > 0 && SelectedEMNo.Text != " ") // ** Emizon
{
if (string.IsNullOrWhiteSpace(SelectedEMNo.Text))
{
string script = "alertify.alert('" + "Valid EMNo is required." + "');";
ScriptManager.RegisterStartupScript(this.Page, this.GetType(), "alert", script, true);
return;
}
if (IsInDisconnectionslist(SelectedEMNo.Text))
{
string script = "alertify.alert('" + "Unit on Disconnections list already" + "');";
ScriptManager.RegisterStartupScript(this.Page, this.GetType(), "alert", script, true);
return;
}
int RequestReference = EmizonService.AddtoEmizonRequestQueue(SelectedEMNo.Text, typeof(Emizon.APIModels.MSMQTypes.QueueReadytoCease).Name);
string emizonQueuePath = ConfigurationManager.AppSettings["EmizonQueue"].ToString();
EmizonOrderController.AddtoMSMQ(emizonQueuePath, new Emizon.APIModels.MSMQTypes.QueueReadytoCease()
{
em_no = SelectedEMNo.Text.Trim(),
arc_no = ArcBAL.GetEmizonArcNobyARCID(Session[enumSessions.ARC_Id.ToString()].ToString()),
CSLRefNo = RequestReference.ToString()
});
string ResponseMessage = string.Empty;
string ResponseVal = EmizonService.WaitandGetResponse(RequestReference, ref ResponseMessage);
if (string.IsNullOrEmpty(ResponseVal))
{
string script = "alertify.alert('" + "Unable to verify if unit can be disconnected, please try again later" + "');";
ScriptManager.RegisterStartupScript(this.Page, this.GetType(), "alert", script, true);
return;
}
else if (ResponseVal != "0")
{
string script = "alertify.alert('" + "Unit not ready for disconnection due to : " + ResponseMessage + "');";
ScriptManager.RegisterStartupScript(this.Page, this.GetType(), "alert", script, true);
return;
}
else
{
ProceedwithRequest(true);
return;
}
}
else // ** CSL Unit
{
if (!string.IsNullOrWhiteSpace(esn_sim.Text))
{
if (HighilghtRecentPolling(esn_sim.Text))
{
ProceedwithRequest();
string script = "alertify.alert('" + "Please note this Unit has been active in the last 7 days." + "');";
ScriptManager.RegisterStartupScript(this.Page, this.GetType(), "alert", script, true);
return;
}
}
}
}
ProceedwithRequest();
}
}
public void ProceedwithRequest(bool isEmizonDevice = false)
{
db = new LinqToSqlDataContext();
DropDownList ddlinstaller = (DropDownList)Installers.FindControl("ddlInstallers");
if (rpList.Items.Count > 0)
{
foreach (RepeaterItem ri in rpList.Items)
{
HtmlTableCell tdsim = (HtmlTableCell)ri.FindControl("tdSim");
string sim = tdsim.InnerText.Trim();
if (esn_sim.Text == sim)
{
//lblAddItem.Visible=true;
return;
}
}
}
string dr = "";
if (Request.QueryString["dr"].ToString() == "d")
{
dr = "Disconnect";
}
else
{
dr = "Reconnect";
}
DR drdata = new DR();
drdata.ArcId = Session[enumSessions.ARC_Id.ToString()].ToString();
drdata.Chipno = chip.Text.ToString();
drdata.Datano = nua_data.Text.ToString();
drdata.date = DateTime.Now.ToString();
if (enablePostCodeSearch == true)
{
drdata.Installer = Session[enumSessions.InstallerCompanyID.ToString()].ToString().ToLower();
}
else
{
drdata.Installer = ddlinstaller.SelectedValue.ToString().ToLower();
}
if (Request["dr"].ToString() == "r")
{
drdata.Reason = "";
}
else
{
drdata.Reason = ddlReason.SelectedValue.ToString();
}
drdata.Req_Type = dr;
drdata.Simno = esn_sim.Text.ToString();
drdata.Emailed = false;
drdata.UserId = Session[enumSessions.User_Id.ToString()].ToString();
drdata.EMNo = SelectedEMNo.Text.Trim();
drdata.ISEmizonUnit = isEmizonDevice;
drdata.UserName = Session[enumSessions.User_Name.ToString()].ToString();
drdata.UserEmail = Session[enumSessions.User_Email.ToString()].ToString();
drdata.TobeUpdatedOnBOS = false;
drdata.UpdatedOnBOS = false;
drdata.NoofAttempts = 0;
drdata.FreeTextEntry = (esn_sim.Enabled) ? true : false;
if (isEmizonDevice)
{
drdata.EM_Platform = ArcBAL.GetEmizonPlatformbyARCID(Session[enumSessions.ARC_Id.ToString()].ToString());
}
db.DRs.InsertOnSubmit(drdata);
db.SubmitChanges();
ClearSelection();
PopulateList();
}
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()]));
}
}
public static void SendEmailWithPrice(string OrderNo, string mailTO, SendEmailDTO sendEmailDTO,
string mailFrom, string mailCC, bool isEmailFromViewOrders, bool?hasEmizonProducts, int orderID)
{
try
{
String ProductsList = "";
bool instadd_differs = false;
string subjectsuffix = string.Empty;
string templatePath = "Template";
SendEmailMessage sendEmail = new SendEmailMessage();
EmailMessage cslEmailMessage = new EmailMessage();
string emizonQueuePath = ConfigurationManager.AppSettings["EmizonQueue"].ToString();//could have used AppSettings but no point as another one is using config
string mailSubject = "Order Confirmation - Order Ref: " + OrderNo;
if (isEmailFromViewOrders)
{
if (mailTO.EndsWith("@csldual.com"))
{
subjectsuffix = "; Email Resent";
}
mailSubject = mailSubject + subjectsuffix;
templatePath = "../Template";
}
String mailHtml = ReadTemplates.ReadMailTemplate(System.Web.HttpContext.Current.Server.MapPath(templatePath), "EmailTemplate.html");
StringBuilder objBuilder = new StringBuilder();
objBuilder.Append(mailHtml);
objBuilder.Replace("{OrderNo}", OrderNo);
objBuilder.Replace("{OrderDate}", string.IsNullOrEmpty(sendEmailDTO.orderDate) ? "." : sendEmailDTO.orderDate);
objBuilder.Replace("{OrderRef}", string.IsNullOrEmpty(sendEmailDTO.ARCOrderRefNo) ? "." : sendEmailDTO.ARCOrderRefNo);
ARC arc = ArcBAL.GetArcInfoByUserId(new Guid(sendEmailDTO.userID));
string arcAdd = "";
if (arc != null)
{
arcAdd = arc.CompanyName == null ? "" : arc.CompanyName + ", ";
arcAdd += arc.AddressOne + ", <br /> ";
arcAdd += string.IsNullOrEmpty(arc.AddressTwo) ? "" : arc.AddressTwo + ", ";
arcAdd += string.IsNullOrEmpty(arc.Town) ? "" : arc.Town + ",<br /> ";
arcAdd += string.IsNullOrEmpty(arc.County) ? "" : arc.County + ", ";
arcAdd += string.IsNullOrEmpty(arc.PostCode) ? "" : arc.PostCode + " <br />";
objBuilder.Replace("{Fax}", string.IsNullOrEmpty(arc.Fax) ? "." : arc.Fax);
objBuilder.Replace("{Tel}", string.IsNullOrEmpty(arc.Telephone) ? "." : arc.Telephone);
objBuilder.Replace("{ARC}", arcAdd);
}
objBuilder.Replace("{Username}", sendEmailDTO.userName);
objBuilder.Replace("{UserEmail}", sendEmailDTO.userEmail);
// OrderDetails
LinqToSqlDataContext db = new LinqToSqlDataContext();
var products = db.USP_GetBasketProducts(Convert.ToInt32(sendEmailDTO.orderID)).ToList();
if (products != null && products.Count > 0)
{
string chipNos = "";
int countOption = 1;
foreach (var prod in products)
{
int rowCount = db.USP_GetBasketProductsOnCheckOut(Convert.ToInt32(sendEmailDTO.orderID)).Where(i => i.ProductCode == prod.ProductCode.Trim()).Count();
ProductsList += "<tr><td style=\"background: #FFF7F7\">" + prod.ProductCode + "</td><td>" + prod.ProductName + "</td> <td style=\"background: #FFF7F7\">" + prod.ProductQty + "</td><td>£" + prod.Price;
if (prod.ProductType == "Product")
{
chipNos = "";
var ChipNumbers = db.USP_GetBasketGPRSChipNumbersByProductId(Convert.ToInt32(sendEmailDTO.orderID), prod.ProductId, prod.CategoryId).ToList();
if (ChipNumbers != null)
{
foreach (var chipno in ChipNumbers)
{
chipNos += string.IsNullOrEmpty(chipno.GPRSNo) ? "" : chipno.GPRSNo + "-";
chipNos += string.IsNullOrEmpty(chipno.PSTNNo) ? "" : chipno.PSTNNo + "-";
chipNos += string.IsNullOrEmpty(chipno.GSMNo) ? "" : chipno.GSMNo + "-"; //added GSM NO(PanelID) in email
chipNos += string.IsNullOrEmpty(chipno.OptionName) ? "" : chipno.OptionName;
chipNos += ",";
if (chipno.PSTNNo == "" &&
chipno.OptionName == "" &&
chipno.GSMNo == "" &&
chipNos.Length > 0
)//added GSM NO(PanelID) in email
{
chipNos = chipNos.Remove(chipNos.Length - 1, 1);
}
}
if (chipNos != "")
{
chipNos = chipNos.Substring(0, chipNos.Length - 1);
ProductsList += "</td> <td style=\"background: #FFF7F7\">" + chipNos + "</td> </td></tr>";
}
else
{
ProductsList += "</td> <td style=\"background: #FFF7F7\">Chip Numbers : Not Provided</td></tr>";
}
}
if (rowCount == 1)
{
var dependentproducts = db.USP_GetBasketDependentProductsByProductId(Convert.ToInt32(sendEmailDTO.orderID), prod.ProductId, prod.CategoryId).ToList();
if (dependentproducts != null && dependentproducts.Count > 0)
{
foreach (var dp in dependentproducts)
{
ProductsList += "<tr><td>" + dp.ProductCode + "</td><td>" + dp.ProductName + "</td><td>" + dp.ProductQty + "</td><td>£" + dp.Price + "</tr>";
}
}
countOption = 0;
}
else if (rowCount == countOption)
{
var dependentproducts = db.USP_GetBasketDependentProductsByProductId(Convert.ToInt32(sendEmailDTO.orderID), prod.ProductId, prod.CategoryId).ToList();
if (dependentproducts != null && dependentproducts.Count > 0)
{
foreach (var dp in dependentproducts)
{
ProductsList += "<tr><td>" + dp.ProductCode + "</td><td>" + dp.ProductName + "</td><td>" + dp.ProductQty + "</td><td>£" + dp.Price + "</tr>";
}
}
}
}
countOption++;
}
}
OrderDTO objorder = CSLOrderingARCBAL.BAL.OrdersBAL.GetOrderDetail(Convert.ToInt32(sendEmailDTO.orderID));
//objBuilder.Replace("{OrderTotal}", Convert.ToDecimal(lblDtlsOrderTotal.Text).ToString("c"));
objBuilder.Replace("{OrderTotal}", "£" + Convert.ToDecimal(objorder.OrderTotal));
//objBuilder.Replace("{DeliveryTotal}", Convert.ToDecimal(lblDtlsDeliveryTotal.Text).ToString("c"));
objBuilder.Replace("{DeliveryTotal}", "£" + Convert.ToDecimal(objorder.DeliveryCost));
//objBuilder.Replace("{VAT}", Convert.ToDecimal(lblDtlsVAT.Text).ToString("c"));
objBuilder.Replace("{VAT}", "£" + Convert.ToDecimal(objorder.VATAmount));
//objBuilder.Replace("{TotalToPay}", Convert.ToDecimal(lblDtlsTotalToPay.Text).ToString("c"));
objBuilder.Replace("{TotalToPay}", "£" + Convert.ToDecimal(objorder.TotalAmountToPay));
objBuilder.Replace("{DeliveryTypeName}", string.IsNullOrEmpty(sendEmailDTO.DdeliveryType) ? "" : sendEmailDTO.DdeliveryType);
objBuilder.Replace("{DeliveryTypePrice}", "£" + sendEmailDTO.deliveryCost);
objBuilder.Replace("{Installer}", InstallerBAL.GetAddressHTML2LineForEmail(new Guid(sendEmailDTO.installerID)));
if (objorder.InstallationAddressId > 0)
{
instadd_differs = true;
}
else
{
instadd_differs = false;
}
if (instadd_differs)// || sendEmailDTO.InstallationAddId != 0)
{
//string InsAdd = InstallerBAL.GetAddressHTML2LineForEmail(Convert.ToInt32(Session[enumSessions.PreviousOrderId.ToString()].ToString()));
string InsAdd = objorder.InstallationAddressId.HasValue ? InstallerBAL.GetAddressHTML2LineForEmail(objorder.InstallationAddressId.Value) : "Not Available";
objBuilder.Replace("{InstallerAddress}", "<td><div style=\"width: 100%; margin: 0; padding: 0;\"><table border=\"0\" cellpadding=\"5\" cellspacing=\"0\" width=\"100%\"><tr><td style=\"text-align: left\"> <font color=\"#888\" size=\"2\" face=\"Arial\">" + InsAdd + " </font></td></tr></table></div></td>");
objBuilder.Replace("{HeadingInstallerAdd}", "<td><h3 style=\"font-size:11px; text-align: center; margin: 0; padding: 5px auto;\">Installation Address</h3></td>");
}
else
{
objBuilder.Replace("{InstallerAddress}", "");
objBuilder.Replace("{HeadingInstallerAdd}", "");
}
objBuilder.Replace("{DeliveredTo}", OrdersBAL.GetDeliveryAddressHTML2Line(Convert.ToInt32(sendEmailDTO.orderID)));
objBuilder.Replace("{SpecialInstructions}", sendEmailDTO.specialInstructions);
if (isEmailFromViewOrders)
{
objBuilder.Append("Email Resent");
}
var distinctProduct = products.Select(i => i.ProductCode).Distinct();
foreach (var pro in distinctProduct)
{
products = db.USP_GetBasketProducts(Convert.ToInt32(sendEmailDTO.orderID)).Where(p => p.ProductCode == pro).Take(1).ToList();
foreach (var prod in products)
{
if (prod.IsCSDUser == true)
{
ProductsList += "<tr><td>" + prod.ProductCode + "</td><td>" + prod.Message + "</td></tr>";
}
}
}
objBuilder.Replace("{ProductList}", ProductsList);
if (mailTO != "" && mailTO.Trim() != "")
{
string[] mailFromList = mailFrom.Split(',');
string[] mailCCList = mailCC.Split(',');
string emailCC = string.Empty;
foreach (string email in mailCCList)
{
emailCC += email + ",";
}
if (!string.IsNullOrEmpty(emailCC))
{
emailCC = emailCC.TrimEnd(',');
}
//PUSH TO EMIZON QUEUE
if (hasEmizonProducts.HasValue && hasEmizonProducts.Value)
{
EmizonOrderController.AddAPIRequestToQueue(emizonQueuePath, new Emizon.APIModels.MSMQTypes.QueueOrderMessage()
{
From = mailFrom,
To = mailTO,
CC = mailCC,
BCC = mailCC,
Subject = mailSubject,
OrderHTMLBody = objBuilder.ToString(),
orderID = orderID
});
}
else
{
//Add below code to send the email message via msmq not smtp -Priya 15/06/2017
//Remove Emizon placeholder
objBuilder.Replace("{EmizonData}", "");
cslEmailMessage.From = mailFrom;
cslEmailMessage.To = mailTO;
cslEmailMessage.CC = emailCC;
cslEmailMessage.BCC = emailCC;
cslEmailMessage.Subject = mailSubject;
cslEmailMessage.Message = objBuilder.ToString();
sendEmail.SendEmailMessageToQueue(ConfigurationManager.AppSettings["QueueName"].ToString(), cslEmailMessage);
}
//End Code sending email to msmq.
}
ApplicationDTO appSettings = new AppSettings().GetAppValues();
List <string> lstProductCodes = new List <string>();
lstProductCodes = appSettings.ConnectionOnlyCodes.Split(',').ToList();
bool connectionProductCodeExist = false;
foreach (var x in distinctProduct)
{
if (lstProductCodes.Exists(e => e.EndsWith(x)))
{
connectionProductCodeExist = true;
}
}
StringBuilder strURL = new StringBuilder();
if (connectionProductCodeExist)
{
#region buildURLs
List <DCCCompany> lstDCCCompany = db.DCCCompanies.ToList();
foreach (DCCCompany company in lstDCCCompany)
{
var tableCodes = company.Productcode.Split(',').ToList();
foreach (string s in tableCodes)
{
if (distinctProduct.Contains(s)) //only create a link if the product exist in the basket items.
{
strURL.Append(" please <a href='" + company.InstructionsUrl + "'>Click here for " + company.company_name + "</a> or ");
break; // once we add
}
}
}
#endregion
string mailSubjectConnectionOnly = "ARC Connection Only - Order Confirmation - Order Ref: " + OrderNo;
if (isEmailFromViewOrders)
{
if (mailTO.EndsWith("@csldual.com"))
{
subjectsuffix = "; Email Resent";
}
mailSubjectConnectionOnly = mailSubjectConnectionOnly + subjectsuffix;
}
String mailHtmlConnectionOnly = ReadTemplates.ReadMailTemplate(System.Web.HttpContext.Current.Server.MapPath(templatePath), "EmailTemplate_ConnectionOrders.html");
// String mailHtmlConnectionOnly = ReadTemplates.ReadMailTemplate(System.Web.HttpContext.Current.Server.MapPath(templatePath), "EmailTemplate_v2_ConnectionOrders.html");
StringBuilder objBuilderConnectionOnly = new StringBuilder();
objBuilderConnectionOnly.Append(mailHtmlConnectionOnly);
objBuilderConnectionOnly.Replace("{InstallationURL}", strURL.ToString().TrimEnd(' ', 'o', 'r') + '.');
objBuilderConnectionOnly.Replace("{OrderNo}", OrderNo);
objBuilderConnectionOnly.Replace("{OrderDate}", sendEmailDTO.orderDate);
objBuilderConnectionOnly.Replace("{OrderRef}", string.IsNullOrEmpty(sendEmailDTO.ARCOrderRefNo) ? "." : sendEmailDTO.ARCOrderRefNo);
objBuilderConnectionOnly.Replace("{OrderTotal}", "£" + objorder.OrderTotal);
objBuilderConnectionOnly.Replace("{DeliveryTotal}", "£" + objorder.DeliveryCost);
objBuilderConnectionOnly.Replace("{VAT}", "£" + objorder.VATAmount);
objBuilderConnectionOnly.Replace("{TotalToPay}", "£" + objorder.TotalAmountToPay);
objBuilderConnectionOnly.Replace("{DeliveryTypeName}", sendEmailDTO.DdeliveryType.ToString().TrimEnd(' '));
// objBuilderConnectionOnly.Replace("{DeliveryTypePrice}", "£" + sendEmailDTO.deliveryCost);
objBuilderConnectionOnly.Replace("{Installer}", InstallerBAL.GetAddressHTML2LineForEmail(new Guid(sendEmailDTO.installerID)));
if (arc != null)
{
objBuilderConnectionOnly.Replace("{Fax}", string.IsNullOrEmpty(arc.Fax) ? "." : arc.Fax);
objBuilderConnectionOnly.Replace("{Tel}", string.IsNullOrEmpty(arc.Telephone) ? "." : arc.Telephone);
objBuilderConnectionOnly.Replace("{ARC}", arcAdd);
}
objBuilderConnectionOnly.Replace("{Username}", sendEmailDTO.userName);
objBuilderConnectionOnly.Replace("{UserEmail}", sendEmailDTO.userEmail);
//comment below line if new RAc connection only template is approved
if (instadd_differs)
{
string InsAddConnection = objorder.InstallationAddressId.HasValue ? InstallerBAL.GetAddressHTML2LineForEmail(objorder.InstallationAddressId.Value) : "Not Available";
//string InsAddConnection= InstallerBAL.GetInstallationAddressHTML2LineForEmail(Convert.ToInt32(Session[enumSessions.OrderId.ToString()].ToString()));
objBuilderConnectionOnly.Replace("{InstallerAddress}", "<td><div style=\"width: 100%; margin: 0; padding: 0;\"><table border=\"0\" cellpadding=\"5\" cellspacing=\"0\" width=\"100%\"><tr><td style=\"text-align: left\"> <font color=\"#888\" size=\"2\" face=\"Arial\">" + InsAddConnection + " </font></td></tr></table></div></td>");
objBuilderConnectionOnly.Replace("{HeadingInstallerAdd}", "<td><h3 style=\"font-size:11px; text-align: center; margin: 0; padding: 5px auto;\">Installation Address</h3></td>");
}
else
{
//objBuilderConnectionOnly.Replace("{InstallerAddress}", "");
// objBuilderConnectionOnly.Replace("{HeadingInstallerAdd}", "");
objBuilderConnectionOnly.Replace("{InstallerAddress}", "");
objBuilderConnectionOnly.Replace("{HeadingInstallerAdd}", "");
}
//
objBuilderConnectionOnly.Replace("{DeliveredTo}", OrdersBAL.GetDeliveryAddressHTML2Line(Convert.ToInt32(sendEmailDTO.orderID)));
objBuilderConnectionOnly.Replace("{SpecialInstructions}", string.IsNullOrEmpty(sendEmailDTO.specialInstructions.Trim()) ? "." : sendEmailDTO.specialInstructions.Trim());
ProductsList = Regex.Replace(ProductsList, @"(?i)<(table|tr|td)(?:\s+(?:""[^""]*""|'[^']*'|[^""'>])*)?>", "<$1>");
objBuilderConnectionOnly.Replace("{ProductList}", ProductsList);
LinqToSqlDataContext dbe = new LinqToSqlDataContext();
var connInstallerEmail = (from o in dbe.Orders
join i in dbe.Installers on o.InstallerUnqCode equals i.UniqueCode.ToString()
join ia in dbe.InstallerAddresses on i.AddressID equals ia.AddressID
where o.OrderNo == OrderNo
select ia.Email).Single();
if (string.IsNullOrEmpty(connInstallerEmail))
{
connInstallerEmail = ConfigurationManager.AppSettings["TeleSalesEmail"].ToString();
}
cslEmailMessage.From = mailFrom;
cslEmailMessage.To = connInstallerEmail;
cslEmailMessage.CC = mailCC;
cslEmailMessage.BCC = mailCC;
cslEmailMessage.Subject = mailSubjectConnectionOnly;
cslEmailMessage.Message = Convert.ToString(objBuilderConnectionOnly.ToString());
sendEmail.SendEmailMessageToQueue(ConfigurationManager.AppSettings["QueueName"].ToString(), cslEmailMessage);
}
db.Dispose();
HttpContext.Current.ApplicationInstance.CompleteRequest();
}
catch (Exception objException)
{
CSLOrderingARCBAL.LinqToSqlDataContext db;
db = new CSLOrderingARCBAL.LinqToSqlDataContext();
db.USP_SaveErrorDetails(System.Web.HttpContext.Current.Request.Url.ToString(), "SendEmailWithPrice",
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()]));
}
}
public void ProceedwithRequest(bool isEmizonDevice = false, bool NeedEngineerVisit = false)
{
db = new LinqToSqlDataContext();
DropDownList ddlinstaller = (DropDownList)Installers.FindControl("ddlInstallers");
if (rpList.Items.Count > 0)
{
foreach (RepeaterItem ri in rpList.Items)
{
HtmlTableCell tdsim = (HtmlTableCell)ri.FindControl("tdSim");
string sim = tdsim.InnerText.Trim();
if (esn_sim.Text == sim)
{
return;
}
}
}
UpDowngrade uddata = new UpDowngrade();
string dr = "";
if (Request.QueryString["dr"].ToString() == "d")
{
uddata.Req_Type = "Downgrade";
uddata.Reason = ddlReason.SelectedValue.ToString();
uddata.ItemTo = ddlTo.SelectedItem.ToString();
uddata.ItemToDescription = ddlTo.SelectedItem.ToString();
}
else if (Request.QueryString["dr"].ToString() == "u")
{
uddata.Req_Type = "Upgrade";
uddata.Reason = "";
uddata.ItemTo = ddlTo.SelectedItem.ToString();
uddata.ItemToDescription = ddlTo.SelectedItem.ToString();
}
else
{
uddata.Req_Type = "Regrade";
uddata.Reason = "";
uddata.ItemTo = ddlTo.SelectedValue.ToString();
uddata.ItemToDescription = ddlTo.SelectedItem.ToString();
}
uddata.ArcId = Session[enumSessions.ARC_Id.ToString()].ToString();
uddata.Chipno = chip.Text.ToString();
uddata.Datano = nua_data.Text.ToString();
uddata.date = DateTime.Now.ToString();
if (enablePostCodeSearch == true)
{
uddata.Installer = Session[enumSessions.InstallerCompanyID.ToString()].ToString().ToLower();
}
else
{
uddata.Installer = ddlinstaller.SelectedValue.ToString().ToLower();
}
uddata.Simno = esn_sim.Text.ToString();
uddata.Emailed = false;
uddata.UserId = Session[enumSessions.User_Id.ToString()].ToString();
uddata.UserName = Session[enumSessions.User_Name.ToString()].ToString();
uddata.UserEmail = Session[enumSessions.User_Email.ToString()].ToString();
uddata.ItemFrom = ddlFrom.SelectedItem.ToString();
uddata.ARCRef = ARCRef.Text.ToString();
uddata.ISEmizonUnit = isEmizonDevice;
uddata.NeedsEngineer = NeedEngineerVisit;
if (isEmizonDevice)
{
uddata.RegradeDateTime = DateTime.Parse(txtRegradeDateTime.Text);
uddata.EMNo = SelectedEMNo.Text.Trim();
uddata.TobeUpdatedOnBOS = false;
uddata.UpdatedOnBOS = false;
uddata.NoofAttempts = 0;
uddata.EM_Platform = ArcBAL.GetEmizonPlatformbyARCID(Session[enumSessions.ARC_Id.ToString()].ToString());
}
uddata.FreeTextEntry = (esn_sim.Enabled) ? true : false;
db.UpDowngrades.InsertOnSubmit(uddata);
db.SubmitChanges();
ClearSelection();
ddlReason.SelectedIndex = 0;
ddlFrom.SelectedIndex = 0;
ddlTo.SelectedIndex = 0;
PopulateList();
}
public void btnAdd_Click(object sender, EventArgs e)
{
db = new LinqToSqlDataContext();
DropDownList ddlinstaller = (DropDownList)Installers.FindControl("ddlInstallers");
string selectedTo = (Convert.ToInt32(ddlTo.SelectedValue) / 100).ToString();
string selectedFrom = (Convert.ToInt32(ddlFrom.SelectedValue) / 100).ToString();
if (esn_sim.Text.Length == 0 && nua_data.Text.Length == 0 && chip.Text.Length == 0 && SelectedEMNo.Text.Length == 0)
{
lblValidation.Visible = true;
lblDropValid.Visible = false;
pnlConfirm.Visible = false;
lblUpValid.Visible = false;
lblDownValid.Visible = false;
lblFromToValid.Visible = false;
}
else if (Request["dr"].ToString() != "r" && (selectedTo == "0" || selectedFrom == "0"))
{
lblFromToValid.Visible = true;
lblValidation.Visible = false;
lblDropValid.Visible = false;
lblUpValid.Visible = false;
lblDownValid.Visible = false;
}
else if (Request["dr"].ToString() == "r" && ddlTo.SelectedValue == "0")
{
lblFromToValid.Visible = true;
lblValidation.Visible = false;
lblDropValid.Visible = false;
lblUpValid.Visible = false;
lblDownValid.Visible = false;
}
else if (Request["dr"].ToString() == "u" && Convert.ToInt32(selectedTo) < Convert.ToInt32(selectedFrom))
{
lblUpValid.Visible = true;
lblValidation.Visible = false;
lblDropValid.Visible = false;
pnlConfirm.Visible = false;
lblFromToValid.Visible = false;
}
else if (Request["dr"].ToString() == "d" && Convert.ToInt32(selectedTo) > Convert.ToInt32(selectedFrom))
{
lblDownValid.Visible = true;
lblValidation.Visible = false;
lblDropValid.Visible = false;
pnlConfirm.Visible = false;
lblFromToValid.Visible = false;
}
else if ((Session[enumSessions.SelectedInstaller.ToString()] == null && enablePostCodeSearch == true) || (ddlinstaller.SelectedValue == "" && enablePostCodeSearch == false))
{
lblUpValid.Visible = false;
lblValidation.Visible = false;
lblDropValid.Visible = true;
pnlConfirm.Visible = false;
lblFromToValid.Visible = false;
lblDownValid.Visible = false;
}
else
{
lblValidation.Visible = false;
lblDropValid.Visible = false;
lblUpValid.Visible = false;
lblDownValid.Visible = false;
lblFromToValid.Visible = false;
if (Request.QueryString["dr"].ToString() == "r")
{
if (string.IsNullOrWhiteSpace(SelectedEMNo.Text))
{
string script = "alertify.alert('" + "Valid EMNo is required." + "');";
ScriptManager.RegisterStartupScript(this.Page, this.GetType(), "alert", script, true);
return;
}
DateTime RegradeDateTime;
if (DateTime.TryParse(txtRegradeDateTime.Text, out RegradeDateTime) == false)
{
string script = "alertify.alert('" + "Regrade Time should be a valid future date and time " + "');";
ScriptManager.RegisterStartupScript(this.Page, this.GetType(), "alert", script, true);
return;
}
if (RegradeDateTime <= DateTime.Now.AddMinutes(-5))
{
string script = "alertify.alert('" + "Regrade Time should be a valid future date and time " + "');";
ScriptManager.RegisterStartupScript(this.Page, this.GetType(), "alert", script, true);
return;
}
if (IsInRegradelist(SelectedEMNo.Text))
{
string script = "alertify.alert('" + "Unit on Regrade list already" + "');";
ScriptManager.RegisterStartupScript(this.Page, this.GetType(), "alert", script, true);
return;
}
int RequestReference = EmizonService.AddtoEmizonRequestQueue(SelectedEMNo.Text, typeof(Emizon.APIModels.MSMQTypes.QueueRegradecheckprep).Name);
EmizonOrderController.AddtoMSMQ(ConfigurationManager.AppSettings["EmizonQueue"].ToString(), new Emizon.APIModels.MSMQTypes.QueueRegradecheckprep()
{
em_no = SelectedEMNo.Text.Trim(),
CSLRefNo = RequestReference.ToString(),
new_product = ddlTo.SelectedValue,
arc_no = ArcBAL.GetEmizonArcNobyARCID(Session[enumSessions.ARC_Id.ToString()].ToString())
});
string ResponseMessage = string.Empty;
string ResponseVal = EmizonService.WaitandGetResponse(RequestReference, ref ResponseMessage);
if (string.IsNullOrEmpty(ResponseVal))
{
string script = "alertify.alert('" + "Unable to verify if unit can be regraded, please try again later" + "');";
ScriptManager.RegisterStartupScript(this.Page, this.GetType(), "alert", script, true);
return;
}
else if (ResponseVal == "11") //** Engineer Required
{
ProceedwithRequest(true, true);
string script = "alertify.alert('" + "An Engineer visit is required as operation cannot be completed remotely." + "');";
ScriptManager.RegisterStartupScript(this.Page, this.GetType(), "alert", script, true);
}
else if (ResponseVal == "0")
{
ProceedwithRequest(true, false);
return;
}
else
{
string script = "alertify.alert('" + "This unit is not available for a Regrade due to : " + ResponseMessage + "');";
ScriptManager.RegisterStartupScript(this.Page, this.GetType(), "alert", script, true);
return;
}
}
else
{
ProceedwithRequest();
}
}
}
