public HttpResponseMessage GetCarsForCmd1(string baz, [FromUri] Cmd1 cmd)
{
return(new HttpResponseMessage(HttpStatusCode.OK)
{
Content = new StringContent("Default Car for Cmd1")
});
}
public decimal SumRRev(string date, string year, string month, int i)
{
decimal a;
SqlConnection Con = new SqlConnection(constng);
SqlCommand Cmd1 = new SqlCommand();
if (i == 1)
{
Cmd1 = new SqlCommand("SELECT SUM((Product.SellingRate * quan)) AS Profit FROM dbo.Product INNER JOIN (SELECT ProductId,Quantity AS quan FROM dbo.Retail INNER JOIN dbo.RetailDetails ON Retail.RetailId = RetailDetails.RetailId WHERE Retail.Date = '" + date + "') Hal ON Product.ProductId = Hal.ProductId;", Con);;
}//SqlCommand Cmd = new SqlCommand("SELECT IDENT_CURRENT('dbo.[Wholesale]') + IDENT_INCR('dbo.[Wholesale]') AS ProductId;", Con);
else if (i == 2)
{
Cmd1 = new SqlCommand("SELECT SUM((Product.SellingRate * quan)) AS Profit FROM dbo.Product INNER JOIN (SELECT ProductId,Quantity AS quan FROM dbo.Retail INNER JOIN dbo.RetailDetails ON Retail.RetailId = RetailDetails.RetailId WHERE YEAR(Retail.Date) = '" + year + "' AND MONTH(Retail.Date)= '" + month + "') Hal ON Product.ProductId = Hal.ProductId;", Con);;
}
else if (i == 3)
{
Cmd1 = new SqlCommand("SELECT SUM((Product.SellingRate * quan)) AS Profit FROM dbo.Product INNER JOIN (SELECT ProductId,Quantity AS quan FROM dbo.Retail INNER JOIN dbo.RetailDetails ON Retail.RetailId = RetailDetails.RetailId WHERE YEAR(Retail.Date) = '" + year + "') Hal ON Product.ProductId = Hal.ProductId;", Con);;
}
try
{
Con.Open();
SqlDataReader reader = Cmd1.ExecuteReader();
reader.Read();
a = Convert.ToDecimal(reader["Profit"].ToString());
reader.Close();
Con.Close();
return(a);
}
catch (Exception ex)
{
return(0);
}
}
/// <summary>
/// Initializes a new instance of the <see cref="CommandBlock" /> class.
/// </summary>
/// <param name="cmd1">
/// </param>
/// <param name="dataCount">
/// </param>
/// <param name="cmd2">
/// </param>
/// <param name="data">
/// </param>
public CommandBlock(Cmd1 cmd1, int dataCount, byte cmd2, byte[] data)
: this((byte)(((byte)cmd1 << 4) + dataCount), cmd2, data)
{
}
