public string CheckItems(SellItems aSell)
{
Query = "SELECT * FROM ItemCheckView Where SupplierId='" + aSell.SupplierId + "' AND ItemName=@itemName AND Status='true'";
Command = new SqlCommand(Query, Connection);
Command.Parameters.Clear();
Command.Parameters.Add("itemName", SqlDbType.VarChar);
Command.Parameters["itemName"].Value = aSell.ItemName;
string msg = null;
Connection.Open();
Reader = Command.ExecuteReader();
if (Reader.Read())
{
var qty = (int)Reader["RemainingQty"];
if (aSell.Qty >= qty)
{
msg = "no";
}
else
{
msg = "yes";
}
}
Reader.Close();
Connection.Close();
return(msg);
}
public List <Sell> GetItemsByBillNo(string nestId)
{
List <Sell> aSell = new List <Sell>();
Query = "SELECT * FROM Sell WHERE BillNo='" + nestId + "' AND status='true' OR status='false'";
Command = new SqlCommand(Query, Connection);
Connection.Open();
Reader = Command.ExecuteReader();
if (Reader.Read())
{
Sell ap = new Sell();
ap.Id = (int)Reader["Id"];
ap.Date = (DateTime)Reader["Date"];
ap.Name = Reader["Name"].ToString();
ap.MobileNo = Reader["MobileNo"].ToString();
ap.Email = Reader["Email"].ToString();
decimal totalAmount = (decimal)Reader["TotalAmount"];
ap.TotalAmount = (float)totalAmount;
aSell.Add(ap);
}
Reader.Close();
Connection.Close();
Query = "SELECT * FROM SellItems WHERE BillNo='" + aSell[0].Id + "' AND status='true' OR status='false'";
Command = new SqlCommand(Query, Connection);
Connection.Open();
Reader = Command.ExecuteReader();
while (Reader.Read())
{
SellItems aSellItem = new SellItems();
aSellItem.ItemName = Reader["ItemName"].ToString();
aSellItem.Qty = (int)Reader["Qty"];
decimal price = (decimal)Reader["Price"];
aSellItem.Price = (float)price;
decimal amount = (decimal)Reader["Amount"];
aSellItem.Amount = (float)amount;
aSell[0].SellItemses.Add(aSellItem);
}
Reader.Close();
Connection.Close();
return(aSell);
}
public JsonResult CheckItem(SellItems aSell)
{
string status = null;
//Global.Id = O.InvoiceNo;
string message = aSellManager.CheckItems(aSell);
if (message == "yes")
{
status = message;
ModelState.Clear();
}
else if (message == "no")
{
status = message;
}
else
{
status = message;
}
return(new JsonResult {
Data = new { status = status }
});
}
public void SellItem(SellItems item)
{
m_money += m_sell[item];
}
public string CheckItems(SellItems aSell)
{
return(aSellGateway.CheckItems(aSell));
}
