public static CustomList <MedicalReinSetup> GetAllMedicalReinSetup(string fyKey, string empKey)
{
ConnectionManager conManager = new ConnectionManager(ConnectionName.HR);
CustomList <MedicalReinSetup> MedicalReinSetupCollection = new CustomList <MedicalReinSetup>();
IDataReader reader = null;
String sql = "select *from MedicalReinSetup Where FYKey=" + fyKey + " and EmpKey=" + empKey;
try
{
conManager.OpenDataReader(sql, out reader);
while (reader.Read())
{
MedicalReinSetup newMedicalReinSetup = new MedicalReinSetup();
newMedicalReinSetup.SetData(reader);
MedicalReinSetupCollection.Add(newMedicalReinSetup);
}
return(MedicalReinSetupCollection);
}
catch (Exception ex)
{
throw (ex);
}
finally
{
if (reader != null && !reader.IsClosed)
{
reader.Close();
}
}
}
public static MedicalReinSetup GetAllMedicalBalance(string fyKey, string empKey)
{
ConnectionManager conManager = new ConnectionManager(ConnectionName.HR);
IDataReader reader = null;
String sql = "EXEC spGetMedicalAllowance " + empKey + "," + fyKey;
try
{
conManager.OpenDataReader(sql, out reader);
MedicalReinSetup newMedicalReinSetup = new MedicalReinSetup();
while (reader.Read())
{
newMedicalReinSetup.SelfLimit = reader.GetDecimal("SelfLimit");
newMedicalReinSetup.FamilyLimit = reader.GetDecimal("FamilyLimit");
newMedicalReinSetup.SelfPaid = reader.GetDecimal("SelfPaid");
newMedicalReinSetup.FamilyPaid = reader.GetDecimal("FamilyPaid");
newMedicalReinSetup.MaternityLimit = reader.GetDecimal("MaternityLimit");
newMedicalReinSetup.MaternityPaid = reader.GetDecimal("MaternityPaid");
}
return(newMedicalReinSetup);
}
catch (Exception ex)
{
throw (ex);
}
finally
{
if (reader != null && !reader.IsClosed)
{
reader.Close();
}
}
}
public static CustomList <MedicalReinSetup> GetAllMedicalReinSetup()
{
ConnectionManager conManager = new ConnectionManager(ConnectionName.HR);
CustomList <MedicalReinSetup> MedicalReinSetupCollection = new CustomList <MedicalReinSetup>();
IDataReader reader = null;
const String sql = "select *from MedicalReinSetup";
try
{
conManager.OpenDataReader(sql, out reader);
while (reader.Read())
{
MedicalReinSetup newMedicalReinSetup = new MedicalReinSetup();
newMedicalReinSetup.SetData(reader);
MedicalReinSetupCollection.Add(newMedicalReinSetup);
}
MedicalReinSetupCollection.InsertSpName = "spInsertMedicalReinSetup";
MedicalReinSetupCollection.UpdateSpName = "spUpdateMedicalReinSetup";
MedicalReinSetupCollection.DeleteSpName = "spDeleteMedicalReinSetup";
return(MedicalReinSetupCollection);
}
catch (Exception ex)
{
throw (ex);
}
finally
{
if (reader != null && !reader.IsClosed)
{
reader.Close();
}
}
}