public bool AddStock(SupplierPurchaseDetails purchaseDetails) { string connectionString = dBConnection.ConnectionString; bool isAdd = false; SqlConnection sqlConnection = new SqlConnection(connectionString); string commandString = @"INSERT INTO StockIn(SupplierPurchaseId,Category,Product,Quantity,PurchaseCode) VALUES(" + purchaseDetails.SupplierPurchaseId + ",'" + purchaseDetails.Category + "','" + purchaseDetails.Product + "'," + "" + purchaseDetails.Quantity + ",'" + purchaseDetails.PurchaseCode + "')"; SqlCommand sqlCommand = new SqlCommand(commandString, sqlConnection); sqlConnection.Open(); int isExecute = sqlCommand.ExecuteNonQuery(); if (isExecute > 0) { isAdd = true; } sqlConnection.Close(); return(isAdd); }
public bool UpdatePurchaseProductQty(SupplierPurchaseDetails purchaseDetails) { string connectionString = dBConnection.ConnectionString; bool isUpdate = false; SqlConnection sqlConnection = new SqlConnection(connectionString); string query = @"UPDATE SupplierPurchaseDetails SET AvailableQuantity = AvailableQuantity + " + purchaseDetails.Quantity + "," + "UnitPrice = " + purchaseDetails.UnitPrice + ",PreviousUnitPrice = " + purchaseDetails.PreviousUnitPrice + ",PreviousMRP = " + purchaseDetails.PreviousMRP + "," + "MRP = " + purchaseDetails.MRP + " WHERE ProductId = '" + purchaseDetails.ProductId + "'"; SqlCommand sqlCommand = new SqlCommand(query, sqlConnection); sqlConnection.Open(); int isExecute = sqlCommand.ExecuteNonQuery(); if (isExecute > 0) { isUpdate = true; } sqlConnection.Close(); return(isUpdate); }
public List <SupplierPurchaseDetails> SelectProduct(int catId) { List <SupplierPurchaseDetails> stocks = new List <SupplierPurchaseDetails>(); SqlConnection sqlConnection = new SqlConnection(connectionString); sqlConnection.Open(); string query = "SELECT Id,Product FROM SupplierPurchaseDetails WHERE CategoryId = " + catId + ""; SqlCommand sqlCommand = new SqlCommand(query, sqlConnection); SqlDataReader sqlDataReader = sqlCommand.ExecuteReader(); while (sqlDataReader.Read()) { SupplierPurchaseDetails stock = new SupplierPurchaseDetails(); stock.Id = Convert.ToInt32(sqlDataReader["Id"]); stock.Product = sqlDataReader["Product"].ToString(); stocks.Add(stock); } sqlConnection.Close(); return(stocks); }
public bool AddPurchaseItem(SupplierPurchaseDetails purchaseDetails) { string connectionString = dBConnection.ConnectionString; bool isAdd = false; SqlConnection sqlConnection = new SqlConnection(connectionString); string commandString = @"INSERT INTO SupplierPurchaseDetails(SupplierPurchaseId,CategoryId,ProductId,Product,PurchaseCode,Code, AvailableQuantity,ManufacturedDate,ExpireDate,Remarks,Quantity,UnitPrice,TotalPrice,PreviousUnitPrice, PreviousMRP,MRP) VALUES(" + purchaseDetails.SupplierPurchaseId + "," + purchaseDetails.CategoryId + "," + purchaseDetails.ProductId + ",'" + purchaseDetails.Product + "'," + "'" + purchaseDetails.PurchaseCode + "','" + purchaseDetails.Code + "'," + purchaseDetails.AvailableQuantity + purchaseDetails.Quantity + ",'" + purchaseDetails.ManufacturedDate + "','" + purchaseDetails.ExpireDate + "'," + "'" + purchaseDetails.Remarks + "'," + purchaseDetails.Quantity + "," + purchaseDetails.UnitPrice + "," + "" + purchaseDetails.TotalPrice + "," + purchaseDetails.PreviousUnitPrice + "," + purchaseDetails.PreviousMRP + "," + purchaseDetails.MRP + ")"; SqlCommand sqlCommand = new SqlCommand(commandString, sqlConnection); sqlConnection.Open(); int isExecute = sqlCommand.ExecuteNonQuery(); if (isExecute > 0) { isAdd = true; } sqlConnection.Close(); return(isAdd); }
public bool AddStock(SupplierPurchaseDetails purchaseDetails) { return(_purchaseRepository.AddStock(purchaseDetails)); }
public bool UpdatePurchaseProductQty(SupplierPurchaseDetails purchaseDetails) { return(_purchaseRepository.UpdatePurchaseProductQty(purchaseDetails)); }
public bool AddPurchaseItem(SupplierPurchaseDetails purchaseDetails) { return(_purchaseRepository.AddPurchaseItem(purchaseDetails)); }