private void btnPreview_Click(object sender, EventArgs e)
{
try
{
DateTime vDateFrom = Convert.ToDateTime("1/1/2000");
DateTime vDateTo = DateTime.Today.Date; // DateTime.Today.Date.Month.ToString() + "/" + DateTime.Today.Date.Day.ToString() + "/" + DateTime.Today.Date.Year.ToString();
Reports.RptReportViewer vForm = new Reports.RptReportViewer();
//if (optRange.Checked == true)
//{
// vDateFrom = dt_From.Value; //dt_From.Value.Month.ToString() + "/" + dt_From.Value.Day.ToString() + "/" + dt_From.Value.Year.ToString();
// vDateTo = dt_ToDate.Value; //dt_ToDate.Value.Month.ToString() + "/" + dt_ToDate.Value.Day.ToString() + "/" + dt_ToDate.Value.Year.ToString();
//}
vDateTo = dt_ToDate.Value;
DataTable dt = objDAL.getTrialBalance(vDateTo.ToShortDateString());
if (dt.Rows.Count == 0)
{
MessageBox.Show("No Data To Display", "No Data");
return;
}
DAL.Misc dal = new DAL.Misc();
dal.connectionstring = objDAL.connectionstring;
decimal vNetSaleVal = dal.getNetSalesValue(vDateFrom.ToShortDateString(), vDateTo.ToShortDateString());
decimal vNetPurVal = dal.getNetPurchaseValue(vDateFrom.ToShortDateString(), vDateTo.ToShortDateString());
DataRow dr = dt.NewRow();
dr["AccountType"] = "EXPENSE";
dr["AccountNo"] = "300000";
dr["AccountTitle"] = "Purchases";
dr["Debit"] = vNetPurVal;
dr["Credit"] = 0;
dt.Rows.Add(dr);
DataRow dr1 = dt.NewRow();
dr1["AccountType"] = "REVENUE";
dr1["AccountNo"] = "400000";
dr1["AccountTitle"] = "Sales";
dr1["Debit"] = 0;
dr1["Credit"] = vNetSaleVal;
dt.Rows.Add(dr1);
vForm.ShowTrialBalance(vDateTo, dt);
vForm.ShowDialog();
}
catch (Exception exc)
{
MessageBox.Show(exc.Message, "Error");
}
}
private void GetCurrentStock(Int64 vProductID)
{
DAL.Misc cS = new DAL.Misc();
cS.connectionstring = objDAL.connectionstring;
DataTable dt = cS.getCurrentStock(vProductID);
if (dt.Rows.Count > 0)
{
double vQty, vLQty;
double vValue;
double.TryParse(dt.Rows[0]["LessQty"].ToString(), out vLQty);
double.TryParse(dt.Rows[0]["Qty"].ToString(), out vQty);
double.TryParse(dt.Rows[0]["Value"].ToString(), out vValue);
txtStockQty.Text = Math.Round(vQty, 2).ToString();
if (vQty > 0)
{
txtCostPrice.Text = (Math.Round(vValue / (vQty + vLQty), 2)).ToString();
}
else
{
txtStockQty.Text = "0";
txtCostPrice.Text = "0";
}
}
else
{
txtStockQty.Text = "0";
txtCostPrice.Text = "0";
}
}
private void mniBackUp_Click(object sender, EventArgs e)
{
DAL.Misc Msc = new DAL.Misc();
Msc.connectionstring = System.Configuration.ConfigurationManager.ConnectionStrings["MyString"].ConnectionString;
try
{
Msc.TakeDBBackup();
new Speak().SayIt("Database backup successfully.");
MessageBox.Show("Database backup successfully.", "Completed");
}
catch (Exception exc)
{
MessageBox.Show(exc.Message.ToString(), "Error");
}
}
private void btnSave_Click(object sender, EventArgs e)
{
if (txtPassword.Text == string.Empty)
{
MessageBox.Show("Password Missing???");
txtPassword.Focus();
return;
}
if (txtPassword.Text.ToUpper() != "PANTHERSOFTGO")
{
MessageBox.Show("Incorrect Password!!!");
txtPassword.Focus();
return;
}
if (txtToDatabase.Text == string.Empty)
{
MessageBox.Show("Data Base Name Missing???");
txtPassword.Focus();
return;
}
try
{
string connectionstring = System.Configuration.ConfigurationManager.ConnectionStrings["MyString"].ConnectionString;
DAL.Reports objDAL = new DAL.Reports();
objDAL.connectionstring = connectionstring;
DataTable dt = objDAL.getTrialBalance(DateTime.Now.Date.ToShortDateString());
if (dt.Rows.Count == 0)
{
MessageBox.Show("No Data To Display", "No Data");
return;
}
DAL.Misc dal = new DAL.Misc();
dal.connectionstring = objDAL.connectionstring;
decimal vNetSaleVal = dal.getNetSalesValue("01/01/2000", DateTime.Now.Date.ToShortDateString());
decimal vNetPurVal = dal.getNetPurchaseValue("01/01/2000", DateTime.Now.Date.ToShortDateString());
decimal vTTLExp = 0, vTTLRev = 0;
foreach (DataRow dr in dt.Rows)
{
if (dr["AccountType"].ToString() == "EXPENSE")
{
vTTLExp += decimal.Parse(dr["Debit"].ToString());
}
if (dr["AccountType"].ToString() == "REVENUE")
{
vTTLRev += decimal.Parse(dr["Credit"].ToString());
}
}
decimal vOpStockVal = dal.getOpeningStockValue(string.Empty);
DataTable dTemp = objDAL.getCurrentStock(string.Empty);
decimal vCSValue = 0;
foreach (DataRow dr in dTemp.Rows)
{
decimal vCurrentStockVal = (decimal)dr["Value"];
decimal vNetQty = (decimal)dr["Qty"];
decimal vDeducted = (decimal)dr["LessQty"];
decimal vCSRate = vCurrentStockVal / (vNetQty + vDeducted);
vCSValue += (vNetQty * vCSRate);
}
decimal vAdjustment = 0;
decimal.TryParse(txtBalAdjust.Text, out vAdjustment);
decimal vPLS = (vNetSaleVal - (vNetPurVal + vOpStockVal - vCSValue)) - vTTLExp + vTTLRev + vAdjustment;
connectionstring = string.Format("Data Source=(local);Initial Catalog={0};Trusted_Connection=YES;", txtToDatabase.Text);
DAL.Database obj = new DAL.Database(connectionstring);
obj.ExecuteNonQueryOnly("update AccountChart set OpeningCredit = 0 , OpeningDebit=0");
foreach (DataRow drX in dt.Rows)
{
if (drX["AccountType"].ToString() == "ASSET" || drX["AccountType"].ToString() == "LIABILITY")
{
string vQuery = string.Format(" Update AccountChart Set OpeningDebit={0}, OpeningCredit={1} Where AccountNo='{2}'"
, drX["Debit"].ToString(), drX["Credit"].ToString(), drX["AccountNo"].ToString());
obj.ExecuteNonQueryOnly(vQuery);
}
else if (drX["AccountType"].ToString() == "CAPITAL")
{
string vQuery = string.Format(" Update AccountChart Set OpeningDebit={0}, OpeningCredit={1} Where AccountNo='{2}'"
, drX["Debit"].ToString(), (decimal.Parse(drX["Credit"].ToString()) + vPLS).ToString(), drX["AccountNo"].ToString());
obj.ExecuteNonQueryOnly(vQuery);
}
}
DataTable dt2 = objDAL.getCurrentStock(string.Empty);
foreach (DataRow drX in dt2.Rows)
{
string vQuery = string.Format(" Update Products Set OpeningStock={0}, OpeningStockValue={1} Where ProductID='{2}'"
, drX["Qty"].ToString(),
(decimal.Parse(drX["Qty"].ToString()) * (decimal.Parse(drX["Value"].ToString()) / (decimal.Parse(drX["Qty"].ToString()) + decimal.Parse(drX["LessQty"].ToString())))).ToString("G29"),
drX["ProductID"].ToString());
obj.ExecuteNonQueryOnly(vQuery);
}
MessageBox.Show("Balance Transfer Successfull.");
txtToDatabase.Text = string.Empty;
}
catch (Exception exc)
{
MessageBox.Show(exc.Message);
}
}
private void btnPreview_Click(object sender, EventArgs e)
{
try
{
DateTime vDateFrom = Convert.ToDateTime("1/1/2000");
DateTime vDateTo = DateTime.Today.Date;
string vNarration = "";
Reports.RptReportViewer vForm = new Reports.RptReportViewer();
if (optRange.Checked == true)
{
vDateFrom = dt_From.Value;
vDateTo = dt_ToDate.Value;
vNarration = "From " + dt_From.Value.ToShortDateString() + " To " + dt_ToDate.Value.ToShortDateString();
}
else
{
vNarration = "For the Period Ended " + dt_ToDate.Value.ToString("dd-MMM-yyyy");
}
DataTable dt = objDAL.getProfitAndLoss(vDateFrom.ToShortDateString(), vDateTo.ToShortDateString());
//if (dt.Rows.Count == 0)
//{
// MessageBox.Show("No Data To Display", "No Data");
// return;
//}
DAL.Misc dal = new DAL.Misc();
dal.connectionstring = objDAL.connectionstring;
decimal vNetSaleVal = dal.getNetSalesValue(vDateFrom.ToShortDateString(), vDateTo.ToShortDateString());
decimal vNetPurVal = dal.getNetPurchaseValue(vDateFrom.ToShortDateString(), vDateTo.ToShortDateString());
decimal vOpStockVal = dal.getOpeningStockValue(string.Empty);
DataTable dTemp = objDAL.getCurrentStock(string.Empty);
decimal vCSValue = 0;
foreach (DataRow dr in dTemp.Rows)
{
decimal vCurrentStockVal = (decimal)dr["Value"];
decimal vNetQty = (decimal)dr["Qty"];
decimal vDeducted = (decimal)dr["LessQty"];
decimal vCSRate = vCurrentStockVal / (vNetQty + vDeducted);
vCSValue += (vNetQty * vCSRate);
}
//decimal vCurrentStockVal = dTemp.AsEnumerable()
// .Sum(dr => (decimal)dr["Value"]);
//decimal vNetQty = dTemp.AsEnumerable()
// .Sum(dr => (decimal)dr["Qty"]);
//decimal vDeducted = dTemp.AsEnumerable()
// .Sum(dr => (decimal)dr["LessQty"]);
vForm.ShowProfitAndLoss(vNarration, vNetSaleVal, vOpStockVal, vNetPurVal, vCSValue, dt);
vForm.ShowDialog();
}
catch (Exception exc)
{
MessageBox.Show(exc.Message, "Error");
}
}
