public static CaseClass tblCase_GetByStatus(int status)
{
string query = "tblCase_GetByStatus";
List<SqlParameter> prms = new List<SqlParameter>();
SqlParameter prm = new SqlParameter("@Status", status);
prms.Add(prm);
DataTable dt = Connection.runQuery(query, prms.ToArray());
CaseClass res = new CaseClass();
for (int i = 0; i < dt.Rows.Count; i++)
{
CaseClass tmp = new CaseClass();
tmp.CasePrmID = Convert.ToInt32(dt.Rows[i]["CasePrmID"].ToString());
tmp.Parameter = dt.Rows[i]["Parameter"].ToString();
tmp.Value = Convert.ToDecimal(dt.Rows[i]["Value"].ToString());
tmp.UnValue = Convert.ToDecimal(dt.Rows[i]["UnValue"].ToString());
tmp.Status = Convert.ToInt32(dt.Rows[i]["Status"].ToString());
tmp.GenValue = Convert.ToDecimal(dt.Rows[i]["GenValue"].ToString());
res = tmp;
}
return res;
}
/// <summary>
/// i have job to do...
/// </summary>
/// <param name="date"></param>
/// <returns></returns>
public static DataTable MakeReport(DateTime date, CaseClass caseObj)
{
string query = "reportFormDoneNew";
List<SqlParameter> prms = new List<SqlParameter>();
prms.Add(new SqlParameter("@CustomerID", DBNull.Value));
prms.Add(new SqlParameter("@StartDate", date.Date));
prms.Add(new SqlParameter("@EndDate", date.Date));
prms.Add(new SqlParameter("@ProductId", DBNull.Value));
DataTable dt = Connection.runQuery(query, prms.ToArray());
string[] products = Product.Products_GetUsedProducts();
//new table generations
DataTable newDt = new DataTable();
for (int i = 0; i < products.Length; i++)
{
DataColumn dataCol = new DataColumn(products[i]);
newDt.Columns.Add(dataCol);
}
DataColumn dataColProductTotalCount = new DataColumn("Toplam");
newDt.Columns.Add(dataColProductTotalCount);
DataColumn dataColTotalPrice = new DataColumn("Tutar");
newDt.Columns.Add(dataColTotalPrice);
//jobs to do
//SpecialPrice[] allSpecialPrices = SpecialPrice.SpecialPrice_GetDistincts();
//for (int i = 0; i < allSpecialPrices.Length;i++ )
//{
// allSpecialPrices[i].
// DataColumn dcsp = new DataColumn("");
//}
//filling newDt table for.
for (int i = 0; i < dt.Rows.Count; i++)
{
DataRow dtr = newDt.NewRow();
int oID = Convert.ToInt32(dt.Rows[i]["ID"].ToString());
dtr["Müşteri Adı"] = Customer.Customer_GetByID(Convert.ToInt32(dt.Rows[i]["CustomerID"].ToString())).Name;
OrderDetail[] ods = OrderDetail.OrderDetails_GetByOrderID(oID).ToArray();
for (int j = 0; j < ods.Length; j++)
{
for (int k = 0; k < newDt.Columns.Count; k++)
{
Product pTmp = Product.Products_GetByID(ods[j].ProductID);
if (newDt.Columns[k].ColumnName == pTmp.Name)
{
dtr[k] = ods[j].Unit;
dtr[k + 1] = ods[j].Price;
}
}
}
dtr["Sipariş Tarihi"] = dt.Rows[i]["Date"].ToString();
newDt.Rows.Add(dtr);
}
return newDt;
}
public static CaseClass[] tblCase_GetAll()
{
string query = "tblCase_GetAll";
DataTable dt = Connection.runQuery(query, new SqlParameter[0]);
List<CaseClass> res = new List<CaseClass>();
for (int i = 0; i < dt.Rows.Count; i++)
{
CaseClass tmp = new CaseClass();
tmp.CasePrmID = Convert.ToInt32(dt.Rows[i]["CasePrmID"].ToString());
tmp.Parameter = dt.Rows[i]["Parameter"].ToString();
tmp.Value = Convert.ToDecimal(dt.Rows[i]["Value"].ToString());
tmp.UnValue = Convert.ToDecimal(dt.Rows[i]["UnValue"].ToString());
tmp.Status = Convert.ToInt32(dt.Rows[i]["Status"].ToString());
tmp.GenValue = Convert.ToDecimal(dt.Rows[i]["GenValue"].ToString());
res.Add(tmp);
}
return res.ToArray();
}