public void GetOldBalanceDescriptionFromDb()
{
//otherFeesCollect = new List<OtherFeesItem>();
oldBalanceCollect.Clear();
using (var db = Connection.CreateConnection())
{
db.Open();
var sql = "dbo.spGetOldBalanceByDescription";
var cmd = new SqlCommand(sql, db);
var reader = cmd.ExecuteReader();
if (!reader.HasRows)
{
return;
}
while (reader.Read())
{
var item = new OldBalanceItem();
item.OldFees_Description = reader["OldFees_Description"].ToString();
if (oldBalanceCollect.Count == 0)
{
oldBalanceCollect.Add(item);
}
else if (oldBalanceCollect.All(x => (x.OldFees_Description != item.OldFees_Description)))
{
oldBalanceCollect.Add(item);
}
}
db.Close();
}
}
public void LoadOldBalanceWithStdIdFromDb(int stdId)
{
oldBalanceCollect = new List <OldBalanceItem>();
oldBalanceCollect.Clear();
using (var db = Connection.CreateConnection())
{
db.Open();
var sql = "dbo.spLoadOldBalanceWithStdId";
var cmd = new SqlCommand(sql, db);
cmd.CommandType = CommandType.StoredProcedure;
cmd.Parameters.Add(new SqlParameter("StdId", stdId));
var reader = cmd.ExecuteReader();
if (!reader.HasRows)
{
return;
}
while (reader.Read())
{
var item = new OldBalanceItem();
item.OldFees_Id = Int32.Parse(reader["OldFees_Id"].ToString());
item.OldFees_Std_Id = Int32.Parse(reader["OldFees_Std_Id"].ToString());
item.OldFees_Bill_Id = Int32.Parse(reader["OldFees_Bill_Id"].ToString());
item.OldFees_Description = reader["OldFees_Description"].ToString();
item.OldFees_PaymentNumber = Int32.Parse(reader["OldFees_PaymentNumber"].ToString());
item.OldFees_Amount = Decimal.Parse(reader["OldFees_Amount"].ToString());
item.OldFees_Payment = Decimal.Parse(reader["OldFees_Payment"].ToString());
item.OldFees_DatePaid = reader["OldFees_DatePaid"].ToString();
item.OldFees_PaymentMade = Decimal.Parse(reader["OldFees_PaymentMade"].ToString());
item.OldFees_Balance = Decimal.Parse(reader["OldFees_Balance"].ToString());
item.OldFees_Status = Boolean.Parse(reader["OldFees_Status"].ToString());
item.OldFees_Deleted = reader["OldFees_Deleted"].ToString();
oldBalanceCollect.Add(item);
}
db.Close();
}
}
public void GetOldBalanceWithStdIdDescriptionFromDb(int stdId)
{
//otherFeesCollect = new List<OtherFeesItem>();
oldBalanceCollect.Clear();
using (var db = Connection.CreateConnection())
{
db.Open();
var sql = "dbo.spGetOldBalanceWithStdIdByDescription";
var cmd = new SqlCommand(sql, db);
cmd.CommandType = CommandType.StoredProcedure;
cmd.Parameters.Add(new SqlParameter("@StdId", stdId));
var reader = cmd.ExecuteReader();
if (!reader.HasRows)
{
return;
}
while (reader.Read())
{
var item = new OldBalanceItem();
item.OldFees_Description = reader["OldFees_Description"].ToString();
if (oldBalanceCollect.Count == 0)
{
oldBalanceCollect.Add(item);
}
else if (oldBalanceCollect.All(x => (x.OldFees_Description != item.OldFees_Description)))
{
oldBalanceCollect.Add(item);
}
}
db.Close();
}
}