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