protected void Page_Load(object sender, EventArgs e) { string username = (string)Session["username"]; string name = (string)Session["name"]; UsernameLiteral2.Text = username; if (name.Equals(" ")) { name = ""; } if (!IsPostBack) { TextBoxName.Text = name; } DALPortalDataContext dc = new DALPortalDataContext(); Guid userId2 = dc.Users.Where(c => c.UserName.Equals(username)).Select(c => c.UserId).SingleOrDefault(); userSetting setting = dc.userSettings.Where(c => c.userId.Equals(userId2)).SingleOrDefault(); if (setting != null) { companyDDL.SelectedValue = setting.company.companyCode; if (!IsPostBack) { adminCheckBox.Checked = setting.siteAdmin; } } }
protected void Page_Init(object sender, EventArgs e) { // The code below helps to protect against XSRF attacks dc = new DALPortalDataContext(); var requestCookie = Request.Cookies[AntiXsrfTokenKey]; Guid requestCookieGuidValue; if (requestCookie != null && Guid.TryParse(requestCookie.Value, out requestCookieGuidValue)) { // Use the Anti-XSRF token from the cookie _antiXsrfTokenValue = requestCookie.Value; Page.ViewStateUserKey = _antiXsrfTokenValue; } else { // Generate a new Anti-XSRF token and save to the cookie _antiXsrfTokenValue = Guid.NewGuid().ToString("N"); Page.ViewStateUserKey = _antiXsrfTokenValue; var responseCookie = new HttpCookie(AntiXsrfTokenKey) { HttpOnly = true, Value = _antiXsrfTokenValue }; if (FormsAuthentication.RequireSSL && Request.IsSecureConnection) { responseCookie.Secure = true; } Response.Cookies.Set(responseCookie); } Page.PreLoad += master_Page_PreLoad; }
protected void RadSaveButton_Click(object sender, EventArgs e) { DALPortalDataContext dc = new DALPortalDataContext(); certificateBundle bundleOld = dc.certificateBundles.Where(c => c.businessPartnerId.Equals(businessPartnerId) && c.isActive.Equals(true)).SingleOrDefault(); if (bundleOld != null) { if (this.modelId == bundleOld.modelId) { bundleOld.startDate = DateTime.Now; bundleOld.expireDate = validUntilDTP.SelectedDate; bundleOld.previousCertQty = bundleOld.actualCertQty; // bundle.orderedCertQty = (Int32)creditsLeftTxtBox.Value - bundle.previousCertQty; bundleOld.actualCertQty = (Int32)creditsLeftTxtBox.Value; bundleOld.certificatePrice = (Decimal)priceTextBox.Value; bundleOld.isActive = true; // bundleOud.modelId = modelId; bundleOld.companyCode = "ZW"; bundleOld.businessPartnerId = businessPartnerId; } else { bundleOld.isActive = false; certificateBundle bundelNew = new certificateBundle(); bundelNew.startDate = DateTime.Now; bundelNew.expireDate = validUntilDTP.SelectedDate; bundelNew.previousCertQty = bundleOld.actualCertQty; bundelNew.orderedCertQty = 0; bundelNew.actualCertQty = (Int32)creditsLeftTxtBox.Value; bundelNew.certificatePrice = (Decimal)priceTextBox.Value; bundelNew.isActive = true; bundelNew.modelId = modelId; bundelNew.companyCode = "ZW"; bundelNew.businessPartnerId = businessPartnerId; dc.certificateBundles.InsertOnSubmit(bundelNew); } } else { certificateBundle bundelNew = new certificateBundle(); bundelNew.startDate = DateTime.Now; bundelNew.expireDate = validUntilDTP.SelectedDate; bundelNew.previousCertQty = 0; bundelNew.orderedCertQty = 0; bundelNew.actualCertQty = (Int32)creditsLeftTxtBox.Value; bundelNew.certificatePrice = (Decimal)priceTextBox.Value; bundelNew.isActive = true; bundelNew.modelId = modelId; bundelNew.companyCode = "ZW"; bundelNew.businessPartnerId = businessPartnerId; dc.certificateBundles.InsertOnSubmit(bundelNew); } dc.SubmitChanges(); Session["businessPartnerId"] = businessPartnerId; Response.Redirect("~/Pages/CustomerAccountDetails.aspx"); }
public static item GetItem(String itemCode, String companyCode, DALPortalDataContext dc) { if (!dc.items.Any(c => c.itemCode.Equals(itemCode))) return null; if (dc.companyGroupForItems.Any(c => c.companyCode.Equals(companyCode))) return dc.items.Where(c => c.itemCode.Equals(itemCode) && c.companyGroup.companyGroupForItems.Any(d => d.companyCode.Equals(companyCode))).FirstOrDefault(); else return dc.items.Where(c => c.itemCode.Equals(itemCode) && c.companyCode.Equals(companyCode)).FirstOrDefault(); }
protected void Page_Load(object sender, EventArgs e) { businessPartnerId = (Int32)Session["businessPartnerId"]; dc = new DALPortalDataContext(); if (IsPostBack) { if (ViewState["bpCode"] != null) bpCode = ViewState["bpCode"].ToString(); } }
/// <summary> /// Get BusinessPartner based on BusinessPartnerCode and CompanyCode /// </summary> /// <param name="businessPartnerCode"></param> /// <param name="companyCode"></param> /// <param name="dc"></param> /// <returns></returns> public static businessPartner GetBusinessPartner(String businessPartnerCode, String companyCode, DALPortalDataContext dc) { if (!dc.businessPartners.Any(c => c.bpCode.Equals(businessPartnerCode))) return null; if (dc.companyGroupForBps.Any(c => c.companyCode.Equals(companyCode))) return dc.businessPartners.Where(c => c.bpCode.Equals(businessPartnerCode) && c.companyGroup.companyGroupForBps.Any(d => d.companyCode.Equals(companyCode))).FirstOrDefault(); else return dc.businessPartners.Where(c => c.bpCode.Equals(businessPartnerCode) && c.companyCode.Equals(companyCode)).FirstOrDefault(); }
protected void RadButtonCreate_Click(object sender, EventArgs e) { DALPortalDataContext dc = new DALPortalDataContext(); string username = (string)Session["username"]; string name = (string)Session["name"]; string[] items = new string[RadListBoxDestination.Items.Count]; for (int i = 0; RadListBoxDestination.Items.Count > i; i++) //RadListBoxItem item in RadListBoxDestination.Items) { items[i] = RadListBoxDestination.Items[i].Value; } Guid userId2 = dc.Users.Where(c => c.UserName.Equals(username)).Select(c => c.UserId).SingleOrDefault(); List<userRole> roles = dc.userRoles.Where(c => c.userId.Equals(userId2)).ToList(); for (int i = 0; roles.Count() > i; i++) { if (!items.Contains(roles[i].roleCode)) { // roles.RemoveAt(i); dc.userRoles.DeleteOnSubmit(roles[i]); } } for (int i = 0; items.Count() > i; i++) { if (!roles.Any(c => c.roleCode.Equals(items[i]))) { userRole roleUser = new userRole { userId = userId2, roleCode = items[i] }; dc.userRoles.InsertOnSubmit(roleUser); } } userSetting userSetting = dc.userSettings.Where(c => c.userId.Equals(userId2)).SingleOrDefault(); if (userSetting == null) { userSetting = new userSetting { userId = userId2 }; userSetting.companyCode = "ZW"; userSetting.defaultCultureCode = "nl"; userSetting.name = TextBoxName.Text; userSetting.siteAdmin = adminCheckBox.Checked; dc.userSettings.InsertOnSubmit(userSetting); } else { userSetting.siteAdmin = adminCheckBox.Checked; userSetting.name = TextBoxName.Text; userSetting.companyCode = companyDDL.SelectedValue; } dc.SubmitChanges(); Response.Redirect("~/Pages/UserAccounts.aspx"); }
protected void Page_Load(object sender, EventArgs e) { dc = new DALPortalDataContext(); if (IsPostBack) { if (ViewState["bpName"] != null) bpName = ViewState["bpName"].ToString(); if (ViewState["bpCode"] != null) bpCode = ViewState["bpCode"].ToString(); } }
/// <summary> /// Get Mother BusinessPartner based on UserId /// </summary> /// <param name="userId"></param> /// <param name="dc"></param> /// <returns></returns> public static businessPartner GetBusinessPartnerMother(Guid userId, DALPortalDataContext dc) { businessPartner bp = dc.businessPartners.Where(c => c.contactPersons.Any(d => d.userId.Equals(userId))).FirstOrDefault(); if (bp == null) return null; if (bp.businessPartner1 == null) return bp; else return bp.businessPartner1; }
public static void RemoveBatchesDocument(int docId, string docType, DALPortalDataContext dc) { var batchDocuments = dc.batchDocuments.Where(c => c.baseDocType.Equals(docType) && c.baseDocId.Equals(docId)); List<int> batchIds = batchDocuments.Select(c => c.batchId).ToList(); dc.batchDocuments.DeleteAllOnSubmit(batchDocuments); dc.SubmitChanges(); var batches = dc.batches.Where(c => batchIds.Contains(c.batchId) && c.batchDocuments.Count() == 0); dc.batches.DeleteAllOnSubmit(batches); dc.SubmitChanges(); }
protected void LoginBox_LoggedIn(object sender, EventArgs e) { DALPortalDataContext dc = new DALPortalDataContext(); MembershipUser member = Membership.GetUser(LoginBox.UserName); string id = member.ProviderUserKey.ToString().ToLower(); List<userRole> roles = dc.userRoles.Where(c => c.userId.ToString().ToLower().Equals(id)).ToList(); if (roles.Any(c => c.roleCode.Equals("CERT_USER")) || roles.Any(c => c.roleCode.Equals("CERT_ADMIN"))) Response.Redirect("~/Pages/DeliveryDetails.aspx"); if (roles.Any(c => c.roleCode.Equals("DOP_USER")) || roles.Any(c => c.roleCode.Equals("DOP_ADMIN"))) Response.Redirect("~/Pages/DOP/DOPDetails.aspx"); }
public static IQueryable<vw_item> GetData(DALPortalDataContext portalDc, ItemFilter itemFilter) { var predicate = PredicateExtensions.True<vw_item>(); if (!String.IsNullOrEmpty(itemFilter.size)) predicate = predicate.And(c => c.size.Equals(itemFilter.size)); if (!String.IsNullOrEmpty(itemFilter.companyName)) predicate = predicate.And(c => c.companyName.Equals(itemFilter.companyName)); if (!String.IsNullOrEmpty(itemFilter.description)) predicate = predicate.And(c => c.description.Equals(itemFilter.description)); if (!String.IsNullOrEmpty(itemFilter.itemGroupName)) predicate = predicate.And(c => c.itemGroupName.Equals(itemFilter.itemGroupName)); // if (!String.IsNullOrEmpty(itemFilter.outsideDiameter1)) predicate = predicate.And(c => c.outsideDiameter1.Equals(itemFilter.outsideDiameter1)); if (!String.IsNullOrEmpty(itemFilter.treatmentHeat)) predicate = predicate.And(c => c.treatmentHeat.Equals(itemFilter.treatmentHeat)); if (!String.IsNullOrEmpty(itemFilter.outsideDiameter2)) predicate = predicate.And(c => c.outsideDiameter2.Equals(itemFilter.outsideDiameter2)); if (!String.IsNullOrEmpty(itemFilter.treatmentSurface)) predicate = predicate.And(c => c.treatmentSurface.Equals(itemFilter.treatmentSurface)); if (!String.IsNullOrEmpty(itemFilter.outsideDiameter3)) predicate = predicate.And(c => c.outsideDiameter3.Equals(itemFilter.outsideDiameter3)); if (!String.IsNullOrEmpty(itemFilter.ends)) predicate = predicate.And(c => c.ends.Equals(itemFilter.ends)); if (!String.IsNullOrEmpty(itemFilter.wallThickness1)) predicate = predicate.And(c => c.wallThickness1.Equals(itemFilter.wallThickness1)); if (!String.IsNullOrEmpty(itemFilter.cdi)) predicate = predicate.And(c => c.cdi.Equals(itemFilter.cdi)); if (!String.IsNullOrEmpty(itemFilter.wallThickness2)) predicate = predicate.And(c => c.wallThickness2.Equals(itemFilter.wallThickness2)); if (!String.IsNullOrEmpty(itemFilter.supplier)) predicate = predicate.And(c => c.supplier.Equals(itemFilter.supplier)); if (!String.IsNullOrEmpty(itemFilter.type)) predicate = predicate.And(c => c.type.Equals(itemFilter.type)); if (!String.IsNullOrEmpty(itemFilter.other)) predicate = predicate.And(c => c.other.Equals(itemFilter.other)); if (!String.IsNullOrEmpty(itemFilter.specification)) predicate = predicate.And(c => c.specification.Equals(itemFilter.specification)); if (!String.IsNullOrEmpty(itemFilter.certificates)) predicate = predicate.And(c => c.certificates.Equals(itemFilter.certificates)); if (!String.IsNullOrEmpty(itemFilter.length)) predicate = predicate.And(c => c.length.Equals(itemFilter.length)); return portalDc.vw_items.Where(predicate); }
protected void Page_Load(object sender, EventArgs e) { dc = new DALPortalDataContext(); if (IsPostBack) { if (ViewState["radGridCheckBoxSellectAllChecked"] != null) radGridCheckBoxSellectAllChecked = (bool)ViewState["radGridCheckBoxSellectAllChecked"]; } // RadGridCertificate.DataSource = null; // RadGridCertificate.DataBind(); if (!IsPostBack) { RadGridCertificate.Visible = false; RadButtonMergePDFs.Visible = false; RadButtonSelectedInZip.Visible = false; } Guid userId = (Guid)Membership.GetUser().ProviderUserKey; int bpId = dc.contactPersons.Where(c => c.userId.Equals(userId)).Select(c => c.businessPartnerId).SingleOrDefault(); var isSister = dc.businessPartners.Where(c => c.businessPartnerId.Equals(bpId)).Select(c => c.bpMother).SingleOrDefault(); var hasRole = dc.businessPartnerApplications.Where(c => c.businessPartnerId.Equals(bpId)).Where(c => c.applicationCode.Equals("DOP")).Select(c => c).SingleOrDefault(); if (!UserIsAdmin()) { if (hasRole == null) { if (isSister > 0) { var hasRole2 = dc.businessPartnerApplications.Where(c => c.businessPartnerId.Equals(isSister)).Where(c => c.applicationCode.Equals("DOP")).Select(c => c).SingleOrDefault(); if (hasRole2 == null) { SearchTxtBox.Enabled = false; SearchButton.Enabled = false; warningLiteral.Visible = true; warningLiteral.Text = "Your account has been disabled, please contact your accountmanager."; } } else { SearchTxtBox.Enabled = false; SearchButton.Enabled = false; warningLiteral.Visible = true; warningLiteral.Text = "Your account has been disabled, please contact your accountmanager."; } } } }
public static item CreateItem(String itemCode, String itemDescription, String companyCode) { DALPortalDataContext dc = new DALPortalDataContext(); if (GetItem(itemCode, companyCode, dc) == null) { item newItem = new item(); newItem.itemCode = itemCode; newItem.description = itemDescription; newItem.companyCode = companyCode; dc.items.InsertOnSubmit(newItem); dc.SubmitChanges(); return newItem; } return null; }
protected void Page_Load(object sender, EventArgs e) { portalDc = new DALPortalDataContext(); this.itemFilter = (ItemFilter)Session["itemFilter"]; if (!IsPostBack) { this.selectedItemId = Convert.ToInt32(Session["selectedItemId"]); this.selectedCompanyCode = Session["selectedCompanyCode"].ToString(); IQueryable<vw_item> data = EsmHelper.GetData(portalDc, this.itemFilter); int index = data.ToList().FindIndex(c => c.itemId.Equals(selectedItemId) && c.companyCode.Equals(selectedCompanyCode)); RadDataPager radDataPager = RadListViewItem.FindControl("RadDataPagerItem") as RadDataPager; radDataPager.FireCommand("Page", (index).ToString()); } }
public Boolean ProcessPDF(String databaseName, String filePath) { Boolean returnValue = true; try { String fileName = Path.GetFileName(filePath); String fileType = fileName.Substring(0, fileName.IndexOf("_")); switch (fileType) { case "CERT": DALPortalDataContext dc = new DALPortalDataContext(); String newPath = Path.Combine(Parameters_DataProcessor.CompanyFilesRoot, "Certificates", fileName); String dbPath = Path.Combine(@"~\Files\Certificates", fileName); String docId = fileName.Replace(fileType + "_", "").Replace(".pdf", ""); var batchesToUpdate = dc.batches.Where(c => c.ixosArchiveId.Equals(docId)).ToList(); if (batchesToUpdate.Count == 0) throw new Exception(String.Format("Unable to find Batch with certificateIndexNumber {0}", docId)); VanLeeuwen.Framework.IO.File.WaitForRelease(filePath, 10); VanLeeuwen.Framework.IO.File.MoveAndOverwrite(filePath, newPath); // Add Path to Batches batchesToUpdate.ForEach(c => c.certificateLink = dbPath); dc.SubmitChanges(); break; } } catch (Exception ex) { Trace.WriteLine(String.Format("Process PDF file Failed. Error: {0}", ex.Message), "ProcessDataFromXML"); returnValue = false; } return returnValue; }
protected void Page_Load(object sender, EventArgs e) { portalDc = new DALPortalDataContext(); if (!IsPostBack) { itemFilter = new ItemFilter(); Session["itemFilter"] = itemFilter; } else itemFilter = (ItemFilter)Session["itemFilter"]; }
public static Boolean ProcessSalesOrder(string fileContent, out salesOrder document) { document = new salesOrder(); DALPortalDataContext dc = new DALPortalDataContext(); Boolean update; try { XDocument xmldoc = XDocument.Parse(fileContent); XElement docTypeElement = xmldoc.Element("ORDERS05"); XElement iDocElement = docTypeElement.Element("IDOC"); // Company XElement companyElement = iDocElement.Elements("E1EDK14").ToList().Where(c => c.Element("QUALF").Value.Equals("008")).FirstOrDefault(); String sectionCode = companyElement.Element("ORGID").Value; String companyCode = CompanyClass.GetCompanyBasedOnSection(sectionCode, dc); String ecc6DocNum = RemoveLeadingZeros(iDocElement.Element("E1EDK01").Element("BELNR").Value); // Check if Sales Order already exists document = dc.salesOrders.Where(c => c.documentNumber.Equals(ecc6DocNum) && c.companyCode.Equals(companyCode)).FirstOrDefault(); if (document == null) { document = new salesOrder(); document.companyCode = companyCode; document.documentNumber = ecc6DocNum; document.docStatusCode = "O"; update = false; } else { update = true; } // Document Header info String sapECC6BusinessPartnerCode = Convert.ToInt32(iDocElement.Element("E1EDK01").Element("RECIPNT_NO").Value).ToString(); businessPartner bp = Objects.BusinessPartnerClass.GetBusinessPartner(sapECC6BusinessPartnerCode, document.companyCode, dc); if (bp == null) throw new Exception(String.Format("BusinessPartner {0} does not exists.", sapECC6BusinessPartnerCode)); document.businessPartnerId = bp.businessPartnerId; document.currencyCode = iDocElement.Element("E1EDK01").Element("CURCY").Value; document.currencyRate = Convert.ToDecimal(iDocElement.Element("E1EDK01").Element("WKURS").Value, NumberFormatInfo.InvariantInfo); // Customer Reference XElement custRef = iDocElement.Elements("E1EDK02").ToList().Where(c => c.Element("QUALF").Value.Equals("001")).FirstOrDefault(); document.customerReference = custRef.Element("BELNR").Value; // Dates XElement delDateElement = iDocElement.Elements("E1EDK03").ToList().Where(c => c.Element("IDDAT").Value.Equals("002")).FirstOrDefault(); document.deliveryDate = DateTime.ParseExact(delDateElement.Element("DATUM").Value, "yyyyMMdd", CultureInfo.CurrentCulture); XElement del2DateElement = iDocElement.Elements("E1EDK03").ToList().Where(c => c.Element("IDDAT").Value.Equals("012")).FirstOrDefault(); document.docDate = DateTime.ParseExact(del2DateElement.Element("DATUM").Value, "yyyyMMdd", CultureInfo.CurrentCulture); XElement del3DateElement = iDocElement.Elements("E1EDK03").ToList().Where(c => c.Element("IDDAT").Value.Equals("025")).FirstOrDefault(); document.createDate = DateTime.ParseExact(del3DateElement.Element("DATUM").Value, "yyyyMMdd", CultureInfo.CurrentCulture); // Sales Order lines foreach (var orderLineElement in iDocElement.Elements("E1EDP01").ToList()) { salesOrderLine line = new salesOrderLine(); Int32 lineNum = Convert.ToInt32(orderLineElement.Element("POSEX").Value); Boolean newLine = false; if (update && document.salesOrderLines.Any(c => c.lineNum.Equals(lineNum))) { line = document.salesOrderLines.Where(c => c.lineNum.Equals(lineNum)).FirstOrDefault(); } else { line.lineNum = lineNum; newLine = true; } // Get Item (remove leading zero's) XElement ItemCodeElement = orderLineElement.Elements("E1EDP19").ToList().Where(c => c.Element("QUALF").Value.Equals("002")).FirstOrDefault(); String itemCode = RemoveLeadingZeros(ItemCodeElement.Element("IDTNR").Value); String itemName = ItemCodeElement.Element("KTEXT").Value; item item = ItemClass.GetItem(itemCode, companyCode, dc); if (item == null) item = ItemClass.CreateItem(itemCode, itemName, companyCode); line.itemId = item.itemId; line.lineNum = Convert.ToInt32(orderLineElement.Element("POSEX").Value); line.uomCodeOrg = orderLineElement.Element("MENEE").Value; line.price = Convert.ToDecimal(orderLineElement.Element("VPREI").Value, NumberFormatInfo.InvariantInfo); line.itemDescription = itemName; if (orderLineElement.Element("MENGE") != null) line.quantity = Convert.ToDecimal(orderLineElement.Element("MENGE").Value, NumberFormatInfo.InvariantInfo); else line.quantity = 0; if (orderLineElement.Element("NTGEW") != null) line.weight = Convert.ToDecimal(orderLineElement.Element("NTGEW").Value, NumberFormatInfo.InvariantInfo); else line.weight = 0; line.lineTypeCode = orderLineElement.Element("PSTYV").Value; line.lineStatusCode = "O"; line.customerReference = String.Empty; line.customerItemCode = String.Empty; XElement customerItemCodeElement = orderLineElement.Elements("E1EDP19").ToList().Where(c => c.Element("QUALF").Value.Equals("001")).FirstOrDefault(); if (customerItemCodeElement != null) { XElement customerItemCodeElement2 = customerItemCodeElement.Element("IDTNR"); if (customerItemCodeElement2 != null) line.customerItemCode = RemoveLeadingZeros(customerItemCodeElement2.Value); } XElement customerReference = orderLineElement.Elements("E1EDPT1").ToList().Where(c => c.Element("TDID").Value.Equals("0002")).FirstOrDefault(); if (customerReference != null) { XElement customerReference2 = customerReference.Element("E1EDPT2"); if (customerReference2 != null) line.customerReference = customerReference2.Element("TDLINE") != null ? customerReference2.Element("TDLINE").Value : String.Empty; } // Line is cancelled when field ABGRU is filled var lineStatusElement = orderLineElement.Element("ABGRU"); ; if (lineStatusElement != null) if (!String.IsNullOrWhiteSpace(lineStatusElement.Value)) line.lineStatusCode = "C"; // ShipDate String deliveryDate = GetSOLineDeliveryDate(orderLineElement); if (!String.IsNullOrEmpty(deliveryDate)) line.deliveryDate = DateTime.ParseExact(deliveryDate, "yyyyMMdd", CultureInfo.CurrentCulture); // Certificate as Ordered Boolean certAsOrdered = orderLineElement.Elements("E1EDP02").ToList().Any(c => c.Element("QUALF").Value.Equals("902") && c.Element("BELNR").Value.Equals("ZCPT")); line.certOrdered = certAsOrdered; if (newLine) document.salesOrderLines.Add(line); } } catch (Exception ex) { Trace.WriteLine(String.Format("Error converting Sales Order {0} for company {1} from SAP ECC6 XML format. Error: {2}", document.documentNumber, document.companyCode, ex.Message), "ProcessSalesOrder"); return false; } if (update) { try { dc.SubmitChanges(); Trace.WriteLine(String.Format("Updating Sales Order {0} for company {1} Successfull.", document.documentNumber, document.companyCode), "ProcessSalesOrder"); } catch (Exception ex) { Trace.WriteLine(String.Format("Error Updating Sales Order {0} for company {1}. Error: {2}", document.documentNumber, document.companyCode, ex.Message), "ProcessSalesOrder"); return false; } } else { try { dc.salesOrders.InsertOnSubmit(document); dc.SubmitChanges(); Trace.WriteLine(String.Format("Creating Sales Order {0} for company {1} Successfull.", document.documentNumber, document.companyCode), "ProcessSalesOrder"); } catch (Exception ex) { Trace.WriteLine(String.Format("Error Creating Sales Order {0} for company {1}. Error: {2}", document.documentNumber, document.companyCode, ex.Message), "ProcessSalesOrder"); return false; } } return true; }
private static Boolean ProcessBatches(delivery deliveryDocument, List<batch> batches) { DALPortalDataContext dc = new DALPortalDataContext(); Boolean returnValue = true; // Remove all batches attached to this document BatchClass.RemoveBatchesDocument(deliveryDocument.docId, deliveryDocument.docType, dc); foreach (batch batchLine in batches) { try { batch batch = BatchClass.GetBatch(batchLine.batchNumber, batchLine.heatNumber, batchLine.itemId, deliveryDocument.companyCode, dc); Boolean newBatch = false; if (batch == null) { batch = new batch(); newBatch = true; } if (newBatch) { batch.batchNumber = batchLine.batchNumber; batch.companyCode = deliveryDocument.companyCode; } batch.itemId = batchLine.itemId; batch.certificateIndexNumber = batchLine.certificateIndexNumber; batch.heatNumber = batchLine.heatNumber; batch.ixosArchiveId = batchLine.ixosArchiveId; if (newBatch) { // Check if certificate is already on the server String fileName = "CERT_" + batchLine.ixosArchiveId + ".pdf"; String filePath = Path.Combine(Parameters_DataProcessor.CompanyFilesRoot, "Certificates", fileName); String dbPath = Path.Combine(@"~\Files\Certificates", fileName); if (File.Exists(filePath)) batch.certificateLink = dbPath; } foreach (batchDocument batchDocLine in batchLine.batchDocuments) { // Check if Batch relates to document batchDocument batchDoc = batch.batchDocuments.Where(c => c.baseDocId.Equals(deliveryDocument.docId) && c.baseLineNum.Equals(batchDocLine.baseLineNum) && c.baseDocType.Equals("DL")).FirstOrDefault(); Boolean newBatchDoc = false; if (batchDoc == null) { newBatchDoc = true; batchDoc = new batchDocument(); batchDoc.baseDocId = deliveryDocument.docId; batchDoc.baseLineNum = batchDocLine.baseLineNum; batchDoc.baseDocType = "DL"; } batchDoc.quantity = batchDocLine.quantity; if (newBatchDoc) batch.batchDocuments.Add(batchDoc); } if (newBatch) dc.batches.InsertOnSubmit(batch); dc.SubmitChanges(); } catch (Exception ex) { Trace.WriteLine(String.Format("Error Processing Batches for Delivery {0} for company {1}. Error: {2}", deliveryDocument.documentNumber, deliveryDocument.companyCode, ex.Message), "ProcessBatches"); returnValue = false; } } return returnValue; }
public static Boolean ProcessCustomer(string fileContent, out businessPartner businessPartner, out String outCompanyCode) { businessPartner = new businessPartner(); DALPortalDataContext dc = new DALPortalDataContext(); Boolean update; String companyCode = String.Empty; outCompanyCode = String.Empty; try { XDocument xmldoc = XDocument.Parse(fileContent); XElement docTypeElement = xmldoc.Element("DEBMAS03"); XElement iDocElement = docTypeElement.Element("IDOC"); var customerHeaderElement = iDocElement.Element("E1KNA1M"); //Int32 CardCode; // Remove unused elements iDocElement.Element("EDI_DC40").Remove(); // BpCode, remove leading zero's from Cardcode String bpCode = Convert.ToInt32(customerHeaderElement.Element("KUNNR").Value).ToString(); String sectionCode = customerHeaderElement.Element("E1KNVVM").Element("VKORG").Value; companyCode = CompanyClass.GetCompanyBasedOnSection(sectionCode, dc); outCompanyCode = companyCode; // Check if bp Already exists businessPartner = BusinessPartnerClass.GetBusinessPartner(bpCode, companyCode, dc); if (businessPartner == null) { businessPartner = new businessPartner(); update = false; } else { update = true; } if (!update) { String companyGroupCode = dc.companyGroupForBps.Where(c => c.companyCode.Equals(companyCode)).Select(c => c.companyGroupCode).FirstOrDefault(); if (String.IsNullOrEmpty(companyGroupCode)) businessPartner.companyCode = companyCode; else businessPartner.companyGroupCode = companyGroupCode; } // Mapp customer header data businessPartner.bpCode = bpCode; businessPartner.bpType = 'C'; businessPartner.bpName = customerHeaderElement.Elements().Where(c => c.Name.ToString().Equals("NAME1")).FirstOrDefault().Value; businessPartner.address = customerHeaderElement.Elements().Where(c => c.Name.ToString().Equals("STRAS")).FirstOrDefault().Value; if (customerHeaderElement.Elements().Any(c => c.Name.ToString().Equals("TELF1"))) businessPartner.telephone = customerHeaderElement.Elements().Where(c => c.Name.ToString().Equals("TELF1")).FirstOrDefault().Value; if(customerHeaderElement.Elements().Any(c => c.Name.ToString().Equals("TELFX"))) businessPartner.fax = customerHeaderElement.Elements().Where(c => c.Name.ToString().Equals("TELFX")).FirstOrDefault().Value; businessPartner.countryCode = customerHeaderElement.Elements().Where(c => c.Name.ToString().Equals("LAND1")).FirstOrDefault().Value; businessPartner.languageCode = customerHeaderElement.Elements().Where(c => c.Name.ToString().Equals("SPRAS_ISO")).FirstOrDefault().Value; // Mapp contactperson data foreach (var contactpersonElement in customerHeaderElement.Elements("E1KNVKM").ToList()) { contactPerson contact; // Contact Id String contactPersonCode = Convert.ToInt32(contactpersonElement.Elements().Where(c => c.Name.ToString().Equals("PARNR")).FirstOrDefault().Value).ToString(); Boolean newContact = false; if (update && businessPartner.contactPersons.Any(c => c.contactPersonCode.Equals(contactPersonCode))) { contact = businessPartner.contactPersons.Where(c => c.contactPersonCode.Equals(contactPersonCode)).FirstOrDefault(); } else { contact = new contactPerson(); contact.contactPersonCode = contactPersonCode; newContact = true; } // Email var emailAddress = contactpersonElement.Elements().Where(c => c.Name.ToString().Equals("PARAU")).FirstOrDefault(); if (emailAddress != null) contact.eMail = emailAddress.Value.ToLower(); // Title var title = contactpersonElement.Elements().Where(c => c.Name.ToString().Equals("ANRED")).FirstOrDefault(); if (title != null) contact.title = title.Value; // FirstName var firstName = contactpersonElement.Elements().Where(c => c.Name.ToString().Equals("NAMEV")).FirstOrDefault(); if (firstName != null) contact.firstName = firstName.Value; // LastName var lastName = contactpersonElement.Elements().Where(c => c.Name.ToString().Equals("NAME1")).FirstOrDefault(); if (lastName != null) contact.lastName = lastName.Value; // WebUser var webUserType = contactpersonElement.Elements().Where(c => c.Name.ToString().Equals("AKVER")).FirstOrDefault(); if (webUserType != null) { contact.isWebContact = (webUserType.Value == "02") ? false : true; contact.TMP_PortalAccess = webUserType.Value; } // Add CardCode to contactperson if (newContact) businessPartner.contactPersons.Add(contact); } } catch (Exception ex) { Trace.WriteLine(String.Format("Error converting customer {0} for company {1} from SAP ECC6 XML format. Error: {2}", businessPartner.bpCode, companyCode, ex.Message), "MapCustomerFromECC6"); return false; } if (update) { try { dc.SubmitChanges(); Trace.WriteLine(String.Format("Updating Customer {0} for company {1} Successfull.", businessPartner.bpCode, companyCode), "MapCustomerFromECC6"); } catch (Exception ex) { Trace.WriteLine(String.Format("Error Updating Customer {0} for company {1}. Error: {2}", businessPartner.bpCode, companyCode, ex.Message), "MapCustomerFromECC6"); return false; } } else { try { dc.businessPartners.InsertOnSubmit(businessPartner); dc.SubmitChanges(); Trace.WriteLine(String.Format("Creating Customer {0} for company {1} Successfull.", businessPartner.bpCode, companyCode), "MapCustomerFromECC6"); } catch (Exception ex) { Trace.WriteLine(String.Format("Error Creating Customer {0} for company {1}. Error: {2}", businessPartner.bpCode, companyCode, ex.Message), "MapCustomerFromECC6"); return false; } } return true; }
public static bool ProcessItem(string fileContent) { item item = new item(); DALPortalDataContext dc = new DALPortalDataContext(); Boolean update; String companyCode = String.Empty; //outCompanyCode = String.Empty; try { XDocument xmldoc = XDocument.Parse(fileContent); XElement docTypeElement = xmldoc.Element("MATMAS05"); XElement iDocElement = docTypeElement.Element("IDOC"); var itemHeaderElement = iDocElement.Element("E1MARAM"); // ItemCode, remove leading zero's from ItemCode String itemCode = RemoveLeadingZeros(itemHeaderElement.Element("MATNR").Value).ToString(); String sectionCode = itemHeaderElement.Element("E1MVKEM").Element("VKORG").Value; companyCode = CompanyClass.GetCompanyBasedOnSection(sectionCode, dc); // Check if item Already exists item = ItemClass.GetItem(itemCode, companyCode, dc); if (item == null) { item = new item(); update = false; } else { update = true; } if (!update) item.companyCode = companyCode; // Mapp customer header data item.itemCode = itemCode; // English description XElement ItemDescElement = itemHeaderElement.Elements("E1MAKTM").ToList().Where(c => c.Element("MSGFN").Value.Equals("005") && c.Element("SPRAS_ISO").Value.Equals("EN")).FirstOrDefault(); if (ItemDescElement != null) { XElement ItemDescElement2 = ItemDescElement.Element("MAKTX"); if (ItemDescElement2 != null) item.description = ItemDescElement2.Value; } // Certificate Type. // 00 = Cert. Niet van toepassing if (itemHeaderElement.Elements().Any(c => c.Name.ToString().Equals("GTIN_VARIANT"))) item.CertificateType = itemHeaderElement.Element("GTIN_VARIANT").Value; } catch (Exception ex) { Trace.WriteLine(String.Format("Error converting item {0} for company {1} from SAP ECC6 XML format. Error: {2}", item.itemCode, companyCode, ex.Message), "ProcessItem"); return false; } if (update) { try { dc.SubmitChanges(); Trace.WriteLine(String.Format("Updating Item {0} for company {1} Successfull.", item.itemCode, companyCode), "ProcessItem"); } catch (Exception ex) { Trace.WriteLine(String.Format("Error Updating Item {0} for company {1}. Error: {2}", item.itemCode, companyCode, ex.Message), "ProcessItem"); return false; } } else { try { dc.items.InsertOnSubmit(item); dc.SubmitChanges(); Trace.WriteLine(String.Format("Creating Item {0} for company {1} Successfull.", item.itemCode, companyCode), "ProcessItem"); } catch (Exception ex) { Trace.WriteLine(String.Format("Error Creating Item {0} for company {1}. Error: {2}", item.itemCode, companyCode, ex.Message), "ProcessItem"); return false; } } return true; }
protected void RadSaveButton_Click(object sender, EventArgs e) { DALPortalDataContext dc = new DALPortalDataContext(); certificateBundle bundleOld = dc.certificateBundles.Where(c => c.businessPartnerId.Equals(bpId) && c.isActive.Equals(true)).SingleOrDefault(); if (bundleOld != null) { bundleOld.isActive = false; } certificateBundle bundelNew = new certificateBundle(); if (bundleOld != null) { bundelNew.previousCertQty = bundleOld.actualCertQty; bundelNew.actualCertQty = (Int32)creditsOrderTxtBox.Value + bundleOld.actualCertQty; bundelNew.orderedCertQty = bundleOld.orderedCertQty + (Int32)creditsOrderTxtBox.Value; bundelNew.certificatePrice = bundleOld.certificatePrice; } else { bundelNew.previousCertQty = 0; bundelNew.actualCertQty = (Int32)creditsOrderTxtBox.Value; bundelNew.orderedCertQty = (Int32)creditsOrderTxtBox.Value; bundelNew.certificatePrice = (decimal)7.50; } bundelNew.startDate = DateTime.Now; bundelNew.expireDate = DateTime.Now.AddYears(1); bundelNew.isActive = true; bundelNew.modelId = 2; bundelNew.companyCode = "ZW"; bundelNew.businessPartnerId = bpId; businessPartner bpProps = dc.businessPartners.Where(c => c.businessPartnerId.Equals(bpId)).Select(c => c).SingleOrDefault(); DocumentCached cashed = new DocumentCached(); cashed.CustomerCode = bpProps.bpCode; cashed.VLCompany = "ZW01"; cashed.DocDate = DateTime.Now; cashed.Comment = "Certificate portal invoice"; DocumentLineCached cashedLine = new DocumentLineCached(); cashedLine.Currency = "EUR"; cashedLine.LineNum = 1; cashedLine.ItemCode = "C"; cashedLine.Quantity = (Int32)creditsOrderTxtBox.Value; cashedLine.UnitOfMeasure = "ST"; cashedLine.Price = (decimal)bundelNew.certificatePrice; cashedLine.ShortText = creditsOrderTxtBox.Value + " ordered on " + DateTime.Now + "."; cashed.Lines.Add(cashedLine); dc.certificateBundles.InsertOnSubmit(bundelNew); dc.SubmitChanges(); XmlToObject.ObjectToXml(cashed, HttpContext.Current.Server.MapPath(Path.Combine(@"~\Files\Outbox", "invoice " + DateTime.Now.Ticks.ToString() + ".xml"))); MembershipUser membershipUser = Membership.GetUser(); if (membershipUser != null) { String emailTemplate = HttpContext.Current.Server.MapPath(Path.Combine(@"~\Files\EmailTemplates", "OrderConfirmation.html")); StreamReader streamReader = new StreamReader(emailTemplate); String mailMessageBody = streamReader.ReadToEnd(); String fromEmailAddress; String subject; String toEmailAddress; mailMessageBody = EmailClass.GetMailParams(mailMessageBody, out fromEmailAddress, out toEmailAddress, out subject); mailMessageBody = mailMessageBody.Replace("{Credits}", membershipUser.UserName); try { MailMessage mailMessage = new MailMessage(); mailMessage.IsBodyHtml = true; mailMessage.From = new MailAddress(fromEmailAddress); mailMessage.To.Add(membershipUser.UserName); mailMessage.Subject = subject; mailMessage.Body = mailMessageBody; SmtpClient smtpClient = new SmtpClient(); smtpClient.Send(mailMessage); } catch (Exception ex) { // TODO: Create errorpage for user Response.Redirect("~/Pages/OrderSuccess.aspx"); } } Session["businessPartnerId"] = bpId; Response.Redirect("~/Pages/OrderSuccess.aspx"); }
public static Boolean ProcessDelivery(String fileContent, out delivery deliveryDocument) { deliveryDocument = new delivery(); List<batch> batches = new List<batch>(); String sapECC6DocNum = String.Empty; DALPortalDataContext dc = new DALPortalDataContext(); Boolean update; Boolean returnValue = true; try { List<String> items = new List<String>(); XDocument xmldoc = XDocument.Parse(fileContent); XElement docTypeElement = xmldoc.Element("DELVRY03"); XElement iDocElement = docTypeElement.Element("IDOC"); XElement deliveryElement = iDocElement.Element("E1EDL20"); // Company String sectionCode = deliveryElement.Element("VKORG").Value; String companyCode = CompanyClass.GetCompanyBasedOnSection(sectionCode, dc); sapECC6DocNum = RemoveLeadingZeros(deliveryElement.Element("VBELN").Value); // Check if Sales Order already exists deliveryDocument = dc.deliveries.Where(c => c.documentNumber.Equals(sapECC6DocNum) && c.companyCode.Equals(companyCode)).FirstOrDefault(); if (deliveryDocument == null) { deliveryDocument = new delivery(); deliveryDocument.companyCode = companyCode; deliveryDocument.documentNumber = sapECC6DocNum; deliveryDocument.docStatusCode = "O"; update = false; } else { update = true; } // Document Header info String sapECC6BusinessPartnerCode = RemoveLeadingZeros(deliveryElement.Elements("E1ADRM1").Where(c => c.Element("PARTNER_Q").Value.Equals("AG")).FirstOrDefault().Element("PARTNER_ID").Value); businessPartner bp = Objects.BusinessPartnerClass.GetBusinessPartner(sapECC6BusinessPartnerCode, deliveryDocument.companyCode, dc); if (bp == null) throw new Exception(String.Format("BusinessPartner {0} does not exists.", sapECC6BusinessPartnerCode)); // Get BusinessPartnerID deliveryDocument.businessPartnerId = bp.businessPartnerId; // Dates XElement delDateElement = deliveryElement.Elements("E1EDT13").ToList().Where(c => c.Element("QUALF").Value.Equals("007")).FirstOrDefault(); deliveryDocument.deliveryDate = DateTime.ParseExact(delDateElement.Element("NTEND").Value, "yyyyMMdd", CultureInfo.CurrentCulture); XElement del2DateElement = deliveryElement.Elements("E1EDT13").ToList().Where(c => c.Element("QUALF").Value.Equals("015")).FirstOrDefault(); deliveryDocument.docDate = DateTime.ParseExact(del2DateElement.Element("NTEND").Value, "yyyyMMdd", CultureInfo.CurrentCulture); deliveryDocument.createDate = DateTime.ParseExact(del2DateElement.Element("NTEND").Value, "yyyyMMdd", CultureInfo.CurrentCulture); if (deliveryDocument.deliveryDate < DateTime.Now.AddYears(-50)) deliveryDocument.deliveryDate = deliveryDocument.docDate; //// Delivery lines List<XElement> deliveryLines = deliveryElement.Elements("E1EDL24").Where(c => c.Element("HIPOS") == null).ToList(); List<XElement> deliverySubLines = deliveryElement.Elements("E1EDL24").Where(c => c.Element("HIPOS") != null).ToList(); foreach (var deliveryLineElement in deliveryLines) { deliveryLine line = new deliveryLine(); String lineNumString = deliveryLineElement.Element("POSNR").Value; Int32 lineNum = Convert.ToInt32(lineNumString); Boolean newLine = false; if (update && deliveryDocument.deliveryLines.Any(c => c.lineNum.Equals(lineNum))) { line = deliveryDocument.deliveryLines.Where(c => c.lineNum.Equals(lineNum)).FirstOrDefault(); } else { line.lineNum = lineNum; newLine = true; } // DeliveryLine is not connected to a Sales Order if (deliveryLineElement.Element("VGBEL") == null) continue; String sapSODocNum = RemoveLeadingZeros(deliveryLineElement.Element("VGBEL").Value); Int32 sapSOLineNum = Convert.ToInt32(deliveryLineElement.Element("VGPOS").Value); salesOrderLine salesOrderLine = Objects.SalesOrderClass.GetSalesOrderLine(sapSODocNum, lineNum, companyCode, dc); if (salesOrderLine == null) { Trace.WriteLine(String.Format("Cannot find Sales Order {0}, Line {1} for Delivery {2}.", sapSODocNum, sapSOLineNum, sapECC6DocNum), "MapDeliveryXMLToSBO"); returnValue = false; continue; } String itemCode = RemoveLeadingZeros(deliveryLineElement.Element("MATNR").Value); item item = Objects.ItemClass.GetItem(itemCode, companyCode, dc); // Get POSTYPE String posType = deliveryLineElement.Element("E1EDL26").Element("PSTYV").Value; XElement baseLineNum = deliveryLineElement.Element("HIPOS"); // Add Batchinfo Decimal quantity = Convert.ToDecimal(deliveryLineElement.Element("LFIMG").Value, NumberFormatInfo.InvariantInfo); if (lineNumString.Substring(0, 1).Equals("9")) continue; if (Serac.BasicFunctions.Right(itemCode, 1).Equals("B") && (posType == "ZBNI" || posType == "ZCNI")) { // Get Quantity and Batches from Treatment line GetBatchesTreatmentLine(ref batches, ref quantity, line.lineNum, deliverySubLines, item.itemId); } else if (quantity > 0) { GetBatch(ref batches, line.lineNum, deliveryLineElement, quantity, item.itemId); } else { // Get Quantity and Batches from "Charge Splitsing" GetBatchesChargeSplitsing(ref batches, ref quantity, line.lineNum, deliverySubLines, item.itemId); } // Update Currency from base document if (deliveryDocument.currencyCode == null) { deliveryDocument.currencyCode = salesOrderLine.salesOrder.currencyCode; deliveryDocument.currencyRate = salesOrderLine.salesOrder.currencyRate; } line.baseDocId = salesOrderLine.salesOrder.docId; line.baseLineNum = Convert.ToInt32(deliveryLineElement.Element("VGPOS").Value); line.baseDocType = "SO"; line.quantity = quantity; line.itemId = item.itemId; line.lineStatusCode = "O"; line.itemDescription = salesOrderLine.itemDescription; // Get Certificates as ordered from base document line.certOrdered = salesOrderLine.certOrdered; // Add Line to SBO delivery line if (newLine) deliveryDocument.deliveryLines.Add(line); } } catch (Exception ex) { Trace.WriteLine(String.Format("Error Converting Delivery XML to WebPortal format. Error: {0}", ex.Message), "ProcessDelivery"); return false; } if (deliveryDocument.deliveryLines.Count == 0) return false; if (update) { try { dc.SubmitChanges(); Trace.WriteLine(String.Format("Updating Delivery {0} for company {1} Successfull.", deliveryDocument.documentNumber, deliveryDocument.companyCode), "ProcessDelivery"); } catch (Exception ex) { Trace.WriteLine(String.Format("Error Updating Delivery {0} for company {1}. Error: {2}", deliveryDocument.documentNumber, deliveryDocument.companyCode, ex.Message), "ProcessDelivery"); return false; } } else { try { dc.deliveries.InsertOnSubmit(deliveryDocument); dc.SubmitChanges(); Trace.WriteLine(String.Format("Creating Delivery {0} for company {1} Successfull.", deliveryDocument.documentNumber, deliveryDocument.companyCode), "ProcessDelivery"); } catch (Exception ex) { Trace.WriteLine(String.Format("Error Creating Delivery {0} for company {1}. Error: {2}", deliveryDocument.documentNumber, deliveryDocument.companyCode, ex.Message), "ProcessDelivery"); return false; } } if (!ProcessBatches(deliveryDocument, batches)) return false; return returnValue; }
public static certificateBundle GetCurrentBundle(Int32 businessPartnerId, DALPortalDataContext dc) { return dc.certificateBundles.Where(c => c.businessPartnerId.Equals(businessPartnerId)).Where(r => r.isActive).SingleOrDefault(); }
private void loadData() { DALPortalDataContext dc = new DALPortalDataContext(); certificateBundle bundleOud = dc.certificateBundles.Where(c => c.businessPartnerId.Equals(bpId) && c.isActive.Equals(true)).SingleOrDefault(); if (bundleOud != null) { creditsPurchasedTxtBox.Value = bundleOud.orderedCertQty; if (bundleOud.usedCertQty != null) { creditsUsedTxtBox.Value = bundleOud.usedCertQty; } } }
private void getData() { DALPortalDataContext dc = new DALPortalDataContext(); certificateBundle bundle = dc.certificateBundles.Where(c => c.businessPartnerId.Equals(businessPartnerId) && c.isActive.Equals(true)).SingleOrDefault(); if (bundle != null) { creditsPurchasedTxtBox.Value = bundle.orderedCertQty; creditsUsedTxtBox.Value = bundle.usedCertQty; creditsLeftTxtBox.Value = bundle.actualCertQty; validUntilDTP.SelectedDate = bundle.expireDate; if (bundle.certificatePrice == null) { priceTextBox.Value = 7.50; } else { priceTextBox.Value = (Double)bundle.certificatePrice; } switch (bundle.modelId) { case 1: btnModel1.Checked = true; break; case 2: btnModel2.Checked = true; break; case 3: btnModel3.Checked = true; break; case 4: btnModel4.Checked = true; break; case 5: btnModel5.Checked = true; break; } this.modelId = bundle.modelId; } }
public static contactPerson GetContactPerson(Guid userId, DALPortalDataContext dc) { return dc.contactPersons.Where(c => c.userId.Equals(userId)).FirstOrDefault(); }
protected void rolesDataSource_Selecting(object sender, LinqDataSourceSelectEventArgs e) { e.Result = GetData(); DALPortalDataContext dc = new DALPortalDataContext(); string username = (string)Session["username"]; Guid userId2 = dc.Users.Where(c => c.UserName.Equals(username)).Select(c => c.UserId).SingleOrDefault(); List<string> roles = dc.userRoles.Where(c => c.userId.Equals(userId2)).Select(c => c.roleCode).ToList(); for (int i = 0; roles.Count() > i; i++) { if (RadListBoxSource.FindItemByValue(roles[i]) != null) { RadListBoxSource.FindItemByValue(roles[i]).Remove(); } } RadListBox items = RadListBoxApplications; string valueListBox = RadListBoxApplications.SelectedValue; }
private IQueryable<applicationRole> GetData() { DALPortalDataContext dc = new DALPortalDataContext(); string value = RadListBoxApplications.SelectedValue; return dc.applicationRoles.Where(c => c.application.applicationName.Equals(value)); }
private IQueryable<string> GetDataUserRoles() { DALPortalDataContext dc = new DALPortalDataContext(); string username = (string)Session["username"]; Guid userId2 = dc.Users.Where(c => c.UserName.Equals(username)).Select(c => c.UserId).SingleOrDefault(); return dc.userRoles.Where(c => c.userId.Equals(userId2)).Select(c => c.roleCode); }