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 = "";
}
}
}
}
