public static List <GLEntries> GetDetailEntryLedger(string reference)
{
var dbUtil = new DatabaseManager();
var glentries = new List <GLEntries>();
using (var conn = new SqlConnection(dbUtil.getSQLConnectionString("MainDB")))
{
conn.Open();
using (SqlCommand cmd = conn.CreateCommand())
{
cmd.CommandType = CommandType.StoredProcedure;
cmd.CommandText = "spDisGetBPRAdjustmentDetailEntry";
cmd.CommandTimeout = 180;
cmd.Parameters.AddWithValue("@strReference", reference);
using (SqlDataReader reader = cmd.ExecuteReader())
{
while (reader.Read())
{
var glentry = new GLEntries
{
GLEntryID = ReferenceEquals(reader["intGLEntryID"], DBNull.Value) ? 0 : Convert.ToInt32(reader["intGLEntryID"]),
COAID = ReferenceEquals(reader["intCOAID"], DBNull.Value) ? 0 : Convert.ToInt32(reader["intCOAID"]),
COACode = ReferenceEquals(reader["strCOACode"], DBNull.Value) ? string.Empty : Convert.ToString(reader["strCOACode"]),
COA = ReferenceEquals(reader["strCOA"], DBNull.Value) ? string.Empty : Convert.ToString(reader["strCOA"]),
SubsidiaryID = ReferenceEquals(reader["intSubsidiaryID"], DBNull.Value) ? 0 : Convert.ToInt32(reader["intSubsidiaryID"]),
SubsidiaryCode = ReferenceEquals(reader["strSubsidiaryCode"], DBNull.Value) ? string.Empty : Convert.ToString(reader["strSubsidiaryCode"]),
Subsidiary = ReferenceEquals(reader["strSubsidiary"], DBNull.Value) ? string.Empty : Convert.ToString(reader["strSubsidiary"]),
SupplementaryID = ReferenceEquals(reader["intSupplementaryID"], DBNull.Value) ? 0 : Convert.ToInt32(reader["intSupplementaryID"]),
SupplementaryCode = ReferenceEquals(reader["strSupplementaryCode"], DBNull.Value) ? string.Empty : Convert.ToString(reader["strSupplementaryCode"]),
Supplementary = ReferenceEquals(reader["strSupplementary"], DBNull.Value) ? string.Empty : Convert.ToString(reader["strSupplementary"]),
Debit = ReferenceEquals(reader["curDebit"], DBNull.Value) ? 0 : Convert.ToDecimal(reader["curDebit"]),
Credit = ReferenceEquals(reader["curCredit"], DBNull.Value) ? 0 : Convert.ToDecimal(reader["curCredit"]),
IndividualSubsidiaryID = ReferenceEquals(reader["intIndividualSubsidiaryID"], DBNull.Value) ? 0 : Convert.ToInt32(reader["intIndividualSubsidiaryID"]),
IndividualSupplementaryID = ReferenceEquals(reader["intIndividualSupplementaryID"], DBNull.Value) ? 0 : Convert.ToInt32(reader["intIndividualSupplementaryID"]),
};
glentries.Add(glentry);
}
return(glentries);
}
}
}
}
public static List <GLEntries> GetDetailEntryLedger(string reference)
{
var dbUtil = new DatabaseManager();
var glentries = new List <GLEntries>();
using (var conn = new SqlConnection(dbUtil.getSQLConnectionString("MainDB")))
{
conn.Open();
using (SqlCommand cmd = conn.CreateCommand())
{
cmd.CommandType = CommandType.StoredProcedure;
cmd.CommandText = "spDisGetBudgetAnalysisDetailEntry";
cmd.CommandTimeout = 180;
cmd.Parameters.AddWithValue("@strReference", reference);
using (SqlDataReader reader = cmd.ExecuteReader())
{
while (reader.Read())
{
var glentry = new GLEntries
{
GLEntryID = ReferenceEquals(reader["intBudgetID"], DBNull.Value) ? 0 : Convert.ToInt32(reader["intBudgetID"]),
COAID = ReferenceEquals(reader["intCOAID"], DBNull.Value) ? 0 : Convert.ToInt32(reader["intCOAID"]),
COACode = ReferenceEquals(reader["strCOACode"], DBNull.Value) ? string.Empty : Convert.ToString(reader["strCOACode"]),
COA = ReferenceEquals(reader["strCOA"], DBNull.Value) ? string.Empty : Convert.ToString(reader["strCOA"]),
SubsidiaryID = ReferenceEquals(reader["intCOASuppType"], DBNull.Value) ? 0 : Convert.ToInt32(reader["intCOASuppType"]),
Exname = ReferenceEquals(reader["strExpName"], DBNull.Value) ? string.Empty : Convert.ToString(reader["strExpName"]),
Credit = ReferenceEquals(reader["curJan"], DBNull.Value) ? 0 : Convert.ToDecimal(reader["curJan"]),
FebAmount = ReferenceEquals(reader["curFeb"], DBNull.Value) ? 0 : Convert.ToDecimal(reader["curFeb"]),
MarAmount = ReferenceEquals(reader["curMarch"], DBNull.Value) ? 0 : Convert.ToDecimal(reader["curMarch"]),
AprAmount = ReferenceEquals(reader["curApril"], DBNull.Value) ? 0 : Convert.ToDecimal(reader["curApril"]),
MayAmount = ReferenceEquals(reader["curMay"], DBNull.Value) ? 0 : Convert.ToDecimal(reader["curMay"]),
JunAmount = ReferenceEquals(reader["curJun"], DBNull.Value) ? 0 : Convert.ToDecimal(reader["curJun"]),
JulAmount = ReferenceEquals(reader["curJul"], DBNull.Value) ? 0 : Convert.ToDecimal(reader["curJul"]),
AugAmount = ReferenceEquals(reader["curAug"], DBNull.Value) ? 0 : Convert.ToDecimal(reader["curAug"]),
SepAmount = ReferenceEquals(reader["curSept"], DBNull.Value) ? 0 : Convert.ToDecimal(reader["curSept"]),
OctAmount = ReferenceEquals(reader["curOct"], DBNull.Value) ? 0 : Convert.ToDecimal(reader["curOct"]),
NovAmount = ReferenceEquals(reader["curNov"], DBNull.Value) ? 0 : Convert.ToDecimal(reader["curNov"]),
DecAmount = ReferenceEquals(reader["curDec"], DBNull.Value) ? 0 : Convert.ToDecimal(reader["curDec"]),
//GLEntryID = ReferenceEquals(reader["intGLEntryID"], DBNull.Value) ? 0 : Convert.ToInt32(reader["intGLEntryID"]),
//COAID = ReferenceEquals(reader["intCOAID"], DBNull.Value) ? 0 : Convert.ToInt32(reader["intCOAID"]),
//COACode = ReferenceEquals(reader["strCOACode"], DBNull.Value) ? string.Empty : Convert.ToString(reader["strCOACode"]),
//COA = ReferenceEquals(reader["strCOA"], DBNull.Value) ? string.Empty : Convert.ToString(reader["strCOA"]),
//SubsidiaryID = ReferenceEquals(reader["intSubsidiaryID"], DBNull.Value) ? 0 : Convert.ToInt32(reader["intSubsidiaryID"]),
//SubsidiaryCode = ReferenceEquals(reader["strSubsidiaryCode"], DBNull.Value) ? string.Empty : Convert.ToString(reader["strSubsidiaryCode"]),
//Subsidiary = ReferenceEquals(reader["strSubsidiary"], DBNull.Value) ? string.Empty : Convert.ToString(reader["strSubsidiary"]),
//SupplementaryID = ReferenceEquals(reader["intSupplementaryID"], DBNull.Value) ? 0 : Convert.ToInt32(reader["intSupplementaryID"]),
//SupplementaryCode = ReferenceEquals(reader["strSupplementaryCode"], DBNull.Value) ? string.Empty : Convert.ToString(reader["strSupplementaryCode"]),
//Supplementary = ReferenceEquals(reader["strSupplementary"], DBNull.Value) ? string.Empty : Convert.ToString(reader["strSupplementary"]),
//Debit = ReferenceEquals(reader["curDebit"], DBNull.Value) ? 0 : Convert.ToDecimal(reader["curDebit"]),
//Credit = ReferenceEquals(reader["curCredit"], DBNull.Value) ? 0 : Convert.ToDecimal(reader["curCredit"]),
//IndividualSubsidiaryID = ReferenceEquals(reader["intIndividualSubsidiaryID"], DBNull.Value) ? 0 : Convert.ToInt32(reader["intIndividualSubsidiaryID"]),
//IndividualSupplementaryID = ReferenceEquals(reader["intIndividualSupplementaryID"], DBNull.Value) ? 0 : Convert.ToInt32(reader["intIndividualSupplementaryID"]),
};
glentries.Add(glentry);
}
return(glentries);
}
}
}
}
