public static List <IndividualSubsidiary> GetIndividualSubsidiary()
{
var dbUtil = new DatabaseManager();
var indvsubsidiaries = new List <IndividualSubsidiary>();
using (var conn = new SqlConnection(dbUtil.getSQLConnectionString("MainDB")))
{
conn.Open();
using (SqlCommand cmd = conn.CreateCommand())
{
cmd.CommandType = CommandType.StoredProcedure;
cmd.CommandText = "spDisGetPCFIndvSubsidiary";
cmd.CommandTimeout = 180;
using (SqlDataReader reader = cmd.ExecuteReader())
{
while (reader.Read())
{
var indvsubsidiary = new IndividualSubsidiary
{
IndividualSubsidiaryID = ReferenceEquals(reader["intIndividualSubsidiaryID"], DBNull.Value) ? 0 : Convert.ToInt32(reader["intIndividualSubsidiaryID"]),
Code = ReferenceEquals(reader["strCode"], DBNull.Value) ? string.Empty : Convert.ToString(reader["strCode"]),
Description = ReferenceEquals(reader["strDescription"], DBNull.Value) ? string.Empty : Convert.ToString(reader["strDescription"]),
SubsidiaryID = ReferenceEquals(reader["intSubsidiaryID"], DBNull.Value) ? 0 : Convert.ToInt32(reader["intSubsidiaryID"]),
COAID = ReferenceEquals(reader["intCOAID"], DBNull.Value) ? 0 : Convert.ToInt32(reader["intCOAID"])
};
indvsubsidiaries.Add(indvsubsidiary);
}
return(indvsubsidiaries);
}
}
}
}
public static List <IndividualSubsidiary> GetEntryLedgerIndividualSubsidiary(string criteria, int subsidiaryid)
{
var dbUtil = new DatabaseManager();
var individualSubsidiaries = new List <IndividualSubsidiary>();
using (var conn = new SqlConnection(dbUtil.getSQLConnectionString("MainDB")))
{
conn.Open();
using (SqlCommand cmd = conn.CreateCommand())
{
cmd.CommandType = CommandType.StoredProcedure;
cmd.CommandText = "spDisCVFGetIndividualSubsidiary";
cmd.CommandTimeout = 180;
cmd.Parameters.AddWithValue("@strCriteria", criteria);
cmd.Parameters.AddWithValue("@intSubsidiaryID", subsidiaryid);
using (SqlDataReader reader = cmd.ExecuteReader())
{
while (reader.Read())
{
var individualSubsidiary = new IndividualSubsidiary
{
IndividualSubsidiaryID = ReferenceEquals(reader["intIndividualSubsidiaryID"], DBNull.Value) ? 0 : Convert.ToInt32(reader["intIndividualSubsidiaryID"]),
Description = ReferenceEquals(reader["strDescription"], DBNull.Value) ? string.Empty : Convert.ToString(reader["strDescription"])
};
individualSubsidiaries.Add(individualSubsidiary);
}
}
}
}
return(individualSubsidiaries);
}
public static List <IndividualSubsidiary> GetFormIndividualSubsidiary(int branchID, string criteria)
{
var dbUtil = new DatabaseManager();
var payees = new List <IndividualSubsidiary>();
using (var conn = new SqlConnection(dbUtil.getSQLConnectionString("MainDB")))
{
conn.Open();
using (SqlCommand cmd = conn.CreateCommand())
{
cmd.CommandType = CommandType.StoredProcedure;
cmd.CommandText = "spDisGetPCFFormIndividualSubsidiary";
cmd.CommandTimeout = 180;
cmd.Parameters.Clear();
cmd.Parameters.AddWithValue("@intIDMasLocation", branchID);
cmd.Parameters.AddWithValue("@strCriteria", criteria);
using (SqlDataReader reader = cmd.ExecuteReader())
{
while (reader.Read())
{
var payee = new IndividualSubsidiary
{
IndividualSubsidiaryID = ReferenceEquals(reader["intIndividualSubsidiaryID"], DBNull.Value) ? 0 : Convert.ToInt32(reader["intIndividualSubsidiaryID"]),
Code = ReferenceEquals(reader["strCode"], DBNull.Value) ? string.Empty : Convert.ToString(reader["strCode"]),
Description = ReferenceEquals(reader["strDescription"], DBNull.Value) ? string.Empty : Convert.ToString(reader["strDescription"]),
SubsidiaryID = ReferenceEquals(reader["intSubsidiaryID"], DBNull.Value) ? 0 : Convert.ToInt32(reader["intSubsidiaryID"]),
SubsidiaryName = ReferenceEquals(reader["strSubsidiaryName"], DBNull.Value) ? string.Empty : Convert.ToString(reader["strSubsidiaryName"]),
COAID = ReferenceEquals(reader["intCOAID"], DBNull.Value) ? 0 : Convert.ToInt32(reader["intCOAID"]),
COAName = ReferenceEquals(reader["strCOAName"], DBNull.Value) ? string.Empty : Convert.ToString(reader["strCOAName"])
};
payees.Add(payee);
}
return(payees);
}
}
}
}
