protected void btnAddSaleClick(object sender, EventArgs e)
{
int id = SqlData.getInstance().getMaxId("sales") + 1;
String sqlstr = String.Format("INSERT INTO sales(id, movie_id, reldate) VALUES ('{0:d}', '{1:s}', '{2:s}')", id, getMovieId(), DateTime.Now.Date.ToShortDateString());
MyLog.v(sqlstr);
SqlData.getInstance().ExecuteSQL(sqlstr);
GridViewSales.DataBind();
}
protected void BtnReport_Click(object sender, EventArgs e)
{
DateTime StartDate = new DateTime(Convert.ToInt32(txtStartYear.Text), Convert.ToInt32(txtStartMonth.Text), Convert.ToInt32(txtStartDay.Text));
DateTime EndDate = new DateTime(Convert.ToInt32(txtEndYear.Text), Convert.ToInt32(txtEndMonth.Text), Convert.ToInt32(txtEndDay.Text));
string CS = ConfigurationManager.ConnectionStrings["DBCS"].ConnectionString;
SqlConnection con = new SqlConnection(CS);
SqlCommand cmd = new SqlCommand("Get_Sales_Report", con);
cmd.CommandType = CommandType.StoredProcedure;
cmd.Parameters.Add("@Start_Date", SqlDbType.Date).Value = StartDate;
cmd.Parameters.Add("@End_Date", SqlDbType.Date).Value = EndDate;
con.Open();
SqlDataReader rdr = cmd.ExecuteReader();
// Bind incomes
DataTable table = new DataTable();
table.Columns.Add("Bill_Date");
table.Columns.Add("P_Name");
table.Columns.Add("Amount");
table.Columns.Add("Purchase_Price");
table.Columns.Add("Specified_Price");
table.Columns.Add("Sell_Price");
while (rdr.Read())
{
DataRow row = table.NewRow();
row["Bill_Date"] = Convert.ToDateTime(rdr["Bill_Date"]).ToShortDateString();
row["P_Name"] = rdr["P_Name"];
row["Amount"] = Convert.ToInt32(rdr["Amount"]);
row["Purchase_Price"] = Convert.ToDouble(rdr["Purchase_Price"]);
row["Specified_Price"] = Convert.ToDouble(rdr["Specified_Price"]);
row["Sell_Price"] = Convert.ToDouble(rdr["Sell_Price"]);
table.Rows.Add(row);
}
rdr.Close();
con.Close();
GridViewSales.DataSource = table;
GridViewSales.DataBind();
lblTotalSales.Text = totalSales.ToString();
lblearns.Text = (totalSales - totalCost).ToString();
lblDiff.Text = (totalSales - totalSpecified).ToString();
PanelReport.Visible = true;
}
protected void BtnReport_Click(object sender, EventArgs e)
{
DateTime StartDate = new DateTime(Convert.ToInt32(txtStartYear.Text), Convert.ToInt32(txtStartMonth.Text), Convert.ToInt32(txtStartDay.Text));
DateTime EndDate = new DateTime(Convert.ToInt32(txtEndYear.Text), Convert.ToInt32(txtEndMonth.Text), Convert.ToInt32(txtEndDay.Text));
string CS = ConfigurationManager.ConnectionStrings["DBCS"].ConnectionString;
SqlConnection con = new SqlConnection(CS);
SqlCommand cmd = new SqlCommand("Get_Income", con);
cmd.CommandType = CommandType.StoredProcedure;
cmd.Parameters.Add("@Start_Date", SqlDbType.Date).Value = StartDate;
cmd.Parameters.Add("@End_Date", SqlDbType.Date).Value = EndDate;
con.Open();
SqlDataReader rdr = cmd.ExecuteReader();
// Bind incomes
DataTable table = new DataTable();
table.Columns.Add("Pay_Date");
table.Columns.Add("All_Sales");
while (rdr.Read()) // all sales
{
DataRow row = table.NewRow();
row["Pay_Date"] = Convert.ToDateTime(rdr["Bill_Date"]).ToShortDateString();
row["All_Sales"] = Convert.ToDouble(rdr["All_Sales"]);
table.Rows.Add(row);
}
GridViewSales.DataSource = table;
GridViewSales.DataBind();
#region Paid sales
if (rdr.NextResult()) // Paid sales
{
DataTable Paid_Sales_tbl = new DataTable();
Paid_Sales_tbl.Columns.Add("Pay_Date");
Paid_Sales_tbl.Columns.Add("Paid_Sales");
while (rdr.Read())
{
DataRow row = Paid_Sales_tbl.NewRow();
row["Pay_Date"] = Convert.ToDateTime(rdr["Bill_Date"]).ToShortDateString();
row["Paid_Sales"] = Convert.ToDouble(rdr["Paid_Sales"]);
Paid_Sales_tbl.Rows.Add(row);
}
GridViewPaid_Sales.DataSource = Paid_Sales_tbl;
GridViewPaid_Sales.DataBind();
}
#endregion
#region Paid debts
if (rdr.NextResult()) // Paid debts
{
DataTable Debts_table = new DataTable();
Debts_table.Columns.Add("Pay_Date");
Debts_table.Columns.Add("Paid_Debts");
while (rdr.Read())
{
DataRow row = Debts_table.NewRow();
row["Pay_Date"] = Convert.ToDateTime(rdr["Pay_Date"]).ToShortDateString();
row["Paid_Debts"] = Convert.ToDouble(rdr["Paid_Debts"]);
Debts_table.Rows.Add(row);
}
GridViewDebts.DataSource = Debts_table;
GridViewDebts.DataBind();
}
#endregion
#region simple expeneses
if (rdr.NextResult()) // simple expeneses (except pay debts to suppliers and purchase products)
{
DataTable Expenses_table = new DataTable();
Expenses_table.Columns.Add("Pay_Date");
Expenses_table.Columns.Add("Category");
Expenses_table.Columns.Add("Paid_Value");
Expenses_table.Columns.Add("Notes");
while (rdr.Read())
{
DataRow row = Expenses_table.NewRow();
row["Pay_Date"] = Convert.ToDateTime(rdr["Pay_Date"]).ToShortDateString();
row["Category"] = rdr["Category"];
row["Paid_Value"] = Convert.ToDouble(rdr["Paid_Value"]);
row["Notes"] = rdr["Notes"];
Expenses_table.Rows.Add(row);
}
GridViewExpenses.DataSource = Expenses_table;
GridViewExpenses.DataBind();
}
#endregion
#region huge expeneses
if (rdr.NextResult()) // huge expeneses (include pay debts to suppliers and purchase products)
{
DataTable Expenses_table2 = new DataTable();
Expenses_table2.Columns.Add("Pay_Date");
Expenses_table2.Columns.Add("Category");
Expenses_table2.Columns.Add("Paid_Value");
Expenses_table2.Columns.Add("Notes");
while (rdr.Read())
{
DataRow row = Expenses_table2.NewRow();
row["Pay_Date"] = Convert.ToDateTime(rdr["Pay_Date"]).ToShortDateString();
row["Category"] = rdr["Category"];
row["Paid_Value"] = Convert.ToDouble(rdr["Paid_Value"]);
row["Notes"] = rdr["Notes"];
Expenses_table2.Rows.Add(row);
}
GridViewHugeExpenses.DataSource = Expenses_table2;
GridViewHugeExpenses.DataBind();
}
#endregion
#region Other income
if (rdr.NextResult()) // Other income
{
DataTable Other_Income_Table = new DataTable();
Other_Income_Table.Columns.Add("Pay_Date");
Other_Income_Table.Columns.Add("All_Sales");
Other_Income_Table.Columns.Add("Notes");
while (rdr.Read())
{
DataRow row = Other_Income_Table.NewRow();
row["Pay_Date"] = Convert.ToDateTime(rdr["Bill_Date"]).ToShortDateString();
row["All_Sales"] = Convert.ToDouble(rdr["All_Sales"]);
row["Notes"] = rdr["Notes"].ToString();
Other_Income_Table.Rows.Add(row);
}
GridViewOtherIncome.DataSource = Other_Income_Table;
GridViewOtherIncome.DataBind();
}
#endregion
rdr.Close();
con.Close();
lblTotalIncome.Text = (Paid_Debts + Paid_Sales + OtherIncome).ToString() + "جنبه";
lblExpenses.Text = (TotalExpenses + TotalHugeExpenses).ToString() + "جنيه";
double Netvalue = ((Paid_Debts + Paid_Sales + OtherIncome) - (TotalExpenses + TotalHugeExpenses));
lblNetValue.Text = Netvalue >= 0 ? Netvalue.ToString() + " ج.م" : "لا يوجد دخل صافى وفرق المصروفات عن الايراد = " + (-Netvalue).ToString() + " ج.م" + " مدفوعه من خارج ايراد الشركه";
PanelReport.Visible = true;
}
