コード例 #1
0
        private void btnDelete_Click(object sender, EventArgs e)
        {
            try
            {
                DEWSRMEntities     db            = new DEWSRMEntities();
                int[]              selRows       = ((GridView)grdColorInfos.MainView).GetSelectedRows();
                DataRowView        oColorInfosID = (DataRowView)(((GridView)grdColorInfos.MainView).GetRow(selRows[0]));
                int                nColorInfosID = Convert.ToInt32(oColorInfosID["ColorInfosID"]);
                INVENTORY.DA.Color oColorInfo    = db.Colors.FirstOrDefault(p => p.ColorID == nColorInfosID);

                if (oColorInfo == null)
                {
                    MessageBox.Show("select an item to delete", "Item not yet selected", MessageBoxButtons.OK, MessageBoxIcon.Information);
                    return;
                }

                if (MessageBox.Show("Do you want to delete the selected item?", "Delete Setup", MessageBoxButtons.YesNo,
                                    MessageBoxIcon.Question) == DialogResult.Yes)
                {
                    db.Colors.Attach(oColorInfo);
                    db.Colors.Remove(oColorInfo);

                    db.SaveChanges();

                    MessageBox.Show("Data Deleted Successfully.", "Deleted", MessageBoxButtons.OK, MessageBoxIcon.Information);
                    RefreshList();
                }
            }
            catch (Exception Ex)
            {
                MessageBox.Show("Cannot delete item due to " + Ex.Message);
            }
        }
コード例 #2
0
        private void btnEdit_Click(object sender, EventArgs e)
        {
            try
            {
                using (DEWSRMEntities db = new DEWSRMEntities())
                {
                    int[]       selRows      = ((GridView)grdColorInfos.MainView).GetSelectedRows();
                    DataRowView oColorInfosD = (DataRowView)(((GridView)grdColorInfos.MainView).GetRow(selRows[0]));

                    int nColorInfosID             = Convert.ToInt32(oColorInfosD["ColorInfosID"]);
                    INVENTORY.DA.Color oColorInfo = db.Colors.FirstOrDefault(p => p.ColorID == nColorInfosID);


                    if (oColorInfo == null)
                    {
                        MessageBox.Show("select an item to edit", "Item not yet selected", MessageBoxButtons.OK, MessageBoxIcon.Information);
                        return;
                    }
                    fColorInfo frm = new fColorInfo();

                    frm.ItemChanged = RefreshList;
                    frm.ShowDlg(oColorInfo, false);
                }
            }
            catch (Exception ex)
            {
                MessageBox.Show(ex.Message);
            }
        }
コード例 #3
0
 public void ShowDlg(INVENTORY.DA.Color oColInfo, bool IsNew)
 {
     _IsNew     = IsNew;
     _ColorInfo = oColInfo;
     RefreshValue();
     this.ShowDialog();
 }
コード例 #4
0
        private void grdColors_MouseDoubleClick(object sender, MouseEventArgs e)
        {
            try
            {
                int[]       selRows = ((GridView)grdColors.MainView).GetSelectedRows();
                DataRowView oID     = (DataRowView)(((GridView)grdColors.MainView).GetRow(selRows[0]));
                int         nID     = Convert.ToInt32(oID["ID"]);

                INVENTORY.DA.Color oColorInfo = null;

                if (nID > 0)
                {
                    oColorInfo      = db.Colors.FirstOrDefault(p => p.ColorID == nID);
                    _ctl.SelectedID = oColorInfo.ColorID;
                    _ctl.Code       = oColorInfo.Description;
                }

                if (ItemChanged != null)
                {
                    ItemChanged();
                }
                this.Close();
            }
            catch (Exception ex)
            {
                MessageBox.Show(ex.Message);
            }
        }
コード例 #5
0
        private void RefreshGrid()
        {
            try
            {
                int count = 0;
                int nSLNo = 1;
                dgProducts.Rows.Clear();
                if (_ReturnDetails.Count != 0)
                {
                    var RDData = (from rd in _ReturnDetails
                                  join std in _oStockDetailList on rd.SDetailID equals std.SDetailID
                                  group rd by new { rd.ProductID, std.ColorID } into g
                                  select new VMReturnDetail
                    {
                        ProductID = g.Key.ProductID,
                        ColorID = g.Key.ColorID,
                        Quantity = g.Sum(o => o.Quantity),
                        UnitPrice = g.Select(o => o.UnitPrice).FirstOrDefault(),
                        UTAmount = g.Sum(o => o.UTAmount)
                    });

                    if (RDData.Count() > 0)
                    {
                        foreach (var oPODItem in RDData)
                        {
                            dgProducts.Rows.Add();
                            Product oProduct = _oProList.FirstOrDefault(o => o.ProductID == oPODItem.ProductID);
                            // StockDetail oSDetail = _oStockDetailList.FirstOrDefault(sd => sd.SDetailID == oPODItem.SDetailID);
                            INVENTORY.DA.Color oColor = _ColorList.FirstOrDefault(c => c.ColorID == oPODItem.ColorID);
                            dgProducts.Rows[count].Cells[0].Value = nSLNo.ToString();
                            dgProducts.Rows[count].Cells[1].Value = oProduct.ProductName;
                            dgProducts.Rows[count].Cells[2].Value = oProduct.Company.Description;
                            dgProducts.Rows[count].Cells[3].Value = oProduct.Category.Description;
                            dgProducts.Rows[count].Cells[4].Value = oColor.Description;
                            dgProducts.Rows[count].Cells[5].Value = oPODItem.Quantity.ToString();
                            dgProducts.Rows[count].Cells[6].Value = oPODItem.UnitPrice.ToString();
                            dgProducts.Rows[count].Cells[7].Value = oPODItem.UTAmount.ToString();
                            dgProducts.Rows[count].Tag            = oPODItem;
                            count++;
                            nSLNo++;
                        }
                    }
                }
            }
            catch (Exception ex)
            {
                MessageBox.Show(ex.Message);
            }
        }
コード例 #6
0
ファイル: fReturn.cs プロジェクト: AneeshLeen/InventoryRepo
        private void RefreshGrid()
        {
            try
            {
                int count = 0;
                int nSLNo = 1;
                dgProducts.Rows.Clear();
                if (_ReturnDetails != null)
                {
                    if (_ReturnDetails.Count > 0)
                    {
                        foreach (ReturnDetail oPODItem in _ReturnDetails)
                        {
                            dgProducts.Rows.Add();

                            Product            oProduct = _oProList.FirstOrDefault(o => o.ProductID == oPODItem.ProductID);
                            StockDetail        oSDetail = _oStockDetailList.FirstOrDefault(sd => sd.SDetailID == oPODItem.SDetailID);
                            INVENTORY.DA.Color oColor   = _ColorList.FirstOrDefault(c => c.ColorID == oSDetail.ColorID);

                            dgProducts.Rows[count].Cells[0].Value = nSLNo.ToString();
                            dgProducts.Rows[count].Cells[1].Value = oProduct.ProductName;
                            dgProducts.Rows[count].Cells[2].Value = oProduct.Company.Description;
                            //dgProducts.Rows[count].Cells[3].Value = oColor.Description;
                            dgProducts.Rows[count].Cells[3].Value = oProduct.Category.Description;
                            dgProducts.Rows[count].Cells[4].Value = "";
                            dgProducts.Rows[count].Cells[5].Value = oPODItem.Quantity.ToString();
                            dgProducts.Rows[count].Cells[6].Value = oPODItem.UnitPrice.ToString();
                            dgProducts.Rows[count].Cells[7].Value = oPODItem.UTAmount.ToString();
                            dgProducts.Rows[count].Tag            = oPODItem;
                            count++;
                            nSLNo++;
                        }
                    }
                }
            }
            catch (Exception ex)
            {
                MessageBox.Show(ex.Message);
            }
        }
コード例 #7
0
        private void RefreshList()
        {
            try
            {
                DataTable dt = new DataTable();
                DataRow   dr = null;
                dt.Columns.Add("ProductID");
                dt.Columns.Add("Code");
                dt.Columns.Add("Name");
                dt.Columns.Add("Company");
                dt.Columns.Add("SDetailID");
                dt.Columns.Add("Category");
                dt.Columns.Add("Size");
                dt.Columns.Add("Color");

                List <Product>            ProductList     = db.Products.ToList();
                List <Category>           CategoryList    = db.Categorys.ToList();
                List <Model>              ModelList       = db.Models.ToList();
                List <Company>            CompanyList     = db.Companies.ToList();
                List <StockDetail>        StockDetailList = db.StockDetails.ToList();
                List <INVENTORY.DA.Color> oColorList      = db.Colors.ToList();


                Product            oProduct  = null;
                Category           oCategory = null;
                Company            oCompany  = null;
                Model              oModel    = null;
                INVENTORY.DA.Color oColor    = null;


                if (_ObjectName == "SReturn")
                {
                    StockDetail oStockDetail             = null;
                    var         CustomerSOrderDetailList = db.SOrderDetails.Where(o => o.SOrder.CustomerID == _CustID && o.SOrder.Status == (int)EnumSalesType.Sales).ToList();

                    #region Barcode and Serial Product
                    var ALLSOrderDetailsList = (from sod in CustomerSOrderDetailList
                                                join p in ProductList on sod.ProductID equals p.ProductID
                                                where p.ProductType != (int)EnumProductType.NoBarCode
                                                select sod).ToList();


                    var ALLDisSOrderDetailsList = (from d in ALLSOrderDetailsList
                                                   group d by new { d.ProductID, d.StockDetailID } into g
                                                   select new SOrderDetail
                    {
                        ProductID = g.Key.ProductID,
                        StockDetailID = g.Key.StockDetailID
                    }).ToList();


                    int nTempProId = 0;
                    this.Text = "All Sales Products";
                    if (ALLDisSOrderDetailsList != null)
                    {
                        foreach (var grd in ALLDisSOrderDetailsList)
                        {
                            oProduct = ProductList.FirstOrDefault(s => s.ProductID == grd.ProductID);


                            oCategory    = CategoryList.FirstOrDefault(p => p.CategoryID == oProduct.CategoryID);
                            oCompany     = CompanyList.FirstOrDefault(p => p.CompanyID == oProduct.CompanyID);
                            oModel       = ModelList.FirstOrDefault(p => p.ModelID == oProduct.ModelID);
                            oStockDetail = new StockDetail();
                            oStockDetail = StockDetailList.FirstOrDefault(p => p.SDetailID == grd.StockDetailID);
                            oColor       = oColorList.FirstOrDefault(c => c.ColorID == oStockDetail.ColorID);

                            if (oStockDetail.Status == (int)EnumStockDetailStatus.Sold)
                            {
                                dr = dt.NewRow();
                                dr["ProductID"] = oProduct.ProductID;
                                dr["Code"]      = oProduct.Code;
                                dr["Name"]      = oProduct.ProductName;
                                dr["Company"]   = oCompany.Description;
                                dr["Category"]  = oCategory.Description;
                                dr["SDetailID"] = grd.StockDetailID;
                                dr["Color"]     = oColor.Description;
                                dr["Size"]      = oStockDetail.IMENO;
                                dt.Rows.Add(dr);
                            }
                        }
                    }
                    #endregion

                    #region Nobarcode
                    var ALLnobarcodeSODList = (from sod in CustomerSOrderDetailList
                                               join p in ProductList on sod.ProductID equals p.ProductID
                                               where p.ProductType == (int)EnumProductType.NoBarCode
                                               select sod).ToList();

                    if (ALLnobarcodeSODList.Count() != 0)
                    {
                        var ALLNobarcodeDisSODList = (from d in ALLnobarcodeSODList
                                                      group d by new { d.StockDetailID } into g
                                                      select new SOrderDetail
                        {
                            StockDetailID = g.Key.StockDetailID,
                        }).ToList();

                        foreach (var grd in ALLNobarcodeDisSODList)
                        {
                            oStockDetail = new StockDetail();
                            oStockDetail = StockDetailList.FirstOrDefault(p => p.SDetailID == grd.StockDetailID);
                            oProduct     = ProductList.FirstOrDefault(s => s.ProductID == oStockDetail.ProductID);
                            oCategory    = CategoryList.FirstOrDefault(p => p.CategoryID == oProduct.CategoryID);
                            oCompany     = CompanyList.FirstOrDefault(p => p.CompanyID == oProduct.CompanyID);
                            oModel       = ModelList.FirstOrDefault(p => p.ModelID == oProduct.ModelID);

                            oColor = oColorList.FirstOrDefault(c => c.ColorID == oStockDetail.ColorID);

                            dr = dt.NewRow();
                            dr["ProductID"] = oProduct.ProductID;
                            dr["Code"]      = oProduct.Code;
                            dr["Name"]      = oProduct.ProductName;
                            dr["Category"]  = oCategory.Description;
                            dr["Company"]   = oCompany.Description;
                            dr["SDetailID"] = grd.StockDetailID;
                            dr["Color"]     = oColor.Description;
                            dr["Size"]      = oStockDetail.IMENO;

                            dt.Rows.Add(dr);
                        }
                    }
                    #endregion

                    grdProducts.DataSource = dt;
                    lblTotal.Text          = "Total :" + ALLSOrderDetailsList.Count().ToString();
                    // + ALLnobarcodeSODList.Sum(i => i.Quantity)
                }
                else if (_ObjectName == "PReturn")
                {
                    StockDetail oStockDetail = null;
                    int         nCount       = 0;

                    var SuppPOrderDetailList = db.POrderDetails.Where(o => o.POrder.SupplierID == _CustID && o.POrder.Status == (int)EnumPurchaseType.Purchase).ToList();

                    #region Barcode and Serial Product
                    var ALLSOrderDetailsList = (from sod in SuppPOrderDetailList
                                                join p in ProductList on sod.ProductID equals p.ProductID
                                                join std in db.StockDetails on sod.POrderDetailID equals std.POrderDetailID
                                                where p.ProductType != (int)EnumProductType.NoBarCode
                                                select new
                    {
                        sod,
                        std
                    }).ToList();


                    var ALLDisSOrderDetailsList = (from d in ALLSOrderDetailsList
                                                   where d.std.Status == (int)EnumStockDetailStatus.Stock
                                                   group d by new { d.std.SDetailID, d.std.ProductID, d.std.ColorID } into g
                                                   select new
                    {
                        ProductID = g.Key.ProductID,
                        SDetailID = g.Key.SDetailID,
                        ColorID = g.Key.ColorID
                    }).ToList();


                    //int nTempProId = 0;
                    this.Text = "All Purchase Products";
                    if (ALLDisSOrderDetailsList != null && ALLDisSOrderDetailsList.Count > 0)
                    {
                        foreach (var grd in ALLDisSOrderDetailsList)
                        {
                            oProduct     = ProductList.FirstOrDefault(s => s.ProductID == grd.ProductID);
                            oCategory    = CategoryList.FirstOrDefault(p => p.CategoryID == oProduct.CategoryID);
                            oCompany     = CompanyList.FirstOrDefault(p => p.CompanyID == oProduct.CompanyID);
                            oModel       = ModelList.FirstOrDefault(p => p.ModelID == oProduct.ModelID);
                            oStockDetail = new StockDetail();
                            oStockDetail = StockDetailList.FirstOrDefault(p => p.SDetailID == grd.SDetailID);
                            oColor       = oColorList.FirstOrDefault(c => c.ColorID == oStockDetail.ColorID);

                            if (oStockDetail.Status == (int)EnumStockDetailStatus.Stock)
                            {
                                dr = dt.NewRow();
                                dr["ProductID"] = oProduct.ProductID;
                                dr["Code"]      = oProduct.Code;
                                dr["Name"]      = oProduct.ProductName;
                                dr["Company"]   = oCompany.Description;
                                dr["Category"]  = oCategory.Description;
                                dr["SDetailID"] = grd.SDetailID;
                                dr["Color"]     = oColor.Description;
                                dr["Size"]      = oStockDetail.IMENO;
                                dt.Rows.Add(dr);
                            }
                        }
                    }
                    #endregion

                    #region Nobarcode
                    var ALLnobarcodeSODList = (from sod in SuppPOrderDetailList
                                               join p in ProductList on sod.ProductID equals p.ProductID
                                               where p.ProductType == (int)EnumProductType.NoBarCode
                                               select sod).ToList();

                    if (ALLnobarcodeSODList.Count() != 0)
                    {
                        var ALLNobarcodeDisSODList = (from d in ALLnobarcodeSODList
                                                      group d by new { d.ProductID, d.ColorID } into g
                                                      select new POrderDetail
                        {
                            // POrderDetailID=g.Key.POrderDetailID,
                            ProductID = g.Key.ProductID,
                            ColorID = g.Key.ColorID
                        }).ToList();


                        //int nProductId = 0;
                        //int nColorId = 0;

                        foreach (var grd in ALLNobarcodeDisSODList)
                        {
                            oStockDetail = new StockDetail();
                            oStockDetail = StockDetailList.FirstOrDefault(p => p.ProductID == grd.ProductID && p.ColorID == grd.ColorID);
                            oProduct     = ProductList.FirstOrDefault(s => s.ProductID == oStockDetail.ProductID);
                            oCategory    = CategoryList.FirstOrDefault(p => p.CategoryID == oProduct.CategoryID);
                            oCompany     = CompanyList.FirstOrDefault(p => p.CompanyID == oProduct.CompanyID);
                            oModel       = ModelList.FirstOrDefault(p => p.ModelID == oProduct.ModelID);

                            oColor = oColorList.FirstOrDefault(c => c.ColorID == oStockDetail.ColorID);

                            dr = dt.NewRow();
                            dr["ProductID"] = oProduct.ProductID;
                            dr["Code"]      = oProduct.Code;
                            dr["Name"]      = oProduct.ProductName;
                            dr["Category"]  = oCategory.Description;
                            dr["Company"]   = oCompany.Description;
                            dr["SDetailID"] = oStockDetail.SDetailID;
                            dr["Color"]     = oColor.Description;
                            dr["Size"]      = oStockDetail.IMENO;

                            dt.Rows.Add(dr);
                            nCount++;
                        }
                    }
                    #endregion

                    grdProducts.DataSource = dt;
                    lblTotal.Text          = "Total :" + nCount.ToString();
                    //+",Qty:"+ ALLnobarcodeSODList.Sum(i => i.Quantity)
                }
            }
            catch (Exception ex)
            {
                MessageBox.Show(ex.Message, "Error", MessageBoxButtons.OK, MessageBoxIcon.Error);
            }
        }
コード例 #8
0
ファイル: fStockRpt.cs プロジェクト: AneeshLeen/InventoryRepo
        private void btnPreview_Click(object sender, EventArgs e)
        {
            try
            {
                using (DEWSRMEntities db = new DEWSRMEntities())
                {
                    int nCount = 0;

                    List <Stock> oStocks = null;

                    if (rbCompany.Checked)
                    {
                        oStocks = db.Stocks.Where(s => s.Quantity > 0).OrderBy(s => s.Product.Company.Description).ThenBy(s => s.Product.Category.Description).ToList();
                    }
                    else if (rbCategory.Checked)
                    {
                        oStocks = db.Stocks.Where(s => s.Quantity > 0).OrderBy(s => s.Product.Company.Description).ThenBy(s => s.Product.Category.Description).ToList();
                    }
                    else if (rbModel.Checked)
                    {
                        oStocks = db.Stocks.Where(s => s.Quantity > 0).OrderBy(s => s.Product.Company.Description).ThenBy(s => s.Product.Category.Description).ToList();
                    }
                    else if (rbColorCode.Checked)
                    {
                        oStocks = db.Stocks.Where(s => s.Quantity > 0).OrderBy(s => s.Product.Company.Description).ThenBy(s => s.Color.Code).ToList();
                    }

                    if (ctlBrand.SelectedID > 0)
                    {
                        oStocks = db.Stocks.Where(s => s.Product.CompanyID == ctlBrand.SelectedID && s.Quantity > 0).OrderBy(s => s.Product.Company.Description).ThenBy(s => s.Product.Category.Description).ToList();
                    }
                    else if (ctlCategory.SelectedID > 0)
                    {
                        oStocks = db.Stocks.Where(s => s.Product.CategoryID == ctlCategory.SelectedID && s.Quantity > 0).OrderBy(s => s.Product.Company.Description).ThenBy(s => s.Product.Category.Description).ToList();
                    }
                    else if (ctlPreOrProduct.SelectedID > 0)
                    {
                        oStocks = db.Stocks.Where(s => s.Product.ProductID == ctlPreOrProduct.SelectedID && s.Quantity > 0).OrderBy(s => s.Product.Company.Description).ThenBy(s => s.Product.Category.Description).ToList();
                    }
                    else if (ctlColor.SelectedID > 0)
                    {
                        oStocks = db.Stocks.Where(s => s.ColorID == ctlColor.SelectedID && s.Quantity > 0).OrderBy(s => s.Product.Company.Description).ThenBy(s => s.Product.Category.Description).ToList();
                    }

                    List <Category>           oCatList = db.Categorys.ToList();
                    List <Company>            oComList = db.Companies.ToList();
                    List <INVENTORY.DA.Color> oColList = db.Colors.ToList();
                    List <Product>            oProList = db.Products.ToList();

                    if (oStocks != null)
                    {
                        if (rbCategory.Checked || ctlCategory.SelectedID > 0)
                        {
                            nCount = 1;
                            rptDataSet.StockInfoDataTable dt = new rptDataSet.StockInfoDataTable();
                            DataSet ds = new DataSet();

                            foreach (Stock oSTItem in oStocks)
                            {
                                Product  oPro = oProList.FirstOrDefault(o => o.ProductID == oSTItem.ProductID);
                                Category oCat = oCatList.FirstOrDefault(o => o.CategoryID == oPro.CategoryID);
                                Company  oCom = oComList.FirstOrDefault(o => o.CompanyID == oPro.CompanyID);
                                dt.Rows.Add((EnumProductType)oPro.ProductType, ((DateTime)oSTItem.EntryDate).ToString("dd MMM yyyy"), oSTItem.StockCode, oCat.Description, oCom.Description, oSTItem.Product.ProductName, oSTItem.Color.Description, oSTItem.Quantity, oSTItem.PMPrice, (oSTItem.Quantity * oSTItem.PMPrice));
                                nCount++;
                            }

                            dt.TableName = "rptDataSet_StockInfo";
                            ds.Tables.Add(dt);

                            string embededResource = "INVENTORY.UI.RDLC.rptCategoryWiseStock.rdlc";

                            List <ReportParameter> parameters = new List <ReportParameter>();

                            ReportParameter rParam = null;
                            rParam = new ReportParameter("PrintedBy", Global.CurrentUser.UserName);
                            parameters.Add(rParam);
                            rParam = new ReportParameter("SLNO", nCount.ToString());
                            parameters.Add(rParam);



                            fReportViewer frm = new fReportViewer();

                            if (dt.Rows.Count > 0)
                            {
                                frm.CommonReportViewer(embededResource, ds, parameters, true);
                            }
                            else
                            {
                                MessageBox.Show("No Recors Found.", "Report", MessageBoxButtons.OK, MessageBoxIcon.Information);
                            }
                            rbCategory.Checked     = false;
                            ctlCategory.SelectedID = 0;
                            RefreshControl();
                        }
                        else if (rbCompany.Checked || ctlBrand.SelectedID > 0)
                        {
                            nCount = 1;
                            rptDataSet.StockInfoDataTable dt = new rptDataSet.StockInfoDataTable();
                            DataSet ds = new DataSet();
                            foreach (Stock oSTItem in oStocks)
                            {
                                Product  oPro = oProList.FirstOrDefault(o => o.ProductID == oSTItem.ProductID);
                                Category oCat = oCatList.FirstOrDefault(o => o.CategoryID == oPro.CategoryID);
                                Company  oCom = oComList.FirstOrDefault(o => o.CompanyID == oPro.CompanyID);
                                dt.Rows.Add((EnumProductType)oPro.ProductType, ((DateTime)oSTItem.EntryDate).ToString("dd MMM yyyy"), oSTItem.StockCode, oCat.Description, oCom.Description, oSTItem.Product.ProductName, oSTItem.Color.Description, oSTItem.Quantity, oSTItem.PMPrice, (oSTItem.Quantity * oSTItem.PMPrice));
                                nCount++;
                            }

                            dt.TableName = "rptDataSet_StockInfo";
                            ds.Tables.Add(dt);

                            string embededResource            = "INVENTORY.UI.RDLC.rptCompanyWiseStock.rdlc";
                            List <ReportParameter> parameters = new List <ReportParameter>();
                            ReportParameter        rParam     = null;

                            rParam = new ReportParameter("PrintedBy", Global.CurrentUser.UserName);
                            parameters.Add(rParam);

                            rParam = new ReportParameter("SLNO", nCount.ToString());
                            parameters.Add(rParam);

                            fReportViewer frm = new fReportViewer();

                            if (dt.Rows.Count > 0)
                            {
                                frm.CommonReportViewer(embededResource, ds, parameters, true);
                            }
                            else
                            {
                                MessageBox.Show("No Recors Found.", "Report", MessageBoxButtons.OK, MessageBoxIcon.Information);
                            }

                            rbCompany.Checked   = false;
                            ctlBrand.SelectedID = 0;
                            RefreshControl();
                        }
                        else if (rbModel.Checked || ctlPreOrProduct.SelectedID > 0)
                        {
                            nCount = 1;
                            rptDataSet.StockInfoDataTable dt = new rptDataSet.StockInfoDataTable();
                            DataSet ds = new DataSet();
                            foreach (Stock oSTItem in oStocks)
                            {
                                Product  oPro = oProList.FirstOrDefault(o => o.ProductID == oSTItem.ProductID);
                                Category oCat = oCatList.FirstOrDefault(o => o.CategoryID == oPro.CategoryID);
                                Company  oCom = oComList.FirstOrDefault(o => o.CompanyID == oPro.CompanyID);
                                dt.Rows.Add((EnumProductType)oPro.ProductType, ((DateTime)oSTItem.EntryDate).ToString("dd MMM yyyy"), oSTItem.StockCode, oCat.Description, oCom.Description, oSTItem.Product.ProductName, oSTItem.Color.Description, oSTItem.Quantity, oSTItem.PMPrice, (oSTItem.Quantity * oSTItem.PMPrice));
                                nCount++;
                            }

                            dt.TableName = "rptDataSet_StockInfo";
                            ds.Tables.Add(dt);

                            string embededResource = "INVENTORY.UI.RDLC.StockInfo.rdlc";

                            List <ReportParameter> parameters = new List <ReportParameter>();

                            ReportParameter rParam = null;

                            rParam = new ReportParameter("PrintedBy", Global.CurrentUser.UserName);
                            parameters.Add(rParam);

                            rParam = new ReportParameter("SLNO", nCount.ToString());
                            parameters.Add(rParam);


                            fReportViewer frm = new fReportViewer();

                            if (dt.Rows.Count > 0)
                            {
                                frm.CommonReportViewer(embededResource, ds, parameters, true);
                            }
                            else
                            {
                                MessageBox.Show("No Recors Found.", "Report", MessageBoxButtons.OK, MessageBoxIcon.Information);
                            }

                            rbModel.Checked            = false;
                            ctlPreOrProduct.SelectedID = 0;
                            RefreshControl();
                        }
                        else if (rbColorCode.Checked || ctlColor.SelectedID > 0)
                        {
                            nCount = 1;
                            rptDataSet.StockInfoDataTable dt = new rptDataSet.StockInfoDataTable();
                            DataSet ds = new DataSet();
                            foreach (Stock oSTItem in oStocks)
                            {
                                Product            oPro   = oProList.FirstOrDefault(o => o.ProductID == oSTItem.ProductID);
                                Category           oCat   = oCatList.FirstOrDefault(o => o.CategoryID == oPro.CategoryID);
                                Company            oCom   = oComList.FirstOrDefault(o => o.CompanyID == oPro.CompanyID);
                                INVENTORY.DA.Color oColor = oColList.FirstOrDefault(c => c.ColorID == oSTItem.ColorID);
                                dt.Rows.Add((EnumProductType)oPro.ProductType, ((DateTime)oSTItem.EntryDate).ToString("dd MMM yyyy"), oSTItem.StockCode, oCat.Description, oCom.Description, oPro.ProductName, oColor.Description, oSTItem.Quantity, oSTItem.PMPrice, (oSTItem.Quantity * oSTItem.PMPrice));
                                nCount++;
                            }

                            dt.TableName = "rprDataSet_StockInfo";
                            ds.Tables.Add(dt);

                            string embededResource = "INVENTORY.UI.RDLC.rptColorWise.rdlc";


                            List <ReportParameter> parameters = new List <ReportParameter>();
                            ReportParameter        rParam     = new ReportParameter();

                            rParam = new ReportParameter("PrintedBy", Global.CurrentUser.UserName);
                            parameters.Add(rParam);

                            rParam = new ReportParameter("SLNO", nCount.ToString());
                            parameters.Add(rParam);


                            fReportViewer frm = new fReportViewer();

                            if (dt.Rows.Count > 0)
                            {
                                frm.CommonReportViewer(embededResource, ds, parameters, true);
                            }
                            else
                            {
                                MessageBox.Show("No Recors Found.", "Report", MessageBoxButtons.OK, MessageBoxIcon.Information);
                            }
                        }//
                    }
                }
            }
            catch (Exception ex)
            {
                MessageBox.Show(ex.Message);
            }
        }
コード例 #9
0
ファイル: fStocks.cs プロジェクト: AneeshLeen/InventoryRepo
        private void RefreshStock()
        {
            try
            {
                using (DEWSRMEntities db = new DEWSRMEntities())
                {
                    var _Stocks = db.Stocks;

                    var _Companies  = db.Companies;
                    var _Categories = db.Categorys;
                    var _Colors     = db.Colors;
                    var _Products   = db.Products;

                    var _StockDetails = db.StockDetails;


                    _StockList       = _Stocks.ToList();
                    _CompanyList     = _Companies.ToList();
                    _CategoryList    = _Categories.ToList();
                    _ProductList     = _Products.ToList();
                    _StockDetailList = _StockDetails.ToList();
                    _ColorList       = _Colors.ToList();

                    DataTable dt  = new DataTable();
                    DataRow   oDR = null;

                    dt.Columns.Add("StockID");
                    dt.Columns.Add("StockCode");
                    dt.Columns.Add("ProductName");
                    dt.Columns.Add("Category");
                    dt.Columns.Add("Company");
                    dt.Columns.Add("Color");
                    dt.Columns.Add("Qty");
                    dt.Columns.Add("PurRate");
                    dt.Columns.Add("TotalPrice");
                    dt.Columns.Add("MRP");

                    if (_StockList != null)
                    {
                        foreach (Stock oStock in _StockList)
                        {
                            if (oStock.Quantity > 0)
                            {
                                oDR = dt.NewRow();

                                Product            oPro         = _ProductList.FirstOrDefault(o => o.ProductID == oStock.ProductID);
                                Company            oCom         = _CompanyList.FirstOrDefault(o => o.CompanyID == oPro.CompanyID);
                                Category           oCat         = _CategoryList.FirstOrDefault(o => o.CategoryID == oPro.CategoryID);
                                INVENTORY.DA.Color oColor       = _ColorList.FirstOrDefault(o => o.ColorID == oStock.ColorID);
                                StockDetail        oStockDetail = _StockDetailList.OrderByDescending(o => o.SDetailID).FirstOrDefault(o => o.StockID == oStock.StockID);

                                if (oPro == null || oCom == null || oCat == null || oColor == null || oStockDetail == null)
                                {
                                }

                                oDR["StockID"]     = oStock.StockID;
                                oDR["StockCode"]   = oStock.StockCode;
                                oDR["ProductName"] = oPro.ProductName;
                                oDR["Category"]    = oCat.Description;
                                oDR["Company"]     = oCom.Description;
                                oDR["Color"]       = oColor.Description;

                                oDR["Qty"]        = Math.Round((decimal)oStock.Quantity, 0);
                                oDR["PurRate"]    = oStock.PMPrice;
                                oDR["TotalPrice"] = Math.Round((decimal)(oStock.Quantity * oStock.PMPrice), 2).ToString();
                                oDR["MRP"]        = oStockDetail.SalesRate;
                                dt.Rows.Add(oDR);
                            }
                        }
                        grdStocks.DataSource = dt;
                        lblStockTotal.Text   = "Total :" + _StockList.Count.ToString();
                    }
                }
            }
            catch (Exception ex)
            {
                MessageBox.Show(ex.Message, "Error", MessageBoxButtons.OK, MessageBoxIcon.Error);
            }
        }
コード例 #10
0
        private void ctlProduct_SelectedItemChanged(object sender, EventArgs e)
        {
            try
            {
                //List<Godown> oGodownList = db.Godowns.ToList();
                //Godown oGD = oGodownList.FirstOrDefault(o => o.GodownName == ctlProduct.GodownName);

                _StockDetailControl = (StockDetail)(db.StockDetails.FirstOrDefault(o => o.SDetailID == ctlProduct.SelectedID));
                if (_StockDetailControl != null)
                {
                    var oProduct = db.Products.FirstOrDefault(i => i.ProductID == _StockDetailControl.ProductID);
                    _StockControl = db.Stocks.FirstOrDefault(o => o.StockID == _StockDetailControl.StockID);

                    if (oProduct.ProductType == (int)EnumProductType.NoBarCode)
                    {
                        var Totalrturns = (from so in db.Returns
                                           join sod in db.ReturnDetails on so.ReturnID equals sod.ReturnID
                                           join sd in db.StockDetails on sod.SDetailID equals sd.SDetailID
                                           where (so.SupplierID == ctlSupplier.SelectedID && sod.ProductID == _StockControl.ProductID && sd.ColorID == _StockControl.ColorID)
                                           select new
                        {
                            so.ReturnDate,
                            sod.Quantity,
                            sod.UnitPrice
                        }).OrderByDescending(x => x.ReturnDate).ToList();

                        var TotalPurchases = (from po in db.POrders
                                              join pod in db.POrderDetails on po.POrderID equals pod.POrderID
                                              where (po.SupplierID == ctlSupplier.SelectedID && pod.ProductID == _StockControl.ProductID && po.Status == (int)EnumPurchaseType.Purchase && pod.ColorID == _StockDetailControl.ColorID)
                                              select new
                        {
                            po.OrderDate,
                            pod.Quantity,
                            UnitPrice = (pod.UnitPrice + ((po.LaborCost - po.TDiscount) / (po.GrandTotal - po.NetDiscount + po.TDiscount)) * pod.UnitPrice)
                        }).OrderByDescending(x => x.OrderDate).ToList();

                        var lastsale = TotalPurchases.FirstOrDefault();

                        decimal uPrice = lastsale != null?Convert.ToDecimal(lastsale.UnitPrice) : 0m;

                        if (_StockControl != null)
                        {
                            numSalesQty.Value = 0;
                            numStock.Value    = 0;
                            numQTY.Value      = 0;

                            numStock.Value     = _StockControl.Quantity; //_StockDetailControl.Quantity != null ? (decimal)_StockDetailControl.Quantity : 0m;
                            numUnitPrice.Value = uPrice;                 //_StockControl.PMPrice != null ? (decimal)_StockControl.PMPrice : 0;
                            INVENTORY.DA.Color oColor = _ColorList.FirstOrDefault(o => o.ColorID == _StockDetailControl.ColorID);

                            decimal saleqty   = 0;
                            decimal returnqty = 0;
                            if (TotalPurchases.Count > 0)
                            {
                                saleqty = (decimal)TotalPurchases.Sum(x => x.Quantity);
                            }
                            if (Totalrturns.Count > 0)
                            {
                                returnqty = (decimal)Totalrturns.Sum(x => x.Quantity);
                            }
                            numSalesQty.Value = saleqty - returnqty;
                            numQTY.Focus();
                            numUnitPrice.Enabled = true;
                            numQTY.Enabled       = true;
                        }
                    }
                    else
                    {
                        if (_StockControl != null)
                        {
                            var TotalPOrders = (from po in db.POrders
                                                join pod in db.POrderDetails on po.POrderID equals pod.POrderID
                                                where (po.SupplierID == ctlSupplier.SelectedID && pod.ProductID == _StockControl.ProductID && po.Status == (int)EnumSalesType.Sales && pod.ColorID == _StockDetailControl.ColorID)
                                                select new
                            {
                                po.OrderDate,
                                pod.Quantity,
                                SalesPrice = (pod.UnitPrice + ((po.LaborCost - po.TDiscount) / (po.GrandTotal - po.NetDiscount + po.TDiscount)) * pod.UnitPrice)
                            }).OrderByDescending(x => x.OrderDate).ToList();
                            var lastSOD = TotalPOrders.FirstOrDefault();
                            numSalesQty.Value = lastSOD.Quantity;
                            numStock.Value    = 0;
                            numQTY.Value      = 1;
                            numStock.Value    = _StockControl.Quantity != null ? (decimal)_StockControl.Quantity : 0m;

                            numUnitPrice.Value   = lastSOD != null ? lastSOD.SalesPrice : 0m;
                            numUnitPrice.Enabled = false;
                            numQTY.Enabled       = false;
                        }
                    }
                }
            }
            catch (Exception ex)
            {
                MessageBox.Show(ex.Message);
            }
        }
コード例 #11
0
        private void grdItems_MouseDoubleClick(object sender, MouseEventArgs e)
        {
            try
            {
                Category           oCategory    = null;
                Company            oCompany     = null;
                INVENTORY.DA.Color oColor       = null;
                ExpenseItem        oExpenseItem = null;
                Model oModel = null;

                int[]       selRows = ((GridView)grdItems.MainView).GetSelectedRows();
                DataRowView oID     = (DataRowView)(((GridView)grdItems.MainView).GetRow(selRows[0]));
                int         nID     = Convert.ToInt32(oID["ID"]);
                Bank        oBank   = null;

                if (nID > 0)
                {
                    if (_ObjectName == "Category")
                    {
                        this.Text       = "Part Control";
                        oCategory       = db.Categorys.FirstOrDefault(p => p.CategoryID == nID);
                        _ctl.SelectedID = oCategory.CategoryID;
                        _ctl.Code       = oCategory.Code;
                        _ctl.Name       = oCategory.Description;
                    }
                    else if (_ObjectName == "BCompany")
                    {
                        this.Text       = "Company Control";
                        oCompany        = db.Companies.FirstOrDefault(p => p.CompanyID == nID);
                        _ctl.SelectedID = oCompany.CompanyID;
                        _ctl.Code       = oCompany.Code;
                        _ctl.Name       = oCompany.Description;
                    }
                    else if (_ObjectName == "Color")
                    {
                        this.Text       = "Color Control";
                        oColor          = db.Colors.FirstOrDefault(p => p.ColorID == nID);
                        _ctl.SelectedID = oColor.ColorID;
                        _ctl.Code       = oColor.Code;
                        _ctl.Name       = oColor.Description;
                    }
                    else if (_ObjectName == "Model")
                    {
                        this.Text = "Employee Control";

                        oModel          = db.Models.FirstOrDefault(p => p.ModelID == nID);
                        _ctl.SelectedID = oModel.ModelID;
                        _ctl.Code       = oModel.Code;
                        _ctl.Name       = oModel.Description;
                    }
                    else if (_ObjectName == "Expense")
                    {
                        this.Text       = "Expense Control";
                        oExpenseItem    = db.ExpenseItems.FirstOrDefault(p => p.ExpenseItemID == nID);
                        _ctl.SelectedID = oExpenseItem.ExpenseItemID;
                        _ctl.Code       = oExpenseItem.Code;
                        _ctl.Name       = oExpenseItem.Description;
                    }
                    else if (_ObjectName == "IncomeOnly")
                    {
                        this.Text       = "Expense Control";
                        oExpenseItem    = db.ExpenseItems.FirstOrDefault(p => p.ExpenseItemID == nID);
                        _ctl.SelectedID = oExpenseItem.ExpenseItemID;
                        _ctl.Code       = oExpenseItem.Code;
                        _ctl.Name       = oExpenseItem.Description;
                    }
                    else if (_ObjectName == "ExpenseOnly")
                    {
                        this.Text       = "Expense Control";
                        oExpenseItem    = db.ExpenseItems.FirstOrDefault(p => p.ExpenseItemID == nID);
                        _ctl.SelectedID = oExpenseItem.ExpenseItemID;
                        _ctl.Code       = oExpenseItem.Code;
                        _ctl.Name       = oExpenseItem.Description;
                    }
                    else if (_ObjectName == "Bank")
                    {
                        this.Text       = "Bank Control";
                        oBank           = db.Banks.FirstOrDefault(p => p.BankID == nID);
                        _ctl.SelectedID = oBank.BankID;
                        _ctl.Code       = oBank.Code;
                        _ctl.Name       = oBank.BankName;
                    }
                }
                if (ItemChanged != null)
                {
                    ItemChanged();
                }
                this.Close();
            }
            catch (Exception ex)
            {
                MessageBox.Show(ex.Message);
            }
        }
コード例 #12
0
        private void btnSave_Click(object sender, EventArgs e)
        {
            try
            {
                if (!IsValid())
                {
                    return;
                }
                bool IsNew = false;
                using (DEWSRMEntities db = new DEWSRMEntities())
                {
                    if (_ColorInfo.ColorID <= 0)
                    {
                        if (txtDescription.Text.Length > 0)
                        {
                            INVENTORY.DA.Color oColorInfo = null;
                            oColorInfo = (INVENTORY.DA.Color)db.Colors.FirstOrDefault(o => o.Description.Trim().ToUpper() == txtDescription.Text.Trim().ToUpper());

                            if (oColorInfo != null)
                            {
                                MessageBox.Show("This Color already Exists.", "Duplicate Color", MessageBoxButtons.OK, MessageBoxIcon.Error);
                                txtDescription.Focus();
                                return;
                            }
                        }


                        RefreshObject();
                        _ColorInfo.ColorID = db.Colors.Count() > 0 ? db.Colors.Max(obj => obj.ColorID) + 1 : 1;
                        db.Colors.Add(_ColorInfo);
                        IsNew = true;
                    }
                    else
                    {
                        _ColorInfo = db.Colors.FirstOrDefault(obj => obj.ColorID == _ColorInfo.ColorID);
                        RefreshObject();
                    }

                    db.SaveChanges();
                    MessageBox.Show("Data saved successfully.", "Save Information", MessageBoxButtons.OK, MessageBoxIcon.Information);
                    if (!IsNew)
                    {
                        if (ItemChanged != null)
                        {
                            ItemChanged();
                        }
                        this.Close();
                    }
                    else
                    {
                        if (ItemChanged != null)
                        {
                            ItemChanged();
                        }
                        _ColorInfo = new INVENTORY.DA.Color();
                        RefreshValue();
                        txtCode.Text = GenerateColorCode();
                    }
                }
            }
            catch (Exception ex)
            {
                if (ex.InnerException == null)
                {
                    MessageBox.Show(ex.Message, "Failed to save", MessageBoxButtons.OK, MessageBoxIcon.Error);
                }
                else
                {
                    MessageBox.Show(ex.InnerException.Message, "Failed to save", MessageBoxButtons.OK, MessageBoxIcon.Error);
                }
            }
        }
コード例 #13
0
ファイル: fReturn.cs プロジェクト: AneeshLeen/InventoryRepo
        public void GenerateReturnInvoice(Return _Return)
        {
            if (_Return != null)
            {
                DataTable orderdDT = new DataTable();
                rptDataSet.dtInvoice1DataTable dt      = new rptDataSet.dtInvoice1DataTable();
                Customer                  customer     = _Return.Customer;
                List <Product>            products     = db.Products.ToList();
                List <StockDetail>        stockDetails = db.StockDetails.ToList();
                List <INVENTORY.DA.Color> colors       = db.Colors.ToList();
                Product            product             = null;
                INVENTORY.DA.Color color       = null;
                StockDetail        stockDetail = null;
                DataSet            ds          = new DataSet();

                foreach (ReturnDetail item in _Return.ReturnDetails)
                {
                    product     = products.FirstOrDefault(o => o.ProductID == item.ProductID);
                    stockDetail = stockDetails.FirstOrDefault(o => o.SDetailID == item.SDetailID);
                    color       = db.Colors.FirstOrDefault(o => o.ColorID == stockDetail.ColorID);
                    dt.Rows.Add(product.ProductName, product.Company.Description, product.Category.Description, color.Description, item.Quantity, "Pcs", item.UnitPrice, " 0 %", item.UTAmount, 0, 0);
                }
                orderdDT = dt.AsEnumerable().OrderBy(o => (String)o["ProductName"]).CopyToDataTable();

                dt.TableName = "rptDataSet_dtInvoice";
                ds.Tables.Add(dt);
                string                 embededResource = "INVENTORY.UI.RDLC.AMReturnInvoice.rdlc";
                ReportParameter        rParam          = new ReportParameter();
                List <ReportParameter> parameters      = new List <ReportParameter>();
                string                 sInwodTk        = Global.TakaFormat(Convert.ToDouble(_Return.GrandTotal));


                rParam = new ReportParameter("GTotal", _Return.GrandTotal.ToString());
                parameters.Add(rParam);

                rParam = new ReportParameter("Paid", _Return.PaidAmount.ToString());
                parameters.Add(rParam);

                rParam = new ReportParameter("CurrDue", _Return.Customer.TotalDue.ToString());
                parameters.Add(rParam);

                rParam = new ReportParameter("TDiscount", _Return.PaidAmount.ToString());//oOrder.TDAmount.ToString()
                parameters.Add(rParam);

                rParam = new ReportParameter("Total", _Return.PaidAmount.ToString());
                parameters.Add(rParam);

                rParam = new ReportParameter("PreDue", _Return.PaidAmount.ToString());
                parameters.Add(rParam);

                rParam = new ReportParameter("TotalDue", _Return.Customer.TotalDue.ToString());
                parameters.Add(rParam);

                rParam = new ReportParameter("InvoiceNo", _Return.InvoiceNo);
                parameters.Add(rParam);

                rParam = new ReportParameter("InvoiceDate", _Return.ReturnDate.ToString());
                parameters.Add(rParam);

                rParam = new ReportParameter("Company", _Return.Customer.CompanyName);
                parameters.Add(rParam);

                rParam = new ReportParameter("CAddress", _Return.Customer.Address);
                parameters.Add(rParam);

                rParam = new ReportParameter("Name", _Return.Customer.Name);
                parameters.Add(rParam);

                rParam = new ReportParameter("MobileNo", _Return.Customer.ContactNo);
                parameters.Add(rParam);

                rParam = new ReportParameter("PrintedBy", Global.CurrentUser.UserName);
                parameters.Add(rParam);

                rParam = new ReportParameter("LaborCost", _Return.PaidAmount.ToString());
                parameters.Add(rParam);

                rParam = new ReportParameter("JobNumber", "");
                parameters.Add(rParam);

                rParam = new ReportParameter("LessAmt", _Return.PaidAmount.ToString());
                parameters.Add(rParam);

                //rParam = new ReportParameter("Logo1", Application.StartupPath + @"\Logo1.bmp");
                //parameters.Add(rParam);

                rParam = new ReportParameter("InWordTK", sInwodTk);
                parameters.Add(rParam);

                fReportViewer frm = new fReportViewer();
                frm.CommonReportViewer(embededResource, ds, parameters, true);
            }
        }
コード例 #14
0
ファイル: fReturn.cs プロジェクト: AneeshLeen/InventoryRepo
        private void ctlProduct_SelectedItemChanged(object sender, EventArgs e)
        {
            try
            {
                //List<Godown> oGodownList = db.Godowns.ToList();
                //Godown oGD = oGodownList.FirstOrDefault(o => o.GodownName == ctlProduct.GodownName);

                _StockDetailControl = (StockDetail)(db.StockDetails.FirstOrDefault(o => o.SDetailID == ctlProduct.SelectedID));
                if (_StockDetailControl != null)
                {
                    var oProduct = db.Products.FirstOrDefault(i => i.ProductID == _StockDetailControl.ProductID);
                    _StockControl = db.Stocks.FirstOrDefault(o => o.StockID == _StockDetailControl.StockID);

                    //if (oProduct != null)
                    //    txtSize.Text ="";

                    if (oProduct.ProductType == (int)EnumProductType.NoBarCode)
                    {
                        var Totalrturns = (from sod in db.ReturnDetails
                                           from so in db.Returns
                                           where (so.ReturnID == sod.ReturnID && so.CustomerID == ctlCustomer.SelectedID && sod.ProductID == _StockControl.ProductID)
                                           select new { so.ReturnDate, sod.Quantity, sod.UnitPrice }).OrderByDescending(x => x.ReturnDate).ToList();

                        var TotalSales = (from sod in db.SOrderDetails
                                          from so in db.SOrders
                                          where (so.SOrderID == sod.SOrderID && so.CustomerID == ctlCustomer.SelectedID && sod.ProductID == _StockControl.ProductID && so.Status == (int)EnumSalesType.Sales)
                                          select new { so.InvoiceDate, sod.Quantity,
                                                       UnitPrice = ((sod.UnitPrice - sod.PPDAmount) + ((0 - so.TDAmount - so.Adjustment) / (so.GrandTotal - so.NetDiscount + so.TDAmount)) * (sod.UnitPrice - sod.PPDAmount)), }).OrderByDescending(x => x.InvoiceDate).ToList();

                        var lastsale = TotalSales.FirstOrDefault();

                        decimal uPrice = lastsale != null?Convert.ToDecimal(lastsale.UnitPrice) : 0m;

                        if (_StockControl != null)
                        {
                            numSalesQty.Value = 0;
                            numStock.Value    = 0;
                            numQTY.Value      = 0;

                            numStock.Value     = _StockDetailControl.Quantity != null ? (decimal)_StockDetailControl.Quantity : 0m;
                            numUnitPrice.Value = uPrice;//_StockControl.PMPrice != null ? (decimal)_StockControl.PMPrice : 0;
                            INVENTORY.DA.Color oColor = _ColorList.FirstOrDefault(o => o.ColorID == _StockDetailControl.ColorID);

                            //if (oColor != null)
                            //    txtColor.Text = oColor.Description;

                            decimal saleqty   = 0;
                            decimal returnqty = 0;
                            if (TotalSales.Count > 0)
                            {
                                saleqty = (decimal)TotalSales.Sum(x => x.Quantity);
                            }
                            if (Totalrturns.Count > 0)
                            {
                                returnqty = (decimal)Totalrturns.Sum(x => x.Quantity);
                            }
                            numSalesQty.Value = saleqty - returnqty;
                            numQTY.Focus();
                            numUnitPrice.Enabled = true;
                            numQTY.Enabled       = true;
                            //txtIMEI.TextChanged -= txtIMEI_TextChanged;
                            //txtIMEI.Text = _StockDetailControl.IMENO;
                            //txtIMEI.TextChanged += txtIMEI_TextChanged;
                        }
                    }
                    else
                    {
                        if (_StockControl != null)
                        {
                            var TotalSales = (from so in db.SOrders
                                              join sod in db.SOrderDetails on so.SOrderID equals sod.SOrderID
                                              where (so.CustomerID == ctlCustomer.SelectedID && sod.ProductID == _StockControl.ProductID && so.Status == (int)EnumSalesType.Sales && sod.StockDetailID == _StockDetailControl.SDetailID)
                                              select new
                            {
                                so.InvoiceDate,
                                sod.Quantity,
                                SalesPrice = ((sod.UnitPrice - sod.PPDAmount) + ((0 - so.TDAmount - so.Adjustment) / (so.GrandTotal - so.NetDiscount + so.TDAmount)) * (sod.UnitPrice - sod.PPDAmount)),
                            }).OrderByDescending(x => x.InvoiceDate).ToList();


                            var lastSOD = TotalSales.FirstOrDefault();

                            numSalesQty.Value = lastSOD.Quantity;
                            numStock.Value    = 0;
                            numQTY.Value      = 1;


                            numStock.Value       = _StockControl.Quantity != null ? (decimal)_StockControl.Quantity : 0m;
                            numUnitPrice.Value   = lastSOD != null ? lastSOD.SalesPrice : 0m;
                            numUnitPrice.Enabled = false;
                            numQTY.Enabled       = false;
                            //txtIMEI.TextChanged -= txtIMEI_TextChanged;
                            //txtIMEI.Text = _StockDetailControl.IMENO;
                            //txtIMEI.TextChanged += txtIMEI_TextChanged;
                        }
                    }
                }
            }
            catch (Exception ex)
            {
                MessageBox.Show(ex.Message);
            }
        }
コード例 #15
0
        private void Refresh()
        {
            try
            {
                using (DEWSRMEntities db = new DEWSRMEntities())
                {
                    if (ObjectName == "Company")
                    {
                        _Supplier = db.Suppliers.FirstOrDefault(o => o.SupplierID == SelectedID);
                        if (_Supplier == null)
                        {
                            _CID = 0;
                        }
                        else
                        {
                            _CID = _Supplier.SupplierID;
                        }

                        if (_Supplier != null)
                        {
                            txtCode.Text = _Supplier.Code;
                            txtName.Text = _Supplier.OwnerName;//_Supplier.Name;
                        }
                        else
                        {
                            txtCode.Text = "";
                            txtName.Text = "";
                        }
                    }
                    else if (ObjectName == "Customer")
                    {
                        _Customer = db.Customers.FirstOrDefault(o => o.CustomerID == SelectedID);
                        if (_Customer != null)
                        {
                            _CID         = _Customer.CustomerID;
                            txtCode.Text = _Customer.Code;
                            txtName.Text = _Customer.Name;
                        }
                        else
                        {
                            txtCode.Text = "";
                            txtName.Text = "";
                        }
                    }
                    else if (ObjectName == "Model")
                    {
                        _Model = db.Models.FirstOrDefault(o => o.ModelID == SelectedID);
                        if (_Model != null)
                        {
                            txtCode.Text = _Model.Code;
                            txtName.Text = _Model.Description;
                        }
                        else
                        {
                            txtCode.Text = "";
                            txtName.Text = "";
                        }
                    }
                    else if (ObjectName == "ReturnProduct")
                    {
                        StockDetail oSD = db.StockDetails.FirstOrDefault(o => o.SDetailID == SelectedID);

                        if (oSD != null)
                        {
                            _Product     = db.Products.FirstOrDefault(o => o.ProductID == oSD.Stock.ProductID);
                            txtCode.Text = _Product.Code;
                            txtName.Text = _Product.ProductName;
                        }
                        else
                        {
                            txtCode.Text = "";
                            txtName.Text = "";
                        }
                    }
                    else if (ObjectName == "Employee")
                    {
                        _Employee = db.Employees.FirstOrDefault(o => o.EmployeeID == SelectedID);
                        if (_Employee != null)
                        {
                            txtCode.Text = _Employee.Code;
                            txtName.Text = _Employee.Name;
                        }
                        else
                        {
                            txtCode.Text = "";
                            txtName.Text = "";
                        }
                    }
                    else if (ObjectName == "Product")
                    {
                        _Product = db.Products.FirstOrDefault(o => o.ProductID == SelectedID);
                        if (_Product != null)
                        {
                            txtCode.Text = _Product.Code;
                            txtName.Text = _Product.ProductName;
                        }
                        else
                        {
                            txtCode.Text = "";
                            txtName.Text = "";
                        }
                    }
                    else if (ObjectName == "OProduct")
                    {
                        _Product = db.Products.FirstOrDefault(o => o.ProductID == SelectedID);
                        if (_Product != null)
                        {
                            txtCode.Text = _Product.Code;
                            txtName.Text = _Product.ProductName;
                        }
                        else
                        {
                            txtCode.Text = "";
                            txtName.Text = "";
                        }
                    }
                    else if (ObjectName == "SPReport")
                    {
                        _Product = db.Products.FirstOrDefault(o => o.ProductID == SelectedID);
                        if (_Product != null)
                        {
                            txtCode.Text = _Product.Code;
                            txtName.Text = _Product.ProductName;
                        }
                        else
                        {
                            txtCode.Text = "";
                            txtName.Text = "";
                        }
                    }
                    else if (ObjectName == "CCompany")
                    {
                        _Supplier = db.Suppliers.FirstOrDefault(o => o.SupplierID == SelectedID);
                        if (_Supplier != null)
                        {
                            txtCode.Text = _Supplier.Code;
                            txtName.Text = _Supplier.OwnerName;//_Supplier.Name;
                        }
                        else
                        {
                            txtCode.Text = "";
                            txtName.Text = "";
                        }
                    }
                    else if (ObjectName == "IncomeOnly")
                    {
                        _ExpenseItem = db.ExpenseItems.FirstOrDefault(o => o.ExpenseItemID == SelectedID);
                        if (_ExpenseItem != null)
                        {
                            txtCode.Text = _ExpenseItem.Code;
                            txtName.Text = _ExpenseItem.Description;
                        }
                        else
                        {
                            txtCode.Text = "";
                            txtName.Text = "";
                        }
                    }
                    else if (ObjectName == "ExpenseOnly")
                    {
                        _ExpenseItem = db.ExpenseItems.FirstOrDefault(o => o.ExpenseItemID == SelectedID);
                        if (_ExpenseItem != null)
                        {
                            txtCode.Text = _ExpenseItem.Code;
                            txtName.Text = _ExpenseItem.Description;
                        }
                        else
                        {
                            txtCode.Text = "";
                            txtName.Text = "";
                        }
                    }
                    else if (ObjectName == "CCustomer")
                    {
                        _Customer = db.Customers.FirstOrDefault(o => o.CustomerID == SelectedID);
                        if (_Customer != null)
                        {
                            txtCode.Text = _Customer.Code;
                            txtName.Text = _Customer.Name;
                        }
                        else
                        {
                            txtCode.Text = "";
                            txtName.Text = "";
                        }
                    }
                    else if (ObjectName == "CreditCustomer")
                    {
                        _Customer = db.Customers.FirstOrDefault(o => o.CustomerID == SelectedID);
                        if (_Customer != null)
                        {
                            txtCode.Text = _Customer.Code;
                            txtName.Text = _Customer.Name;
                        }
                        else
                        {
                            txtCode.Text = "";
                            txtName.Text = "";
                        }
                    }
                    else if (ObjectName == "SReturn")
                    {
                        StockDetail OSD = db.StockDetails.FirstOrDefault(o => o.SDetailID == SelectedID);

                        if (OSD != null)
                        {
                            _Product = db.Products.FirstOrDefault(o => o.ProductID == OSD.ProductID);
                        }
                        else
                        {
                            _Product = null;
                        }


                        if (_Product != null)
                        {
                            txtCode.Text = _Product.Code;
                            txtName.Text = _Product.ProductName;
                        }
                        else
                        {
                            txtCode.Text = "";
                            txtName.Text = "";
                        }
                    }
                    else if (ObjectName == "PReturn")
                    {
                        StockDetail OSD = db.StockDetails.FirstOrDefault(o => o.SDetailID == SelectedID);

                        if (OSD != null)
                        {
                            _Product = db.Products.FirstOrDefault(o => o.ProductID == OSD.ProductID);
                        }
                        else
                        {
                            _Product = null;
                        }

                        if (_Product != null)
                        {
                            txtCode.Text = _Product.Code;
                            txtName.Text = _Product.ProductName;
                        }
                        else
                        {
                            txtCode.Text = "";
                            txtName.Text = "";
                        }
                    }
                    else if (ObjectName == "StockDetail")
                    {
                        StockDetail stockDetail = db.StockDetails.FirstOrDefault(o => o.SDetailID == SelectedID);
                        if (stockDetail != null)
                        {
                            txtName.Text = stockDetail.Product.ProductName;
                            txtCode.Text = stockDetail.Product.Code;
                        }
                        else
                        {
                            txtCode.Text = "";
                            txtName.Text = "";
                        }
                    }
                    else if (ObjectName == "Category")
                    {
                        _Category = db.Categorys.FirstOrDefault(o => o.CategoryID == SelectedID);
                        if (_Category != null)
                        {
                            txtCode.Text = _Category.Code;
                            txtName.Text = _Category.Description;
                        }
                        else
                        {
                            txtCode.Text = "";
                            txtName.Text = "";
                        }
                    }
                    else if (ObjectName == "BCompany")
                    {
                        _Company = db.Companies.FirstOrDefault(o => o.CompanyID == SelectedID);
                        if (_Company != null)
                        {
                            txtCode.Text = _Company.Code;
                            txtName.Text = _Company.Description;
                        }
                        else
                        {
                            txtCode.Text = "";
                            txtName.Text = "";
                        }
                    }
                    else if (ObjectName == "Color")
                    {
                        _Color = db.Colors.FirstOrDefault(o => o.ColorID == SelectedID);
                        if (_Color != null)
                        {
                            txtCode.Text = _Color.Code;
                            txtName.Text = _Color.Description;
                        }
                        else
                        {
                            txtCode.Text = "";
                            txtName.Text = "";
                        }
                    }
                    else if (ObjectName == "FAsset")
                    {
                        _ShareInvestment = db.ShareInvestmentHeads.FirstOrDefault(o => o.SIHID == SelectedID);
                        if (_ShareInvestment != null)
                        {
                            txtCode.Text = _ShareInvestment.Code;
                            txtName.Text = _ShareInvestment.Name;
                        }
                        else
                        {
                            txtCode.Text = "";
                            txtName.Text = "";
                        }
                    }
                    else if (ObjectName == "CAsset")
                    {
                        _ShareInvestment = db.ShareInvestmentHeads.FirstOrDefault(o => o.SIHID == SelectedID);
                        if (_ShareInvestment != null)
                        {
                            txtCode.Text = _ShareInvestment.Code;
                            txtName.Text = _ShareInvestment.Name;
                        }
                        else
                        {
                            txtCode.Text = "";
                            txtName.Text = "";
                        }
                    }
                    else if (ObjectName == "LReceive")
                    {
                        _ShareInvestment = db.ShareInvestmentHeads.FirstOrDefault(o => o.SIHID == SelectedID);
                        if (_ShareInvestment != null)
                        {
                            txtCode.Text = _ShareInvestment.Code;
                            txtName.Text = _ShareInvestment.Name;
                        }
                        else
                        {
                            txtCode.Text = "";
                            txtName.Text = "";
                        }
                    }
                    else if (ObjectName == "LPay")
                    {
                        _ShareInvestment = db.ShareInvestmentHeads.FirstOrDefault(o => o.SIHID == SelectedID);
                        if (_ShareInvestment != null)
                        {
                            txtCode.Text = _ShareInvestment.Code;
                            txtName.Text = _ShareInvestment.Name;
                        }
                        else
                        {
                            txtCode.Text = "";
                            txtName.Text = "";
                        }
                    }
                    else if (ObjectName == "Liability")
                    {
                        _ShareInvestment = db.ShareInvestmentHeads.FirstOrDefault(o => o.SIHID == SelectedID);
                        if (_ShareInvestment != null)
                        {
                            txtCode.Text = _ShareInvestment.Code;
                            txtName.Text = _ShareInvestment.Name;
                        }
                        else
                        {
                            txtCode.Text = "";
                            txtName.Text = "";
                        }
                    }
                    else if (ObjectName == "Expense")
                    {
                        _ExpenseItem = db.ExpenseItems.FirstOrDefault(o => o.ExpenseItemID == SelectedID);
                        if (_ExpenseItem != null)
                        {
                            txtCode.Text = _ExpenseItem.Code;
                            txtName.Text = _ExpenseItem.Description;
                        }
                        else
                        {
                            txtCode.Text = "";
                            txtName.Text = "";
                        }
                    }
                    else if (ObjectName == "Godown")
                    {
                        _Godown = db.Godowns.FirstOrDefault(o => o.GodownID == SelectedID);
                        if (_Godown != null)
                        {
                            txtCode.Text = _Godown.GodownCode;
                            txtName.Text = _Godown.GodownName;
                        }
                        else
                        {
                            txtCode.Text = "";
                            txtName.Text = "";
                        }
                    }
                    else if (ObjectName == "MSCustomer")
                    {
                        if (_IDList == null)
                        {
                            txtCode.Text = "";
                            txtName.Text = "";
                        }
                        else
                        {
                            txtCode.Text = "00000";
                            txtName.Text = "Selected Total:" + _IDList.Count().ToString();
                        }
                    }
                    else if (ObjectName == "Bank")
                    {
                        _BankInfo = db.Banks.FirstOrDefault(o => o.BankID == SelectedID);
                        if (_BankInfo != null)
                        {
                            BankID       = _BankInfo.BankID;
                            txtCode.Text = _BankInfo.Code;
                            txtName.Text = _BankInfo.BankName + "," + _BankInfo.AccountNo;
                        }
                        else
                        {
                            txtCode.Text = "";
                            txtName.Text = "";
                        }
                    }
                }
            }
            catch (Exception ex)
            {
                MessageBox.Show(ex.Message, "Error", MessageBoxButtons.OK, MessageBoxIcon.Error);
            }
        }