public List <Sales_Details> SearchProduct(string criteria)
{
List <Sales_Details> sales_Details = new List <Sales_Details>();
SqlConnection sqlConnection = new SqlConnection(connectionString);
sqlConnection.Open();
string query = "SELECT * FROM Sales_Details WHERE Date = '" + criteria + "'OR SalesCode = '" + criteria + "'";
SqlCommand sqlCommand = new SqlCommand(query, sqlConnection);
SqlDataReader sqlDataReader = sqlCommand.ExecuteReader();
while (sqlDataReader.Read())
{
Sales_Details sales_Detail = new Sales_Details();
sales_Detail.SL = sqlDataReader["SL"].ToString();
sales_Detail.Id = Convert.ToInt32(sqlDataReader["Id"]);
sales_Detail.CustomerId = Convert.ToInt32(sqlDataReader["CustomerId"]);
sales_Detail.Date = sqlDataReader["Date"].ToString();
sales_Detail.LoyalityPoint = Convert.ToDouble(sqlDataReader["LoyalityPoint"].ToString());
sales_Detail.CategoryId = Convert.ToInt32(sqlDataReader["CategoryId"]);
sales_Detail.ProductId = Convert.ToInt32(sqlDataReader["ProductId"]);
sales_Detail.SalesCode = sqlDataReader["SalesCode"].ToString();
sales_Detail.Product = sqlDataReader["Product"].ToString();
sales_Detail.AvailableQuantity = Convert.ToDouble(sqlDataReader["AvailableQuantity"].ToString());
sales_Detail.Quantity = Convert.ToDouble(sqlDataReader["Quantity"].ToString());
sales_Detail.MRP = Convert.ToDouble(sqlDataReader["MRP"].ToString());
sales_Detail.TotalMRP = Convert.ToDouble(sqlDataReader["TotalMRP"].ToString());
sales_Details.Add(sales_Detail);
}
sqlConnection.Close();
return(sales_Details);
}
public bool UpdateStockQty(Sales_Details sales_Details)
{
bool isUpdate = false;
SqlConnection sqlConnection = new SqlConnection(connectionString);
string commandString = @"UPDATE Stock SET Quantity = Quantity - " + sales_Details.Quantity + " WHERE Product = '" + sales_Details.Product + "'";
SqlCommand sqlCommand = new SqlCommand(commandString, sqlConnection);
sqlConnection.Open();
int isExecute = sqlCommand.ExecuteNonQuery();
if (isExecute > 0)
{
isUpdate = true;
}
sqlConnection.Close();
return(isUpdate);
}
public bool AddSalesItem(Sales_Details sales_Details, double soldPrice, double profit)
{
bool isAdd = false;
SqlConnection sqlConnection = new SqlConnection(connectionString);
string commandString = @"INSERT INTO Sales_Details(SL,CustomerId,Date,LoyalityPoint,CategoryId,ProductId,SalesCode,Product,AvailableQuantity,Quantity,MRP,SalePrice,Profit,TotalMRP)
VALUES('" + sales_Details.SL + "'," + sales_Details.CustomerId + ",'" + sales_Details.Date + "'," + sales_Details.LoyalityPoint + "," + sales_Details.CategoryId + "," + sales_Details.ProductId + "," +
"'" + sales_Details.SalesCode + "','" + sales_Details.Product + "'," + sales_Details.AvailableQuantity + "," + sales_Details.Quantity + "," + sales_Details.MRP + "," + soldPrice + "," + profit + "," + sales_Details.TotalMRP + ")";
SqlCommand sqlCommand = new SqlCommand(commandString, sqlConnection);
sqlConnection.Open();
int isExecute = sqlCommand.ExecuteNonQuery();
if (isExecute > 0)
{
isAdd = true;
}
sqlConnection.Close();
return(isAdd);
}
public JsonResult Index(string Quantity, string Item, int Watts, string TotalAmo, string Desc, string Price, string Addcomments)
{
Sales_Details obj = new Sales_Details();
obj.Description = Desc;
obj.watt = Watts;
obj.Product_name = Item;
obj.Product_price = Price;
obj.Quantity = Quantity;
obj.Amount = TotalAmo;
obj.sales_date = DateTime.Now.ToString();
obj.AdditionalComments = Addcomments;
using (SainiShopEntities1 objDb = new SainiShopEntities1())
{
objDb.Sales_Details.Add(obj);
objDb.SaveChanges();
}
var response = new Response(true, "Contact Successfully Submitted");
return(Json(response));
}
public bool UpdateSalesItem(Sales_Details sales_Details, int id)
{
bool isUpdate = false;
SqlConnection sqlConnection = new SqlConnection(connectionString);
string query = "UPDATE Sales_Details SET Product = '" + sales_Details.Product + "', " +
"AvailableQuantity = " + sales_Details.AvailableQuantity + ",Quantity = " + sales_Details.Quantity + "," +
"MRP = '" + sales_Details.MRP + "',TotalMRP = " + sales_Details.TotalMRP + " WHERE Id = " + id + "";
SqlCommand sqlCommand = new SqlCommand(query, sqlConnection);
sqlConnection.Open();
int isExecute = sqlCommand.ExecuteNonQuery();
if (isExecute > 0)
{
isUpdate = true;
}
sqlConnection.Close();
return(isUpdate);
}
public bool UpdateSalesItem(Sales_Details sales_Details, int id)
{
return(_salesRepository.UpdateSalesItem(sales_Details, id));
}
public bool UpdateStockQty(Sales_Details sales_Details)
{
return(_salesRepository.UpdateStockQty(sales_Details));
}
public bool AddSalesItem(Sales_Details sales_Details, double soldPrice, double profit)
{
return(_salesRepository.AddSalesItem(sales_Details, soldPrice, profit));
}
