public DayEndCashupReport GetDayEndCashupReport(DayEndCashupQuery query) { //...Create New Instance of Object... DayEndCashupReport ins = new DayEndCashupReport(); //...Database Connection... DataBaseConnection dbConn = new DataBaseConnection(); SqlConnection con = dbConn.SqlConn(); SqlCommand cmdI = new SqlCommand(); cmdI.CommandTimeout = 540; cmdI.Connection = con; cmdI.CommandText = "f_Admin_Report_DayEndCashUp"; cmdI.CommandType = System.Data.CommandType.StoredProcedure; cmdI.Parameters.AddWithValue("@date", query.Date); cmdI.Connection.Open(); SqlDataReader drI = cmdI.ExecuteReader(); //...Retrieve Data... if (drI.HasRows) { while (drI.Read()) { ins.ActualCash = Convert.ToDecimal(drI["ActualCash"]); ins.Cashbox = Convert.ToDecimal(drI["Cashbox"]); ins.CashDeclared = Convert.ToDecimal(drI["CashDeclared"]); ins.CashReceived = Convert.ToDecimal(drI["CashReceived"]); ins.Change = Convert.ToDecimal(drI["Change"]); ins.CounterTotal = Convert.ToDecimal(drI["CounterTotal"]); ins.DeclaredSlips = Convert.ToDecimal(drI["DeclaredSlips"]); ins.SassaTotal = Convert.ToDecimal(drI["SassaTotal"]); ins.SigmaTotal = Convert.ToDecimal(drI["SigmaTotal"]); ins.StartUpFloats = Convert.ToDecimal(drI["StartUpFloats"]); ins.Transits = Convert.ToDecimal(drI["Transits"]); } } //...Close Connections... cmdI.Connection.Close(); con.Dispose(); //...Return... return(ins); }
public DayEndCashupReport GetDayEndCashupReport(DayEndCashupQuery query) { //...Create New Instance of Object... DayEndCashupReport ins = new DayEndCashupReport(); //...Database Connection... DataBaseConnection dbConn = new DataBaseConnection(); SqlConnection con = dbConn.SqlConn(); SqlCommand cmdI = new SqlCommand(); cmdI.CommandTimeout = 540; cmdI.Connection = con; cmdI.CommandText = "f_Admin_Report_DayEndCashUp"; cmdI.CommandType = System.Data.CommandType.StoredProcedure; cmdI.Parameters.AddWithValue("@date", query.Date); cmdI.Connection.Open(); SqlDataReader drI = cmdI.ExecuteReader(); //...Retrieve Data... if (drI.HasRows) { while (drI.Read()) { ins.ActualCash = Convert.ToDecimal(drI["ActualCash"]); ins.Cashbox = Convert.ToDecimal(drI["Cashbox"]); ins.CashDeclared = Convert.ToDecimal(drI["CashDeclared"]); ins.CashReceived = Convert.ToDecimal(drI["CashReceived"]); ins.Change = Convert.ToDecimal(drI["Change"]); ins.CounterTotal = Convert.ToDecimal(drI["CounterTotal"]); ins.DeclaredSlips = Convert.ToDecimal(drI["DeclaredSlips"]); ins.SassaTotal = Convert.ToDecimal(drI["SassaTotal"]); ins.SigmaTotal = Convert.ToDecimal(drI["SigmaTotal"]); ins.StartUpFloats = Convert.ToDecimal(drI["StartUpFloats"]); ins.Transits = Convert.ToDecimal(drI["Transits"]); } } //...Close Connections... cmdI.Connection.Close(); con.Dispose(); //...Return... return ins; }
public ActionResult GetDayEndCashupReport(DayEndCashupQuery ins) { DayEndCashupReport report = reportrepo.GetDayEndCashupReport(ins); decimal ExpectedClosing = ins.OpeningBalance + report.SigmaTotal + report.CounterTotal + report.Change - ins.PettyCash - report.SassaTotal - report.Cashbox - report.Transits; decimal Shortage = report.CashReceived - report.StartUpFloats - report.SigmaTotal; StringWriter sw = new StringWriter(); sw.WriteLine("\"Opening Balance\",\"{0}\"", ins.OpeningBalance); sw.WriteLine("\"Sigma Cash Sales\",\"{0}\"", report.SigmaTotal); sw.WriteLine("\"Cash Counter Netto\",\"{0}\"", report.CounterTotal); sw.WriteLine("\"Change Movement\",\"{0}\"", report.Change); sw.WriteLine("\"Cash transactions (Petty cash Total)\",\"{0}\"", ins.PettyCash); sw.WriteLine("\"Sassa Payouts\",\"{0}\"", report.SassaTotal); sw.WriteLine("\"Total dropped in Cashbox for today\",\"{0}\"", report.Cashbox); sw.WriteLine("\"Transits\",\"{0}\"", report.Transits); sw.WriteLine("\"Expected Closing Balance\",\"{0}\"", ExpectedClosing); sw.WriteLine("\"Actual Cash\",\"{0}\"", report.ActualCash); sw.WriteLine("\"Day End: {0}\",\"{1}\"", (((ExpectedClosing - report.ActualCash) < 0) ? "Shortage" : "Over"), (ExpectedClosing - report.ActualCash)); sw.WriteLine("\" \""); sw.WriteLine("\"SIGMA CASHIER - CASH RECON\""); sw.WriteLine("\"Cash Expected\",\"{0}\"", report.SigmaTotal); sw.WriteLine("\"Cash Received\",\"{0}\"", report.CashReceived); sw.WriteLine("\"Startup Floats\",\"{0}\"", report.StartUpFloats); sw.WriteLine("\"Shortage\",\"{0}\"", Shortage); sw.WriteLine("\"Sassa Payouts\",\"{0}\"", report.SassaTotal); sw.WriteLine("\"{0}\",\"{1}\"", (((Shortage + report.SassaTotal) > 0) ? "Over" : "Short"), (Shortage + report.SassaTotal)); sw.WriteLine("\" \""); sw.WriteLine("\"SIGMA CASHIER - CARD RECON\""); sw.WriteLine("\"Sigma Cards Expected\",\"{0}\"", ins.SigmaCardsExpected); sw.WriteLine("\"Declared Slips Total\",\"{0}\"", report.DeclaredSlips); sw.WriteLine("\"CARDS NOT CAPTURED\",\"{0}\"", (ins.SigmaCardsExpected - report.DeclaredSlips)); sw.WriteLine("\" \""); sw.WriteLine("\"PAYZONE CASHIERS\""); sw.WriteLine("\"Cash Expected\",\"{0}\"", report.CounterTotal); sw.WriteLine("\"Cash Received\",\"{0}\"", report.CashDeclared); sw.WriteLine("\"{0}\",\"{1}\"", (((report.CashDeclared - report.CounterTotal) > 0) ? "Over" : "Short"), (report.CashDeclared - report.CounterTotal)); string name = DateTime.Now.Year.ToString() + DateTime.Now.Month.ToString() + DateTime.Now.Day.ToString(); Response.ClearContent(); Response.AddHeader("content-disposition", "attachment;filename=DayEndCashup_" + ins.Date.ToShortDateString() + "_" + name + ".csv"); Response.ContentType = "text/csv"; Response.Write(sw.ToString()); Response.End(); return null; }