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); }