/// <summary>
/// Method to Get Programs
/// </summary>
/// <param name="argEn">ProgramInfo Entity as Input.SAFC_Code as Input Property.</param>
/// <returns>Returns List Of Programs</returns>
public List <ProgramInfoEn> GetList(ProgramInfoEn argEn)
{
try
{
ProgramInfoDAL loDs = new ProgramInfoDAL();
return(loDs.GetList(argEn));
}
catch (Exception ex)
{
throw ex;
}
}
/// <summary>
/// Method to Get ProgramInfo Entity
/// </summary>
/// <param name="argEn">ProgramInfo Entity is an Input.SAPG_SName as Input Property.</param>
/// <returns>Returns ProgramInfo Entity</returns>
public ProgramInfoEn GetItem(ProgramInfoEn argEn)
{
try
{
ProgramInfoDAL loDs = new ProgramInfoDAL();
return(loDs.GetItem(argEn));
}
catch (Exception ex)
{
throw ex;
}
}
/// <summary>
/// Method to Check Validation
/// </summary>
/// <param name="argEn">ProgramInfo Entity is as Input.</param>
/// <returns>Returns a Boolean</returns>
public bool IsValid(ProgramInfoEn argEn)
{
try
{
if (argEn.ProgramCode == null || argEn.ProgramCode.ToString().Length <= 0)
{
throw new Exception("ProgramCode Is Required!");
}
if (argEn.Program == null || argEn.Program.ToString().Length <= 0)
{
throw new Exception("Program Is Required!");
}
return(true);
}
catch (Exception ex)
{
throw ex;
}
}
/// <summary>
/// Method to Delete ProgramInfo
/// </summary>
/// <param name="argEn">ProgramInfo Entity is an Input.</param>
/// <returns>Returns Boolean</returns>
public bool Delete(ProgramInfoEn argEn)
{
bool flag;
using (TransactionScope ts = new TransactionScope())
{
try
{
ProgramInfoDAL loDs = new ProgramInfoDAL();
flag = loDs.Delete(argEn);
ts.Complete();
}
catch (Exception ex)
{
throw ex;
}
}
return(flag);
}
public List <ProgramInfoEn> GetProgramBySponsor(string Sponsor)
{
List <ProgramInfoEn> loEnList = new List <ProgramInfoEn>();
string sqlCmd = @"select distinct prog.* from sas_student stu
inner join sas_studentSpon sspon on stu.sasi_matricno = sspon.sasi_matricno
inner join sas_program prog on stu.sasi_pgid = prog.sapg_code
inner join sas_feestruct fs on fs.sapg_code = stu.sasi_pgid and stu.sasi_cursemyr = fs.sast_code
inner join sas_feestramount fsa on fsa.safs_code = fs.safs_code and stu.sasc_code = fsa.sasc_code
inner join sas_sponsorfeetypes sft on sft.saft_code = fsa.saft_code and sft.sasr_code = sspon.sass_sponsor
where sspon.sass_sponsor = " + clsGeneric.AddQuotes(Sponsor)
+ " and stu.SASI_Reg_Status =" + Helper.StuRegistered
+ " and stu.sass_code =" + clsGeneric.AddQuotes(Helper.StuActive);
try
{
if (!FormHelp.IsBlank(sqlCmd))
{
using (IDataReader argReader = _DatabaseFactory.ExecuteReader(Helper.GetDataBaseType,
DataBaseConnectionString, sqlCmd).CreateDataReader())
{
while (argReader.Read())
{
ProgramInfoEn loItem = new ProgramInfoEn();
loItem.ProgramCode = GetValue <string>(argReader, "SAPG_Code");
loItem.Program = GetValue <string>(argReader, "SAPG_Program");
loEnList.Add(loItem);
}
argReader.Close();
}
}
}
catch (Exception ex)
{
throw ex;
}
return(loEnList);
}
