public static List <GradeDTO> GradeList()
{
List <GradeDTO> lstGrade = new List <GradeDTO>();
LinqToSqlDataContext db = new LinqToSqlDataContext();
var Grades = (from dg in db.Device_Grades
where
dg.Dev_Active == true
orderby dg.Dev_Grade ascending
select new { Grade = dg.Dev_Grade }).Distinct();
foreach (var grade in Grades)
{
GradeDTO gra = new GradeDTO();
gra.Grade = grade.Grade;
lstGrade.Add(gra);
}
db.Dispose();
return(lstGrade);
}
protected void LinkButtonupdate_click(object sender, System.EventArgs e)
{
CSLOrderingARCBAL.LinqToSqlDataContext db = null;
try
{
pnlGradeDetails.Visible = true;
pnlGradeList.Visible = false;
litAction.Text = "You choose to <b>EDIT GRADE MAPPING</b>";
LinkButton lbctg = sender as LinkButton;
if (lbctg != null)
{
GridViewRow gvr = (GridViewRow)lbctg.NamingContainer;
Label lbl1 = gvr.FindControl("lblProductGradeID") as Label;
ViewState["ProductGradeID"] = lbl1.Text;
}
db = new LinqToSqlDataContext();
var usrDtls = ProductBAL.GetProductGradeById(Convert.ToInt32(ViewState["ProductGradeID"].ToString()));
if (usrDtls != null)
{
txtProductCode.Text = usrDtls.ProductCode;
ddlGrade.SelectedValue = usrDtls.Grade.ToString();
}
db.Dispose();
}
catch (Exception objException)
{
db = new CSLOrderingARCBAL.LinqToSqlDataContext();
db.USP_SaveErrorDetails(Request.Url.ToString(), "LinkButtonupdate_click", 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()]));
db.Dispose();
}
}
void LoadBasketProducts()
{
LinqToSqlDataContext db = new LinqToSqlDataContext();
var BasketProducts = db.USP_GetBasketProductsOnCheckOut(Convert.ToInt32(Session[enumSessions.OrderId.ToString()].ToString())).ToList();
//check the product code and change it to pyronix/risco as per code
//foreach (var item in BasketProducts)
//{
// string name = (from dcc in db.DCCCompanies
// where dcc.Productcode.Contains(item.ProductCode)
// select dcc.company_name).SingleOrDefault();
// if (name != null)
// {
// item.ProductCode = item.ProductCode.Replace(item.ProductCode.Substring(item.ProductCode.Length - 3), "-" + name);
// }
//}
dlProducts.DataSource = BasketProducts;
dlProducts.DataBind();
Boolean?isExcludeTerms = db.ARCs.Where(a => a.ARCId == Convert.ToInt32(Session[enumSessions.ARC_Id.ToString()].ToString())).Select(a => a.ExcludeTerms).SingleOrDefault();
if (isExcludeTerms == false)
{
pnlAccepted.Visible = true;
btnConfirmOrder.OnClientClick = "javascript:return isvalid();";
}
db.Dispose();
}
public static List <BOSDeviceDTO> GetDeviceByEMNoandInstallID(string EMNo, string InstallID, List <string> ARC_Code)
{
LinqToSqlDataContext db = new LinqToSqlDataContext();
string[] ArrayEMNo = EMNo.Split(',');
string[] ArrayInstallID = InstallID.Split(',');
List <BOSDeviceDTO> deviceList = (from devs in db.BOS_Devices
join installer in db.Installers on devs.Dev_Inst_UnqCode equals installer.UniqueCode
join arcs in db.ARCs on devs.Dev_Arc_Primary equals arcs.ARC_Code
where
(
ARC_Code.Contains(devs.Dev_Arc_Primary) &&
devs.Dev_Active == true && devs.Dev_Delete_Flag == false &&
ArrayInstallID.Contains(devs.Dev_Account_Code) &&
ArrayEMNo.Contains(devs.EMNo)
)
select new BOSDeviceDTO
{
Dev_Account_Code = devs.Dev_Account_Code,
Dev_Connect_Number = devs.Dev_Connect_Number,
Dev_Code = devs.Dev_Code,
EMNo = devs.EMNo,
Dev_Type = devs.Dev_Type,
Dev_Arc_Primary = devs.Dev_Arc_Primary,
InstallerName = installer.CompanyName,
Dev_Inst_UnqCode = devs.Dev_Inst_UnqCode,
ARCName = arcs.CompanyName
}).ToList();
db.Dispose();
return(deviceList);
}
public static List <BOSDeviceDTO> GetDeviceByChipNo(string chipNo, List <string> ARC_Code)
{
LinqToSqlDataContext db = new LinqToSqlDataContext();
List <BOSDeviceDTO> deviceList = (from devs in db.BOS_Devices
join installer in db.Installers on devs.Dev_Inst_UnqCode equals installer.UniqueCode
join arcs in db.ARCs on devs.Dev_Arc_Primary equals arcs.ARC_Code
where
(
ARC_Code.Contains(devs.Dev_Arc_Primary) &&
devs.Dev_Active == true && devs.Dev_Delete_Flag == false &&
devs.EMNo == null && devs.Dev_Account_Code == chipNo
)
select new BOSDeviceDTO {
Dev_Account_Code = devs.Dev_Account_Code,
Dev_Connect_Number = devs.Dev_Connect_Number,
Dev_Code = devs.Dev_Code,
EMNo = devs.EMNo,
Dev_Type = devs.Dev_Type,
Dev_Arc_Primary = devs.Dev_Arc_Primary,
InstallerName = installer.CompanyName,
Dev_Inst_UnqCode = devs.Dev_Inst_UnqCode,
ARCName = arcs.CompanyName,
PostCode = devs.Dev_Post_Code
}).ToList();
db.Dispose();
return(deviceList);
}
public static Boolean UpdateProductGrade(ProductCode_Grade_Map productGrade)
{
LinqToSqlDataContext db = null;
try
{
db = new LinqToSqlDataContext();
ProductCode_Grade_Map objGrade = db.ProductCode_Grade_Maps.Single(i => i.ProductGradeID == productGrade.ProductGradeID);
objGrade.ProductCode = productGrade.ProductCode;
objGrade.Grade = productGrade.Grade;
objGrade.CreatedOn = productGrade.CreatedOn;
objGrade.CreatedBy = productGrade.CreatedBy;
objGrade.IsDeleted = productGrade.IsDeleted;
db.SubmitChanges();
db.Dispose();
return(true);
}
catch (Exception objException)
{
db = new CSLOrderingARCBAL.LinqToSqlDataContext();
db.USP_SaveErrorDetails("ProductBAL", "UpdateProductGrade", Convert.ToString(objException.Message), Convert.ToString(objException.InnerException), Convert.ToString(objException.StackTrace), "", null, false, null);
return(false);
}
}
private void LoadProductDetails()
{
LinqToSqlDataContext db = new LinqToSqlDataContext();
if (this.CategoryID == 0)
{
return;
}
// show arc description
arcDescription = (from a in db.ARCs
where a.ARCId == Convert.ToInt32(Session[enumSessions.ARC_Id.ToString()].ToString())
select a.Description
).SingleOrDefault();
var products = db.USP_GetProductsByCategoryAndArc(CategoryID, Convert.ToInt32(Session[enumSessions.ARC_Id.ToString()].ToString()));
var uniqueProducts = products.GroupBy(x => x.ProductCode).Select(g => g.First()); // product name should be same- so grouping the product by using product names and selecting only one.
dlProducts.DataSource = uniqueProducts;
// dlProducts.DataSource = db.USP_GetProductsByCategoryAndArc(CategoryID, Convert.ToInt32(Session[enumSessions.ARC_Id.ToString()].ToString()));
dlProducts.DataBind();
var categoryName = (from cats in db.Categories
where cats.CategoryId == CategoryID
select cats.CategoryName).Single <string>();
lblCategoryName.Text = categoryName.ToString();
db.Dispose();
}
public static List <CategoryDTO> GetCategories()
{
List <CategoryDTO> lstCategories = new List <CategoryDTO>();
try
{
LinqToSqlDataContext db = new LinqToSqlDataContext();
var cats = from categories in db.Categories
where
(
(categories.IsDeleted == false)
)
select new { Code = categories.CategoryCode, Title = categories.CategoryName, categories.CategoryId, categories.DefaultImage, categories.CategoryDesc };
foreach (var category in cats)
{
CategoryDTO cat = new CategoryDTO();
cat.CategoryCode = category.Code;
cat.CategoryID = category.CategoryId;
cat.CategoryName = category.Title;
cat.CategoryDefaultImage = category.DefaultImage;
cat.CategoryDesc = category.CategoryDesc;
lstCategories.Add(cat);
}
db.Dispose();
}
catch
{
}
return(lstCategories);
}
void LoadARCDeliveryaddresses()
{
LinqToSqlDataContext db = new LinqToSqlDataContext();
string postcode = txtPreviousPostcode.Text;
var ARCAddresses = db.GetARCDeliveryAddresses(Convert.ToInt32(Session[enumSessions.ARC_Id.ToString()].ToString()), postcode).ToList();
ddlarcdeliveryaddresses.DataSource = ARCAddresses;
ddlarcdeliveryaddresses.DataTextField = "Display";
ddlarcdeliveryaddresses.DataValueField = "AddressID";
ddlarcdeliveryaddresses.DataBind();
if (ARCAddresses.Any(x => x != null))
{
ddlarcdeliveryaddresses.Items.Insert(0, new System.Web.UI.WebControls.ListItem("---------------------Select--------------------", "0"));
if (ARCAddresses.Count == 1)
{
ddlarcdeliveryaddresses.SelectedIndex = 1;
}
}
else
{
ddlarcdeliveryaddresses.Items.Insert(0, new System.Web.UI.WebControls.ListItem("---------------No Previous Address------------", "0"));
}
db.Dispose();
}
protected void BindControls()
{
db = new LinqToSqlDataContext();
try
{
List <ApplicationSetting> appsettingList = new List <ApplicationSetting>();
appsettingList = (from a in db.ApplicationSettings
select a
).ToList();
ddlAppSetting.DataSource = appsettingList;
ddlAppSetting.DataTextField = "KeyName";
ddlAppSetting.DataValueField = "KeyName";
ddlAppSetting.DataBind();
foreach (var p in appsettingList)
{
if (p.KeyName == ddlAppSetting.SelectedValue)
{
txtAppSetting.Text = p.KeyValue;
}
}
}
catch (Exception objException)
{
db = new CSLOrderingARCBAL.LinqToSqlDataContext();
db.USP_SaveErrorDetails(Request.Url.ToString(), "Manage AppSetting ->Page_Load", 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()]));
}
finally
{
if (db != null)
{
db.Dispose();
}
}
}
private void LoadInstaller()
{
try
{
if (Session[enumSessions.InstallerCompanyID.ToString()] != null && Session[enumSessions.OrderId.ToString()] != null)
{
LinqToSqlDataContext dataCtxt = new LinqToSqlDataContext();
dataCtxt.USP_SaveInstallerDetailsInOrder(Session[enumSessions.InstallerCompanyID.ToString()].ToString(), Convert.ToInt32(Session[enumSessions.OrderId.ToString()]));
dataCtxt.Dispose();
}
else
{
Response.Redirect("SelectInstaller.aspx");
}
}
catch (System.Threading.ThreadAbortException ex)
{
//
}
catch (Exception objException)
{
CSLOrderingARCBAL.LinqToSqlDataContext db;
db = new CSLOrderingARCBAL.LinqToSqlDataContext();
db.USP_SaveErrorDetails(Request.Url.ToString(), ((System.Reflection.MemberInfo)(objException.TargetSite)).Name, 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 Category GetCategory(int CatId)
{
LinqToSqlDataContext db = new LinqToSqlDataContext();
var category = db.Categories.Single(c => c.CategoryId == CatId);
db.Dispose();
return(category);
}
void LoadBasketProducts()
{
LinqToSqlDataContext db = new LinqToSqlDataContext();
dlProducts.DataSource = db.USP_GetBasketProductsOnPreviousOrders_Ordering(Convert.ToInt32(Session[enumSessions.PreviousOrderId.ToString()].ToString()));
dlProducts.DataBind();
db.Dispose();
}
void LoadBasketProducts(int orderID)
{
LinqToSqlDataContext db = new LinqToSqlDataContext();
dlProducts.DataSource = db.USP_GetBasketProductsOnPreviousOrders(orderID);
dlProducts.DataBind();
db.Dispose();
}
protected void Select_Click(object sender, EventArgs e)
{
try
{
if (ddlInstallers.SelectedIndex > -1)
{
Session[enumSessions.SelectedInstaller.ToString()] = ddlInstallers.SelectedItem.Text;
Session[enumSessions.InstallerCompanyID.ToString()] = ddlInstallers.SelectedValue.ToString();
LinqToSqlDataContext dataCtxt = new LinqToSqlDataContext();
if (Session[enumSessions.BulkUploadMultipleOrderId.ToString()] != null)
{
int addressId = 0;
dataCtxt.USP_SaveInstallerDetailsInOrder(Session[enumSessions.InstallerCompanyID.ToString()].ToString(), Convert.ToInt32(Session[enumSessions.BulkUploadMultipleOrderId.ToString()]));
var insContactName = (from insAdd in dataCtxt.InstallerAddresses
join ins in dataCtxt.Installers on insAdd.AddressID equals ins.AddressID
where ins.InstallerCompanyID == new Guid(Session[enumSessions.InstallerCompanyID.ToString()].ToString())
select insAdd.ContactName).Single();
if (insContactName != null)
{
addressId = InstallerBAL.SaveInstallerAddress(Session[enumSessions.InstallerCompanyID.ToString()].ToString(), insContactName, "", 0, "", "", "", "", "", "", Session[enumSessions.User_Name.ToString()].ToString());
}
var orderDetail = dataCtxt.Orders.Single(x => x.OrderId == Convert.ToInt32(Session[enumSessions.BulkUploadMultipleOrderId.ToString()]));
if (orderDetail.DeliveryAddressId == 0)
{
orderDetail.DeliveryAddressId = addressId;
}
orderDetail.ModifiedBy = Session[enumSessions.User_Name.ToString()].ToString();
orderDetail.ModifiedOn = DateTime.Now;
dataCtxt.SubmitChanges();
getBulkuploadOrderItems(e);
// Session[enumSessions.BulkUploadMultipleOrderId.ToString()] = null;
AjaxControlToolkit.ModalPopupExtender mpInstaller = Parent.FindControl("mpInstaller") as AjaxControlToolkit.ModalPopupExtender;
mpInstaller.Hide();
}
else
{
dataCtxt.USP_SaveInstallerDetailsInOrder(Session[enumSessions.InstallerCompanyID.ToString()].ToString(), Convert.ToInt32(Session[enumSessions.OrderId.ToString()]));
dataCtxt.Dispose();
Response.Redirect("Checkout.aspx");
}
}
else
{
string script = "alertify.alert('" + ltrSelect.Text + "');";
ScriptManager.RegisterStartupScript(this.Page, this.GetType(), "alert", script, true);
}
}
catch (System.Threading.ThreadAbortException ex)
{
//
}
catch (Exception objException)
{
CSLOrderingARCBAL.LinqToSqlDataContext db;
db = new CSLOrderingARCBAL.LinqToSqlDataContext();
db.USP_SaveErrorDetails(Request.Url.ToString(), ((System.Reflection.MemberInfo)(objException.TargetSite)).Name, 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 DeliveryOffer GetDeliveryOfferByID(int deliveryOfferID)
{
LinqToSqlDataContext db = new LinqToSqlDataContext();
DeliveryOffer offer = (from deliOffer in db.DeliveryOffers
where deliOffer.DeliveryOfferId == deliveryOfferID && DateTime.Now < deliOffer.ExpiryDate
select deliOffer).FirstOrDefault();
db.Dispose();
return(offer);
}
/// <summary>
/// Get ARC Branches for selected ARC
/// </summary>
/// <param name="arcId"></param>
private static List <string> GetArcBranches(string ARCCode)
{
LinqToSqlDataContext db = new LinqToSqlDataContext();
var returnstring = (from ARCs in db.ARCs
join AM in db.AlarmDeliveryARCMappings on ARCs.ARCId equals AM.ARCId
where ARCs.ARC_Code == ARCCode
select AM.Branch_ARC_Code).ToList();
db.Dispose();
return(returnstring);
}
public static List <DeliveryType> GetDeliveryTypes()
{
LinqToSqlDataContext db = new LinqToSqlDataContext();
List <DeliveryType> deliveryTypes = new List <DeliveryType>();
deliveryTypes = (from DTypes in db.DeliveryTypes
select DTypes).ToList <DeliveryType>();
db.Dispose();
return(deliveryTypes);
}
public static List <Delivery_Product_Sibbling> GetProductSiblingsByDeliveryOffer(int deliveryOfferID)
{
List <Delivery_Product_Sibbling> siblings = new List <Delivery_Product_Sibbling>();
LinqToSqlDataContext db = new LinqToSqlDataContext();
siblings = (from offerSiblings in db.Delivery_Product_Sibblings
where offerSiblings.DeliveryOfferId == deliveryOfferID
select offerSiblings).ToList <Delivery_Product_Sibbling>();
db.Dispose();
return(siblings);
}
public static List <OrderItem> GetOrderItems(int OrderId)
{
LinqToSqlDataContext db = new LinqToSqlDataContext();
List <OrderItem> orderItems = new List <OrderItem>();
orderItems = (from oItems in db.OrderItems
where oItems.OrderId == OrderId
select oItems).ToList <OrderItem>();
db.Dispose();
return(orderItems);
}
public static List <DeliveryOffer> GetDeliveryOffersByTypeID(int deliveryTypeID)
{
List <DeliveryOffer> deliveryOffers = new List <DeliveryOffer>();
LinqToSqlDataContext db = new LinqToSqlDataContext();
deliveryOffers = (from deliOffers in db.DeliveryOffers
where deliOffers.DeliveryTypeId == deliveryTypeID && DateTime.Now < deliOffers.ExpiryDate
select deliOffers).ToList <DeliveryOffer>();
db.Dispose();
return(deliveryOffers);
}
public static string GetEmizonPlatformbyARCID(string ARCID)
{
LinqToSqlDataContext db = new LinqToSqlDataContext();
string returnstring = "";
returnstring = (from arc in db.ARCs
where arc.ARCId == Convert.ToInt32(ARCID)
select arc.EM_Platform).SingleOrDefault();
db.Dispose();
return(returnstring);
}
public static string GetARCName(string id)
{
LinqToSqlDataContext db = new LinqToSqlDataContext();
string returnstring = "";
returnstring = (from arc in db.ARCs
where arc.ARCId == Convert.ToInt32(id)
select arc.CompanyName).SingleOrDefault();
db.Dispose();
return(returnstring);
}
public static string GetARCNameByCode(string ARC_Code)
{
LinqToSqlDataContext db = new LinqToSqlDataContext();
string returnstring = "";
returnstring = (from arc in db.ARCs
where arc.ARC_Code == ARC_Code
select arc.CompanyName).SingleOrDefault();
db.Dispose();
return(returnstring);
}
/// <summary>
/// The purpose of this method to delete the selected ARC branches.
/// </summary>
/// <param name="sender"></param>
/// <param name="e"></param>
protected void btnDeleted_Click(object sender, EventArgs e)
{
try
{
db = new LinqToSqlDataContext();
int alarmDelArcId = 0;
bool isDeletedRecords = false;
foreach (GridViewRow row in gvArcBranches.Rows)
{
alarmDelArcId = Convert.ToInt32(gvArcBranches.DataKeys[row.RowIndex].Value.ToString());
if (!String.IsNullOrEmpty((row.FindControl("ARCId") as Label).Text))
{
Int32 arcId = Convert.ToInt32((row.FindControl("ARCId") as Label).Text);
Boolean isDeleted = (row.FindControl("chkDelete") as CheckBox).Checked;
if (isDeleted == true)
{
var alarmDelARCMapping = (from p in db.AlarmDeliveryARCMappings where p.ID == alarmDelArcId && p.ARCId == Convert.ToInt32(ddlArc.SelectedValue.ToString()) select p).Single();
alarmDelARCMapping.IsDeleted = true;
alarmDelARCMapping.ModifiedOn = DateTime.Now;
alarmDelARCMapping.ModifiedBy = Session[enumSessions.User_Id.ToString()].ToString();
db.SubmitChanges();
isDeletedRecords = true;
}
}
}
if (isDeletedRecords)
{
string script = "alertify.alert('" + ltrArcBranchDeleted.Text + "');";
ScriptManager.RegisterStartupScript(this.Page, this.GetType(), "alert", script, true);
}
else
{
string script = "alertify.alert('" + ltrNoSelectedToDelete.Text + "');";
ScriptManager.RegisterStartupScript(this.Page, this.GetType(), "alert", script, true);
}
BindArcBranches(Convert.ToInt32(ddlArc.SelectedValue.ToString())); // bind grid after delete ARC price
}
catch (Exception objException)
{
using (db = new LinqToSqlDataContext())
{
db.USP_SaveErrorDetails(Request.Url.ToString(), "btnDeleted_Click", 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()]));
}
}
finally
{
if (db != null)
{
db.Dispose();
}
}
}
protected void rptInstallerCompanies_ItemCommand(object source, RepeaterCommandEventArgs e)
{
try
{
Session[enumSessions.SelectedInstaller.ToString()] = e.CommandName;
Session[enumSessions.InstallerCompanyID.ToString()] = e.CommandArgument;
Session["selectInstaller"] = "selected";
LinqToSqlDataContext dataCtxt = new LinqToSqlDataContext();
if (Session[enumSessions.BulkUploadMultipleOrderId.ToString()] != null)
{
int addressId = 0;
dataCtxt.USP_SaveInstallerDetailsInOrder(Session[enumSessions.InstallerCompanyID.ToString()].ToString(), Convert.ToInt32(Session[enumSessions.BulkUploadMultipleOrderId.ToString()]));
var insContactName = (from insAdd in dataCtxt.InstallerAddresses
join ins in dataCtxt.Installers on insAdd.AddressID equals ins.AddressID
where ins.InstallerCompanyID == new Guid(Session[enumSessions.InstallerCompanyID.ToString()].ToString())
select insAdd.ContactName).Single();
if (insContactName != null)
{
addressId = InstallerBAL.SaveInstallerAddress(Session[enumSessions.InstallerCompanyID.ToString()].ToString(), insContactName, "", 0, "", "", "", "", "", "", Session[enumSessions.User_Name.ToString()].ToString());
}
var orderDetail = dataCtxt.Orders.Single(x => x.OrderId == Convert.ToInt32(Session[enumSessions.BulkUploadMultipleOrderId.ToString()]));
if (orderDetail.DeliveryAddressId == 0)
{
orderDetail.DeliveryAddressId = addressId;
}
orderDetail.ModifiedBy = Session[enumSessions.User_Name.ToString()].ToString();
orderDetail.ModifiedOn = DateTime.Now;
dataCtxt.SubmitChanges();
getBulkuploadOrderItems(e);
// Session[enumSessions.BulkUploadMultipleOrderId.ToString()] = null;
AjaxControlToolkit.ModalPopupExtender mpInstaller = Parent.FindControl("mpInstaller") as AjaxControlToolkit.ModalPopupExtender;
mpInstaller.Hide();
}
else
{
dataCtxt.USP_SaveInstallerDetailsInOrder(Session[enumSessions.InstallerCompanyID.ToString()].ToString(), Convert.ToInt32(Session[enumSessions.OrderId.ToString()]));
dataCtxt.Dispose();
Response.Redirect("Checkout.aspx");
}
}
catch (System.Threading.ThreadAbortException ex)
{
//
}
catch (Exception objException)
{
CSLOrderingARCBAL.LinqToSqlDataContext db;
db = new CSLOrderingARCBAL.LinqToSqlDataContext();
db.USP_SaveErrorDetails(Request.Url.ToString(), ((System.Reflection.MemberInfo)(objException.TargetSite)).Name, 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()]));
}
}
//ORD-41
public static string GetPyronixProducts()
{
LinqToSqlDataContext db = new LinqToSqlDataContext();
string strPyronixProducts = string.Empty;
strPyronixProducts = (from x in db.DCCCompanies
where x.company_name == "Pyronix"
select x.Productcode
).SingleOrDefault();
db.Dispose();
return(strPyronixProducts);
}
public static string GetPyronixProductsWith6DigitChipNo()
{
LinqToSqlDataContext db = new LinqToSqlDataContext();
string strPyronixProducts = string.Empty;
strPyronixProducts = (from x in db.ApplicationSettings
where x.KeyName == "PyronixProductsMandatory6digitChipNos"
select x.KeyValue
).SingleOrDefault();
db.Dispose();
return(strPyronixProducts);
}
public static Product GetProduct(int ProductId)
{
LinqToSqlDataContext db = new LinqToSqlDataContext();
var product = (from products in db.Products
where
(
(products.ProductId == ProductId)
)
select products
).SingleOrDefault();
db.Dispose();
return(product);
}
string GetBasketQtyByProductId(int ProductId)
{
LinqToSqlDataContext db = new LinqToSqlDataContext();
string Qty = "";
var ordr = db.USP_GetBasketQtyByProductId(Convert.ToInt32(Session[enumSessions.OrderId.ToString()]), ProductId, Convert.ToInt32(Request.QueryString["CategoryId"])).SingleOrDefault();
if (ordr != null)
{
Qty = ordr.ProductQty.ToString();
}
db.Dispose();
return(Qty);
}
