public List <UnitOfMeasureInfo> SelectAllUnitOfMeasure() { try { List <UnitOfMeasureInfo> lstUnitOfMeasure = new List <UnitOfMeasureInfo>(); using (RMSDataContext db = new RMSDataContext()) { var hp = (from u in db.UnitOfMeasures select u).ToList(); foreach (var one in hp) { UnitOfMeasureInfo uObj = new UnitOfMeasureInfo(); uObj.UMID = one.UMID; uObj.UMDescription = one.UMDescription; lstUnitOfMeasure.Add(uObj); } return(lstUnitOfMeasure); } } catch (Exception ex) { return(new List <UnitOfMeasureInfo>()); } }
private void autoUOM_SelectionChanged(object sender, SelectionChangedEventArgs e) { try { UnitOfMeasureInfo uomInfo = (UnitOfMeasureInfo)autoUOM.SelectedItem; if (uomInfo != null) { autoUOM.Text = uomInfo.UnitOfMeasure; } } catch (Exception ex) { throw ex; } }
public void DeleteUnitOfMeasureByUnitOfMeasurreID(UnitOfMeasureInfo UOMInfo) { try { using (RMSDataContext db = new RMSDataContext()) { var obj = (from a in db.UnitOfMeasures where a.UMID == UOMInfo.UMID select a).First(); db.UnitOfMeasures.DeleteOnSubmit(obj); db.SubmitChanges(); } } catch (Exception ex) { UnitOfMeasure tbl = new UnitOfMeasure(); } }
public void InsertUM(UnitOfMeasureInfo umf) { try { using (RMSDataContext db = new RMSDataContext()) { UnitOfMeasure um = new UnitOfMeasure(); Guid uid = Guid.NewGuid(); um.UMID = uid.ToString(); um.UMDescription = umf.UMDescription; db.UnitOfMeasures.InsertOnSubmit(um); db.SubmitChanges(); } } catch (Exception ex) { } }
protected void Button1_Click(object sender, EventArgs e) { UnitOfMeasureInfo sinfo = new UnitOfMeasureInfo(); UnitOfMeasureController sCon = new UnitOfMeasureController(); string fn = @"D:\UMList.xlsx"; FileStream fs = File.Open(fn, FileMode.Open, FileAccess.Read); IExcelDataReader ir = ExcelReaderFactory.CreateOpenXmlReader(fs); DataSet ds = ir.AsDataSet(); foreach (DataTable tobj in ds.Tables) { foreach (DataRow robj in tobj.Rows) { sinfo.UMDescription = Convert.ToString(robj[0]); sCon.InsertUnitOfMeasure(sinfo); } } ir.Close(); fs.Close(); }
public void DeleteUnitOfMeasure(UnitOfMeasureInfo UOMInfo) { uomDao.DeleteUnitOfMeasureByUnitOfMeasurreID(UOMInfo); }
public void UpdateUnitOfMeasure(UnitOfMeasureInfo UOMInfo) { uomDao.UpdateUnitOfMeasureByUnitOfMeasurreID(UOMInfo); }
public void InsertUnitOfMeasure(UnitOfMeasureInfo UOMInfo) { uomDao.InsertUM(UOMInfo); }
private void Grid_KeyUp(object sender, KeyEventArgs e) { if (e.Key == Key.Enter) { if (autoProductName.SelectedItem != null && txtWholeSaleRate.Text.Length > 0 && autoUOM.SelectedItem != null && txtQty.Text.Length > 0 && txtProfit.Text.Length > 0 && txtTaxRate.Text.Length > 0) { ProductInfo productInfo = null; if (autoProductName.SelectedItem != null) { productInfo = (ProductInfo)autoProductName.SelectedItem; } UnitOfMeasureInfo uomInfo = null; if (autoUOM != null) { uomInfo = (UnitOfMeasureInfo)autoUOM.SelectedItem; } BS_PurchaseService.ProductInfo productInfoExist = purchaseList.SingleOrDefault(i => i.ProductCode == productInfo.ProductCode); if (productInfoExist != null) { MessageBox.Show("Product already in the list. If you want to change qty please update in the list it self"); } else { BS_PurchaseService.PurchaseInfo purchaseInfo = new BS_PurchaseService.PurchaseInfo(); if (productInfo != null) { purchaseInfo.DisplayProductName = productInfo.DisplayProductName; purchaseInfo.ProductCategoryInfo = productInfo.ProductCategoryInfo; purchaseInfo.ProductCode = productInfo.ProductCode; purchaseInfo.ProductDescription = productInfo.ProductDescription; //purchaseInfo. = productInfo.ProductSize; decimal qty = 0; decimal.TryParse(txtQty.Text.ToString(), out qty); purchaseInfo.Qty = qty; decimal profitInPercentage = 0; decimal.TryParse(txtProfit.Text.ToString(), out profitInPercentage); purchaseInfo.RetailRate = profitInPercentage; purchaseInfo.VendorInfo = productInfo.VendorInfo;; purchaseInfo.UoM = uomInfo.UnitOfMeasure; decimal wholeSaleRate = 0; decimal.TryParse(txtWholeSaleRate.Text.ToString(), out wholeSaleRate); purchaseInfo.WholeSaleRate = wholeSaleRate; decimal taxRate = 0; decimal.TryParse(txtTaxRate.Text.ToString(), out taxRate); // purchaseInfo.TaxRate = taxRate; decimal retailRate = 0; decimal.TryParse(txtRetailRate.Text.ToString(), out retailRate); purchaseInfo.RetailRate = retailRate; purchaseList.Add(purchaseInfo); } datagridProduct.ItemsSource = null; datagridProduct.ItemsSource = purchaseList; //this.autoProductName.Focus(); autoUOM.SelectedItem = null; autoProductName.SelectedItem = null; txtWholeSaleRate.Text = ""; txtQty.Text = ""; txtProfit.Text = ""; txtRetailRate.Text = ""; txtTaxRate.Text = ""; } } } }