public bool BuyProduct(PurchaseDetails purchase)
        {
            var products  = _productRepo.GetAllProducts().ToList();
            var customers = _customerRepo.GetAllCustomers().ToList();

            if (!_purchaseservice.IsProductExists(products, purchase))
            {
                return(false);
                // return "Selected Product not existed";
            }
            else if (!_purchaseservice.IsCustomerExists(customers, purchase))
            {
                return(false);
                // return "Selected CUstomer not existed";
            }
            else if (!_purchaseservice.IsProductQuantityAvilable(products, purchase))
            {
                return(false);
                // return "Selected producted already sold out";
            }
            _purchaseservice.CalculatePrice(customers, products, purchase);
            _purchaseRepo.Addpurchase(purchase);
            var product = products.Find(p => p.Id == purchase.ProductId);

            product.Quantity = product.Quantity - purchase.Quantity;
            _productRepo.Update(product);
            return(true);
        }
Ejemplo n.º 2
0
        public ActionResult EditPurchaseDetails(PurchaseDetailsViewModel purchaseDetailsViewModel)
        {
            string message = "";

            PurchaseDetails purchaseDetails = Mapper.Map <PurchaseDetails>(purchaseDetailsViewModel);

            purchaseDetailsViewModel.CategorySelectListItems = _categoryManager
                                                               .GetAll()
                                                               .Select(c => new SelectListItem()
            {
                Value = c.Id.ToString(),
                Text  = c.Name
            }).ToList();
            ViewBag.CategoryId = purchaseDetailsViewModel.CategorySelectListItems;


            if (_purchaseManager.Update(purchaseDetails))
            {
                message = "Updated Successfully..";
            }
            else
            {
                message = "No Change Your Update Information";
            }

            purchaseDetailsViewModel.PurchaseDetails = _purchaseManager.GetAll().Where(c => c.Id == purchaseDetailsViewModel.Id).ToList();
            ViewBag.Message = message;
            return(View(purchaseDetailsViewModel));
        }
        public List <PurchaseDetails> GetAllPurchaseDetails(string Invoice)
        {
            var    _PurchaseDetailsList = new List <PurchaseDetails>();
            string query  = ("Select *from PurchaseDetails where Invoice='" + Invoice + "' ");
            var    reader = _MainRepository.Reader(query, _MainRepository.ConnectionString());

            if (reader.HasRows)
            {
                while (reader.Read())
                {
                    var _PurchaseDetails = new PurchaseDetails();
                    _PurchaseDetails.Id               = Convert.ToInt32(reader["Id"].ToString());
                    _PurchaseDetails.ProductCode      = reader["ProductCode"].ToString();
                    _PurchaseDetails.ManufacturedDate = (reader["ManufacturedDate"].ToString());
                    _PurchaseDetails.ExpireDate       = (reader["ExpireDate"].ToString());
                    _PurchaseDetails.Qty              = Convert.ToDecimal(reader["Qty"].ToString());
                    _PurchaseDetails.UnitPrice        = Convert.ToDecimal(reader["UnitPrice"].ToString());
                    _PurchaseDetails.TotalPrice       = Convert.ToDecimal(reader["TotalPrice"].ToString());
                    _PurchaseDetails.NewMrp           = Convert.ToDecimal(reader["NewMrp"].ToString());

                    _PurchaseDetailsList.Add(_PurchaseDetails);
                }
            }
            reader.Close();

            return(_PurchaseDetailsList);
        }
        protected void AddButton_Click(object sender, EventArgs e)
        {
            try
            {
                PurchaseDetails _PurchaseDetails = new PurchaseDetails();
                _PurchaseDetails.ProductCode      = txtCode.Text;
                _PurchaseDetails.ManufacturedDate = Convert.ToDateTime(txtManufacturedDate.Text).ToShortDateString();
                _PurchaseDetails.ExpireDate       = Convert.ToDateTime(txtExpireDate.Text).ToShortDateString();
                _PurchaseDetails.Qty        = Convert.ToDecimal(txtQty.Text);
                _PurchaseDetails.UnitPrice  = Convert.ToDecimal(txtUnitPrice.Text);
                _PurchaseDetails.TotalPrice = Convert.ToDecimal(txtTotalPrice.Text);
                _PurchaseDetails.NewMrp     = Convert.ToDecimal(txtMrp.Text);
                _PurchaseDetails.Invoice    = txtInvoice.Text;

                int successAdd = _PurchaseRepository.Add(_PurchaseDetails);
                if (successAdd > 0)
                {
                    LoadPurchaseDetails();
                }
                else
                {
                }
            }
            catch
            {
            }
        }
Ejemplo n.º 5
0
        public bool UniquePurchaseCode(PurchaseDetails purchaseDetails)
        {
            bool exists = false;

            //Connection

            using (SqlConnection sqlConnection = new SqlConnection(_connectionString))
            {
                //Command
                string     commandString = @"SELECT InvoiceNo FROM PurchaseDetails  WHERE InvoiceNo = '" + purchaseDetails.InvoiceNo + "'  ";
                SqlCommand sqlCommand    = new SqlCommand(commandString, sqlConnection);

                SqlDataAdapter sqlDataAdapter = new SqlDataAdapter(sqlCommand);
                DataTable      dataTable      = new DataTable();
                sqlDataAdapter.Fill(dataTable);
                //showDataGridView.DataSource = dataTable;

                //Close
                sqlConnection.Close();
                if (dataTable.Rows.Count > 0)
                {
                    exists = true;
                }
                sqlConnection.Close();
            }
            return(exists);
        }
Ejemplo n.º 6
0
        public List <PurchaseDetails> Read()
        {
            var data = new List <Purchase>();

            try
            {
                data = _context.Purchases.ToList();
            }
            catch (Exception ex)
            {
                throw new Exception($"{ex.Message}");
            }
            var rData = new List <PurchaseDetails>();

            foreach (var rec in data)
            {
                var purchaseDetail = new PurchaseDetails()
                {
                    ID          = rec.ID,
                    Email       = _context.Customers.FirstOrDefault(a => rec.UserID == a.ID).Email,
                    ProductName = _context.Products.FirstOrDefault(a => rec.ProductID == a.ID).Name
                };
                rData.Add(purchaseDetail);
            }
            return(rData);
        }
Ejemplo n.º 7
0
        public virtual void AddPurchaseDetails(Item item, long qty, decimal rate, decimal salesRate)
        {
            var amount = qty * rate;

            PurchaseDetails.Add(new PurchaseDetail(this, item, qty, rate, salesRate));
            Calculate(amount);
        }
        public  IActionResult Add(purchasesummaryviewmodel allpurchase)
       {
            PurchaseSummary sum = new PurchaseSummary();
            sum.sup_id = allpurchase.sup_id;
            sum.total = allpurchase.total_amount;
            sum.discount = allpurchase.discount;
            sum.vat = allpurchase.vat;
            sum.net_total = allpurchase.netamount;
            _context.Add(sum);
            _context.SaveChanges();
           
          foreach(var purchasedetail in allpurchase.purchase_details)
           {

                PurchaseDetails details = new PurchaseDetails();
                details.pch_id = sum.pch_id;
                details.product_id = purchasedetail.product_id;
                details.qty = purchasedetail.qty;
                details.price = purchasedetail.price;
                details.total = purchasedetail.total;

                _context.Add(details);
                Product Prdt = _context.products.Find(details.product_id);
                Prdt.qty = Prdt.qty + details.qty;
                _context.products.Update(Prdt);
                _context.SaveChanges();

            }
            return Json(new { id = sum.pch_id });
       }
        public List <PurchaseDetails> RetrievePurchaseDetailsByUser(int id)
        {
            var purchaseList = new List <PurchaseDetails>();

            try
            {
                var purchases = MarketEntryAccessor.RetrievePurchasesByUser(id);
                foreach (Purchase e in purchases)
                {
                    var marketEntry       = MarketEntryAccessor.RetrieveMarketEntryById(e.MarketEntryID);
                    var marketEntryDetail = new MarketEntryDetails()
                    {
                        MarketEntry     = marketEntry,
                        User            = UserAccessor.RetrieveUserByMarketEntryID(marketEntry.MarketEntryID),
                        CollectionEntry = CollectionAccessor.RetrieveCollectionEntryByID(marketEntry.CollectionEntryID)
                    };
                    var purhcase = new PurchaseDetails()
                    {
                        MarketEntryDetails = marketEntryDetail,
                        User = UserAccessor.RetrieveUserById(e.UserID)
                    };
                    purchaseList.Add(purhcase);
                }
            }
            catch (Exception)
            {
                throw;
            }


            return(purchaseList);
        }
Ejemplo n.º 10
0
        public List <PurchaseDetails> PurchasesDetailsRecord(int purchaseId)
        {
            List <PurchaseDetails> purchaseDetails = new List <PurchaseDetails>();

            connection = new Connection();
            string query = @"Select * From PurchaseDetailsRecord  where PurchaseID='" + purchaseId + "'";

            sqlCommand = new SqlCommand(query, connection.GetConnection());


            reader = sqlCommand.ExecuteReader();
            while (reader.Read())
            {
                PurchaseDetails purchaseDetail = new PurchaseDetails();
                //purchaseDetail.PurchaseID = Convert.ToInt32(reader["ID"]);
                purchaseDetail.ProductName     = reader["Name"].ToString();
                purchaseDetail.ProductCode     = reader["Code"].ToString();
                purchaseDetail.ManufactureDate = Convert.ToDateTime(reader["ManufactureDate"].ToString());
                purchaseDetail.ExpireDate      = Convert.ToDateTime(reader["ExpireDate"].ToString());
                purchaseDetail.Quantity        = Convert.ToDouble(reader["Quantity"]);
                purchaseDetail.UnitPrice       = Convert.ToDouble(reader["UnitPrice"]);
                purchaseDetail.TotalPrice      = Convert.ToDouble(reader["TotalPrice"]);
                purchaseDetail.MRP             = Convert.ToDouble(reader["MRP"]);
                purchaseDetail.Remark          = reader["Remark"].ToString();
                purchaseDetails.Add(purchaseDetail);
            }
            connection.GetClose();
            return(purchaseDetails);
        }
        public bool AddPurchaseDetails(PurchaseDetails purchaseDetails)
        {
            bool isAdded = false;

            using (SqlConnection sqlConnection = new SqlConnection(_connectionString))
            { //open connection
                sqlConnection.Open();

                //string queryString = @"INSERT INTO Purchases VALUES('" + purchase.Date + "','" + purchase.InvoiceNo + "'," + purchase.SupplierId + "," + purchase.ProductId + ",'" + purchase.Code + "','" + purchase.ManufacturedDate + "','" + purchase.ExpireDate + "'," + purchase.Quantity + "," + purchase.UnitPrice + "," + purchase.TotalPrice + "," + purchase.MRP + ",'" + purchase.Remarks + "');";
                string     queryString = @"INSERT INTO PurchaseDetails VALUES('" + purchaseDetails.Date + "','" + purchaseDetails.InvoiceNo + "','" + purchaseDetails.Code + "'," + purchaseDetails.SupplierId + ")";
                SqlCommand sqlCommand  = new SqlCommand(queryString, sqlConnection);


                int isExecuted = sqlCommand.ExecuteNonQuery();


                if (isExecuted > 0)
                {
                    isAdded = true;
                }

                //close connection
                sqlConnection.Close();
            }

            return(isAdded);
        }
Ejemplo n.º 12
0
        private void AddButton_Click(object sender, EventArgs e)
        {
            int status          = 1;
            var purchaseDetails = new PurchaseDetails();


            foreach (var p in _purchasesDetails)
            {
                if (p.ProductCode.Contains(codeTextBox.Text))
                {
                    MessageBox.Show("Product already in list");
                    status = 0;
                }
            }
            purchaseDetails.ProductID  = Convert.ToInt32(productComboBox.SelectedValue);
            purchaseDetails.CategoryID = Convert.ToInt32(categoryComboBox.SelectedValue);

            purchaseDetails.ProductCode     = codeTextBox.Text;
            purchaseDetails.ManufactureDate = Convert.ToDateTime(manufactureDateTimePicker.Text);
            purchaseDetails.ExpireDate      = Convert.ToDateTime(expiredDateTimePicker.Text);
            purchaseDetails.Quantity        = Convert.ToDouble(quantityTextBox.Text);
            purchaseDetails.UnitPrice       = Convert.ToDouble(unitPriceTextBox.Text);
            purchaseDetails.MRP             = Convert.ToDouble(MRPTextBox.Text);
            purchaseDetails.Remark          = remarkTextBox.Text;
            purchaseDetails.TotalPrice      = Convert.ToDouble(totalPriceTextBox.Text);

            if (status == 1)
            {
                _purchasesDetails.Add(purchaseDetails);
                displayDataGridView.Rows.Clear();
                ShowList(_purchasesDetails);
            }
        }
Ejemplo n.º 13
0
        public List <PurchaseDetails> GetAllPurchaseDetails(string id)
        {
            var    _PurchaseDetaillist = new List <PurchaseDetails>();
            string query  = ("Select *From PurchaseDetails Where PurchaseId='" + id + "'");
            var    reader = _MainRepository.Reader(query, _MainRepository.ConnectionString());

            if (reader.HasRows)
            {
                while (reader.Read())
                {
                    var _PurchaseDetails = new PurchaseDetails();
                    _PurchaseDetails.PurchaseId   = reader["PurchaseId"].ToString();
                    _PurchaseDetails.Item         = reader["Item"].ToString();
                    _PurchaseDetails.Batch        = Convert.ToInt32(reader["Batch"].ToString());
                    _PurchaseDetails.Qty          = Convert.ToDecimal(reader["Qty"].ToString());
                    _PurchaseDetails.CostPrice    = Convert.ToDecimal(reader["CostPrice"].ToString());
                    _PurchaseDetails.TotalPrice   = Convert.ToDecimal(reader["TotalPrice"].ToString());
                    _PurchaseDetails.SellingPrice = Convert.ToDecimal(reader["SellingPrice"].ToString());
                    _PurchaseDetails.Expire       = reader["Expire"].ToString();

                    _PurchaseDetaillist.Add(_PurchaseDetails);
                }
            }
            reader.Close();

            return(_PurchaseDetaillist);
        }
        public ActionResult PurchaseAdd(PurchaseDetails purchaseDetails)
        {
            //string message = "";

            //message += "Date: " + purchaseDetails.Date;
            //message += "BillInvoice: " + purchaseDetails.BillInvoice;
            //message += "SupplierName: " + purchaseDetails.SupplierName;
            //message += "Category: " + purchaseDetails.Category;
            //message += "Products: " + purchaseDetails.Products;

            //message += "Code: " + purchaseDetails.Code;
            //message += "AvailableQuantity: " + purchaseDetails.AvailableQuantity;
            //message += "ManufacturedDate: " + purchaseDetails.ManufacturedDate;
            //message += "ExpireDate: " + purchaseDetails.ExpireDate;
            //message += "Remarks: " + purchaseDetails.Remarks;
            //message += "Quantity: " + purchaseDetails.Quantity;
            //message += "UnitPrice: " + purchaseDetails.UnitPrice;
            //message += "TotalPrice: " + purchaseDetails.TotalPrice;
            //message += "PreviousUnitPrice: " + purchaseDetails.PreviousUnitPrice;
            //message += "PreviousMrp: " + purchaseDetails.PreviousMRP;
            //message += "MRP: " + purchaseDetails.MRP;
            //return message;
            //if (_purchaseManager.SaveInfo(purchaseDetails))
            //{
            //  string  message += "Saved!";
            //}
            //else
            //{
            //    string message += "Not Saved!";
            //}
            _purchaseManager.SaveInfo(purchaseDetails);
            return(View());
        }
Ejemplo n.º 15
0
        private ReturnMethod validateReturn(PurchaseDetails purchaseDetail)
        {
            //Stored Procedure to validate
            ReturnMethod returnMethod = Repository.Instance.ValidateReturn(purchaseDetail, _context.Database.GetDbConnection().ConnectionString);

            return(returnMethod);
        }
Ejemplo n.º 16
0
        public List <PurchaseDetails> GetPdfPurchaseDetails(string id)
        {
            var    _PurchaseDetaillist = new List <PurchaseDetails>();
            string query  = ("Select Item,Batch,Qty,CostPrice,TotalPrice,Expire from PurchaseDetails where PurchaseId='" + id + "'");
            var    reader = _pharmaDb.Reader(query, _pharmaDb.ConnectionStrings());

            if (reader.HasRows)
            {
                while (reader.Read())
                {
                    var _PurchaseDetails = new PurchaseDetails();
                    _PurchaseDetails.Item       = reader["Item"].ToString();
                    _PurchaseDetails.Batch      = Convert.ToInt32(reader["Batch"].ToString());
                    _PurchaseDetails.Qty        = Convert.ToDecimal(reader["Qty"].ToString());
                    _PurchaseDetails.CostPrice  = Convert.ToDecimal(reader["CostPrice"].ToString());
                    _PurchaseDetails.TotalPrice = Convert.ToDecimal(reader["TotalPrice"].ToString());
                    _PurchaseDetails.Expire     = reader["Expire"].ToString();

                    _PurchaseDetaillist.Add(_PurchaseDetails);
                }
            }
            reader.Close();

            return(_PurchaseDetaillist);
        }
Ejemplo n.º 17
0
        private JsonTransactionResponse _GetUrl(PurchaseDetails pd)
        {
            // Fill in the JSON parameters (use the corresponding documents to determine the parameters needed for your unique payment page).
            var jsonTransactionRequest = new JsonTransactionDetails()
            {
                terminal = "0962210",
                user     = "******",
                password = "******",
                GoodURL  = CommonHelper.GetBaseUrl() + Url.Action("ResFromPlecard"),
                ErrorURL = CommonHelper.GetBaseUrl() + Url.Action("ResFromPlecard"),
                FeedbackDataTransferMethod = "POST",
                CssURL   = CommonHelper.GetBaseUrl() + "/TemplatesContent/bootstrap/css/customPele.css",
                UserKey  = Guid.NewGuid().ToString(),
                Total    = ((int)(pd.Cost * 100)).ToString(),
                UserData = new UserData()
                {
                    UserData1 = string.Format("שם לקוח:{0}", pd.Customer.UserName),
                    UserData2 = string.Format("מזהה לקוח:{0}", pd.Customer.Id),
                    UserData3 = string.Format("שם יצירה:{0}", pd.Music.HebrewName),
                    UserData4 = string.Format("שימוש:{0}", string.Join(",", pd.PermissionValueNames.ToArray())),
                    UserData5 = pd.Music.HebrewName,
                    UserData6 = string.Join(",", pd.PermissionValueNames.ToArray()),
                    UserData7 = pd.Music.ID.ToString(),
                    UserData8 = pd.Permission.ID.ToString()
                }
            };

            return(PostJson <JsonTransactionDetails, JsonTransactionResponse>(jsonTransactionRequest,
                                                                              "https://gateway20.pelecard.biz/PaymentGW/Init"));
        }
Ejemplo n.º 18
0
 internal static void RaiseOnSuccess(PurchaseDetails purchaseDetails)
 {
     if (OnSuccess != null)
     {
         OnSuccess (purchaseDetails);
     }
 }
Ejemplo n.º 19
0
 internal static void RaiseOnRestore(PurchaseDetails purchaseDetails)
 {
     if (OnRestore != null)
     {
         OnRestore (purchaseDetails);
     }
 }
Ejemplo n.º 20
0
    protected void gvPurchasing_RowDeleting(object sender, GridViewDeleteEventArgs e)
    {
        PurchaseDetails _objdcd = new PurchaseDetails();

        purchaseDid = Convert.ToInt32(((Label)gvPurchasing.Rows[e.RowIndex].FindControl("lblpdetailid")).Text);

        try
        {
            if (purchaseDid != 0)
            {
                _objdcd.PurchaseDetailId = purchaseDid;
                _objdcd.IsActive         = false;
                _objdcd.Isdeleted        = true;
                _objdcd.Amount           = 0;
                _objdcd.Rate             = 0;
                _objdcd.Discount         = 0;
                _objdcd.Quantity         = Convert.ToInt32(((TextBox)gvPurchasing.Rows[e.RowIndex].FindControl("lblQuantity")).Text);
                _objdcd.UpdatedBy        = Session["UserName"].ToString();
                _objdcd.Delete();
            }
            DataTable dt1 = new DataTable();
            dt1 = (DataTable)Session["tempdata"];
            dt1.Rows[e.RowIndex].Delete();
            gvPurchasing.DataSource = dt1;
            gvPurchasing.DataBind();
            Session["tempdata"] = dt1;
        }
        catch
        {
        }
    }
        public List <PurchaseDetails> GetAllPurchaseDetails()
        {
            List <PurchaseDetails> purchaseDetails = new List <PurchaseDetails>();

            using (SqlConnection sqlConnection = new SqlConnection(_connectionString))
            {
                string     queryString = @"SELECT p.Id,p.SupplierId,p.[Date],p.InvoiceNo,p.Code, s.Name As Supplier FROM PurchaseDetails AS p LEFT JOIN Suppliers AS s ON s.Id=p.SupplierId ORDER BY p.Id DESC";
                SqlCommand sqlCmd      = new SqlCommand(queryString, sqlConnection);

                //open connection
                sqlConnection.Open();

                SqlDataReader sqlDataReader = sqlCmd.ExecuteReader();

                while (sqlDataReader.Read())
                {
                    PurchaseDetails purchaseDetail = new PurchaseDetails();

                    purchaseDetail.Id         = Convert.ToInt32(sqlDataReader["Id"]);
                    purchaseDetail.Date       = sqlDataReader["Date"].ToString();
                    purchaseDetail.InvoiceNo  = sqlDataReader["InvoiceNo"].ToString();
                    purchaseDetail.Code       = sqlDataReader["Code"].ToString();
                    purchaseDetail.SupplierId = Convert.ToInt32(sqlDataReader["SupplierId"]);
                    purchaseDetail.Supplier   = sqlDataReader["Supplier"].ToString();

                    purchaseDetails.Add(purchaseDetail);
                }

                //close connection
                sqlConnection.Close();

                return(purchaseDetails);
            }
        }
Ejemplo n.º 22
0
        public void CanAddPurchase()
        {
            var purchase = new PurchaseDetails();

            purchase.Name          = "Andrew Galvin";
            purchase.Email         = "*****@*****.**";
            purchase.Street1       = "20 Stable Court";
            purchase.City          = "Wilmington";
            purchase.State         = "DE";
            purchase.ZipCode       = "19803";
            purchase.PurchasePrice = 17995;
            purchase.PurchaseType  = "Cash";
            purchase.UserID        = "00000000-0000-0000-0000-000000000000";

            var repo = new VehicleRepositoryADO();
            int id   = 3;

            repo.Purchase(purchase, id);

            Assert.AreEqual(2, purchase.PurchaseID);

            var vehicle = repo.GetDetails(id);

            Assert.AreEqual(2, vehicle.PurchaseID);
        }
    public void SaveDetails(int DocNo)
    {
        try
        {
            if (Session["UserName"] != null)
            {
                PurchaseDetails pd = new PurchaseDetails();

                pd.PurchaseMasterID = DocNo;
                pd.CreatedBy        = Session["UserName"].ToString();
                foreach (GridViewRow gv in gvPurchasing.Rows)
                {
                    pd.IsActive         = Convert.ToBoolean(true);
                    pd.PurchaseDetailId = Convert.ToInt32(((Label)gv.FindControl("lblpdetailid")).Text);
                    pd.Code             = ((Label)gv.FindControl("lblCode")).Text;
                    pd.Description      = ((Label)gv.FindControl("lblName")).Text;
                    pd.Quantity         = Convert.ToInt32(((TextBox)gv.FindControl("lblQuantity")).Text);
                    pd.Rate             = Convert.ToDecimal(((TextBox)gv.FindControl("lblRate")).Text);
                    pd.Per         = ((Label)gv.FindControl("lblRemarksave")).Text;
                    pd.Standard    = ((Label)gv.FindControl("lblstandard")).Text;
                    pd.Discount    = Convert.ToDecimal(((TextBox)gv.FindControl("lblDisc")).Text);
                    pd.Amount      = Convert.ToDecimal(((Label)gv.FindControl("lblAmount")).Text);
                    pd.OriQuantity = Convert.ToInt32(((Label)gv.FindControl("lblqtyactual")).Text);
                    pd.UpdatedBy   = strFY.ToString();
                    pd.Save(1);
                }
            }
        }
        catch
        { }
    }
Ejemplo n.º 24
0
 private void BtnInsertUpdatePurchase_Click(object sender, EventArgs e)
 {
     try
     {
         string ResultMessage = ValidateHeaderControlles();
         if (!string.IsNullOrEmpty(ResultMessage))
         {
             messageShow.singlemsgtext(ResultMessage);
             return;
         }
         var purchase_details = new PurchaseDetails
         {
             PurchaseId        = 0,
             PurchaseInvoiceNo = TxtInvoiceNo.Text.ToString(),
             SupplierCode      = Convert.ToInt32(((KeyValuePair <string, string>)DropDownSupplierMobNo.SelectedItem).Key.ToString()),
             NetAmount         = Convert.ToDouble(TxtNetAmountPurchase.Text.ToString()),
             PaymentType       = Convert.ToInt32(((KeyValuePair <string, string>)DropDownPaymentType.SelectedItem).Key.ToString()),
             PaidAmount        = Convert.ToDouble(TxtPaidAmount.Text.ToString()),
             DuesAmount        = Convert.ToDouble(TxtDuesAmount.Text.ToString()),
             DtPurchaseDetails = DataGridViewToDataTable(),
             OperationType     = 1
         };
         int id = _PurchaseRepository.InsertUpdatePurchaseDetails(purchase_details);
         if (id > 0)
         {
             messageShow.singlemsgtext("Sccessfully purchased the product.");
             EmptyDataGridAndHeader();
         }
     }
     catch (Exception _exception)
     {
         CmC.InsertException(_exception);
         messageShow.singlemsgtext(CmC.ExceptionErrorMessage);
     }
 }
Ejemplo n.º 25
0
        public async Task <ActionResult <PurchaseDetails> > PostPurchaseDetails(PurchaseDetails purchaseDetails)
        {
            _context.Purchase_Details.Add(purchaseDetails);
            await _context.SaveChangesAsync();

            return(CreatedAtAction("GetPurchaseDetails", new { id = purchaseDetails.ID }, purchaseDetails));
        }
Ejemplo n.º 26
0
        public async Task <IActionResult> PutPurchaseDetails(int id, PurchaseDetails purchaseDetails)
        {
            if (id != purchaseDetails.ID)
            {
                return(BadRequest());
            }

            _context.Entry(purchaseDetails).State = EntityState.Modified;

            try
            {
                await _context.SaveChangesAsync();
            }
            catch (DbUpdateConcurrencyException)
            {
                if (!PurchaseDetailsExists(id))
                {
                    return(NotFound());
                }
                else
                {
                    throw;
                }
            }

            return(NoContent());
        }
Ejemplo n.º 27
0
 public frmCompletePurchase(CollectionManager colMgr, MarketEntryManager marketEMgr, User user, PurchaseDetails purchaseDetails)
 {
     this._collectionManager  = colMgr;
     this._marketEntryManager = marketEMgr;
     this._user            = user;
     this._purchaseDetails = purchaseDetails;
     InitializeComponent();
 }
Ejemplo n.º 28
0
        public ActionResult DeleteConfirmed(int id)
        {
            PurchaseDetails purchaseDetails = db.PurchaseDetail.Find(id);

            db.PurchaseDetail.Remove(purchaseDetails);
            db.SaveChanges();
            return(RedirectToAction("Index"));
        }
Ejemplo n.º 29
0
        // retrieve values from database
        private void LoadFromID()
        {
            PurchaseData    dao     = new PurchaseData(ConnStr);
            PurchaseDetails details = dao.RetrieveDetails(Id);

            UserId    = details.UserId;
            ProductId = details.ProductId;
        }
Ejemplo n.º 30
0
 public static void UpdatePurchase(PurchaseDetails purchaseDetail)
 {
     if (PurchaseDetails.Exists(pd => pd.Id == purchaseDetail.Id))
     {
         var indix = PurchaseDetails.FindIndex(pd => pd.Id == purchaseDetail.Id);
         PurchaseDetails[indix] = purchaseDetail;
     }
 }
Ejemplo n.º 31
0
        /// <summary>
        /// Insert and update the purchase details..
        /// </summary>
        /// <param name="users"></param>
        /// <returns></returns>
        public int InsertUpdatePurchaseDetails(PurchaseDetails purchase_details)
        {
            int LastId    = 0;
            var DbManager = new DBManager("DBConnection");

            DbManager.Insert(_StoredProcedures.InsertUpdatePurchaseDetails_SP, CommandType.StoredProcedure, _PurchaseIRepository.AddParmsPurchaseDetails(purchase_details), out LastId);
            return(LastId);
        }
Ejemplo n.º 32
0
        public static Response NewPurchase(NewPurchaseView view, string userName)
        {
            using (var transaction = db.Database.BeginTransaction())
            {
                try
                {
                    var user     = db.Users.Where(u => u.UserName == userName).FirstOrDefault();
                    var purchase = new Purchase
                    {
                        CompanyId   = user.CompanyId,
                        ProviderId  = view.ProviderId,
                        Date        = view.Date,
                        Remarks     = view.Remarks,
                        StateId     = DBHelper.GetState("Criado", db),
                        WareHouseId = view.ProviderId
                    };

                    db.Purchase.Add(purchase);
                    db.SaveChanges();
                    var details = db.PurchaseDetailTmps.Where(odt => odt.UserName == userName).ToList();

                    foreach (var detail in details)
                    {
                        var purchaseDetail = new PurchaseDetails
                        {
                            Description = detail.Description,
                            PurchaseId  = purchase.PurchaseId,
                            Price       = detail.Price,
                            ProductId   = detail.ProductId,
                            Quantity    = detail.Quantity,
                            TaxRate     = detail.TaxRate
                        };

                        db.PurchaseDetails.Add(purchaseDetail);
                        db.PurchaseDetailTmps.Remove(detail);
                    }



                    db.SaveChanges();
                    transaction.Commit();
                    return(new Response {
                        Succeeded = true
                    });
                }
                catch (Exception ex)
                {
                    transaction.Rollback();
                    return(new Response
                    {
                        Message = ex.Message,
                        Succeeded = false
                    });

                    throw;
                }
            }
        }