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));
}
