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; }