/// <summary>
/// Method to Get StudentSponsor FeeTypes
/// </summary>
/// <param name="argEn">StuSponFeeTypes Entity as an Input.MatricNo as Input Property.</param>
/// <returns>Returns StuSponFeeTypes Entity</returns>
public List <StuSponFeeTypesEn> GetStuSponFTList(StuSponFeeTypesEn argEn)
{
List <StuSponFeeTypesEn> loEnList = new List <StuSponFeeTypesEn>();
string sqlCmd = "SELECT SAS_StuSponFeeTypes.*, SAS_FeeTypes.SAFT_Desc , SAS_Student.SASI_MatricNo " +
"FROM SAS_FeeTypes INNER JOIN SAS_StuSponFeeTypes ON SAS_FeeTypes.SAFT_Code = SAS_StuSponFeeTypes.SAFT_Code INNER JOIN " +
"SAS_Student ON SAS_StuSponFeeTypes.SASI_MatricNo = SAS_Student.SASI_MatricNo where SAS_Student.SASI_MatricNo='" + argEn.MatricNo + "' and SAS_StuSponFeeTypes.SASR_Code = '" + argEn.SASR_Code + "'";
try
{
if (!FormHelp.IsBlank(sqlCmd))
{
using (IDataReader loReader = _DatabaseFactory.ExecuteReader(Helper.GetDataBaseType,
DataBaseConnectionString, sqlCmd).CreateDataReader())
{
while (loReader.Read())
{
StuSponFeeTypesEn loItem = LoadObject(loReader);
loItem.FeeDesc = GetValue <string>(loReader, "SAFT_Desc");
loEnList.Add(loItem);
}
loReader.Close();
}
}
}
catch (Exception ex)
{
throw ex;
}
return(loEnList);
}
/// <summary>
/// Method to Get StudentSponsor FeeTypes
/// </summary>
/// <param name="argEn">StuSponFeeTypes Entity as an Input.</param>
/// <returns>Returns StuSponFeeTypes Entity</returns>
public List <StuSponFeeTypesEn> GetList(StuSponFeeTypesEn argEn)
{
List <StuSponFeeTypesEn> loEnList = new List <StuSponFeeTypesEn>();
string sqlCmd = "select * from SAS_StuSponFeeTypes";
try
{
if (!FormHelp.IsBlank(sqlCmd))
{
using (IDataReader loReader = _DatabaseFactory.ExecuteReader(Helper.GetDataBaseType,
DataBaseConnectionString, sqlCmd).CreateDataReader())
{
while (loReader.Read())
{
StuSponFeeTypesEn loItem = LoadObject(loReader);
loEnList.Add(loItem);
}
loReader.Close();
}
}
}
catch (Exception ex)
{
throw ex;
}
return(loEnList);
}
/// <summary>
/// Method to Delete StudentSponsor FeeTypes
/// </summary>
/// <param name="argEn">StuSponFeeTypes Entity is an Input.MatricNo as Input Property.</param>
/// <returns>Returns Boolean</returns>
public bool Delete(StuSponFeeTypesEn argEn)
{
bool lbRes = false;
string sqlCmd = "DELETE FROM SAS_StuSponFeeTypes WHERE SASI_MatricNo = @SASI_MatricNo";
try
{
if (!FormHelp.IsBlank(sqlCmd))
{
DbCommand cmd = _DatabaseFactory.GetDbCommand(Helper.GetDataBaseType, sqlCmd, DataBaseConnectionString);
_DatabaseFactory.AddInParameter(ref cmd, "@SASI_MatricNo", DbType.String, argEn.MatricNo);
_DbParameterCollection = cmd.Parameters;
int liRowAffected = _DatabaseFactory.ExecuteNonQuery(Helper.GetDataBaseType, cmd,
DataBaseConnectionString, sqlCmd, _DbParameterCollection);
if (liRowAffected > -1)
{
lbRes = true;
}
else
{
throw new Exception("Insertion Failed! No Row has been updated...");
}
}
}
catch (Exception ex)
{
throw ex;
}
return(lbRes);
}
/// <summary>
/// Method to Get StudentSponsor FeeTypes Entity
/// </summary>
/// <param name="argEn">StudentSponFeeTypes Entity is an Input.MatricNo as Input Property.</param>
/// <returns>Returns StudentSponFeeTypes Entity</returns>
public StuSponFeeTypesEn GetItem(StuSponFeeTypesEn argEn)
{
StuSponFeeTypesEn loItem = new StuSponFeeTypesEn();
string sqlCmd = "Select * FROM SAS_StuSponFeeTypes WHERE SASI_MatricNo = @SASI_MatricNo";
try
{
if (!FormHelp.IsBlank(sqlCmd))
{
DbCommand cmd = _DatabaseFactory.GetDbCommand(Helper.GetDataBaseType, sqlCmd, DataBaseConnectionString);
_DatabaseFactory.AddInParameter(ref cmd, "@SASI_MatricNo", DbType.String, argEn.MatricNo);
_DbParameterCollection = cmd.Parameters;
using (IDataReader loReader = _DatabaseFactory.GetIDataReader(Helper.GetDataBaseType, cmd,
DataBaseConnectionString, sqlCmd, _DbParameterCollection).CreateDataReader())
{
if (loReader != null)
{
loReader.Read();
loItem = LoadObject(loReader);
}
loReader.Close();
}
}
}
catch (Exception ex)
{
throw ex;
}
return(loItem);
}
/// <summary>
/// Method to Insert StudentSponsor FeeTypes
/// </summary>
/// <param name="argEn">StudentSponsor Entity is an Input.</param>
/// <returns>Returns Boolean</returns>
public bool Update(StuSponFeeTypesEn argEn)
{
bool lbRes = false;
int iOut = 0;
string sqlCmd = "Select count(*) as cnt From SAS_StuSponFeeTypes WHERE SASI_MatricNo = @SASI_MatricNo";
try
{
if (!FormHelp.IsBlank(sqlCmd))
{
DbCommand cmdSel = _DatabaseFactory.GetDbCommand(Helper.GetDataBaseType, sqlCmd, DataBaseConnectionString);
_DatabaseFactory.AddInParameter(ref cmdSel, "@SASI_MatricNo", DbType.String, argEn.MatricNo);
_DbParameterCollection = cmdSel.Parameters;
using (IDataReader dr = _DatabaseFactory.GetIDataReader(Helper.GetDataBaseType, cmdSel,
DataBaseConnectionString, sqlCmd, _DbParameterCollection).CreateDataReader())
{
if (dr.Read())
{
iOut = clsGeneric.NullToInteger(dr["cnt"]);
}
if (iOut > 0)
{
throw new Exception("Update Failed! No Record Exist!");
}
}
if (iOut == 0)
{
sqlCmd = "UPDATE SAS_StuSponFeeTypes SET SASI_MatricNo = @SASI_MatricNo, SASR_Code = @SASR_Code, SAFT_Code = @SAFT_Code WHERE SASI_MatricNo = @SASI_MatricNo";
if (!FormHelp.IsBlank(sqlCmd))
{
DbCommand cmd = _DatabaseFactory.GetDbCommand(Helper.GetDataBaseType, sqlCmd, DataBaseConnectionString);
_DatabaseFactory.AddInParameter(ref cmd, "@SASI_MatricNo", DbType.String, argEn.MatricNo);
_DatabaseFactory.AddInParameter(ref cmd, "@SASR_Code", DbType.String, argEn.SASR_Code);
_DatabaseFactory.AddInParameter(ref cmd, "@SAFT_Code", DbType.String, argEn.SAFT_Code);
_DbParameterCollection = cmd.Parameters;
int liRowAffected = _DatabaseFactory.ExecuteNonQuery(Helper.GetDataBaseType, cmd,
DataBaseConnectionString, sqlCmd, _DbParameterCollection);
if (liRowAffected > -1)
{
lbRes = true;
}
else
{
throw new Exception("Update Failed! No Row has been updated...");
}
}
}
}
}
catch (Exception ex)
{
throw ex;
}
return(lbRes);
}
/// <summary>
/// Method to Load StudentSponsor FeeTypes Entity
/// </summary>
/// <param name="argReader">IDataReader Object is an Input.</param>
/// <returns>Returns StuSponFeeTypes Entity</returns>
private StuSponFeeTypesEn LoadObject(IDataReader argReader)
{
StuSponFeeTypesEn loItem = new StuSponFeeTypesEn();
loItem.MatricNo = GetValue <string>(argReader, "SASI_MatricNo");
loItem.SASR_Code = GetValue <string>(argReader, "SASR_Code");
loItem.SAFT_Code = GetValue <string>(argReader, "SAFT_Code");
return(loItem);
}
/// <summary>
/// Method to Check Validation
/// </summary>
/// <param name="argEn">StuSponFeeTypes Entity is as Input.</param>
/// <returns>Returns a Boolean</returns>
public bool IsValid(StuSponFeeTypesEn argEn)
{
try
{
return(true);
}
catch (Exception ex)
{
throw ex;
}
}
/// <summary>
/// Method to Get StudentSponsor FeeTypes Entity
/// </summary>
/// <param name="argEn">StudentSponFeeTypes Entity is an Input.MatricNo as Input Property.</param>
/// <returns>Returns StudentSponFeeTypes Entity</returns>
public StuSponFeeTypesEn GetItem(StuSponFeeTypesEn argEn)
{
try
{
StuSponFeeTypesDAL loDs = new StuSponFeeTypesDAL();
return(loDs.GetItem(argEn));
}
catch (Exception ex)
{
throw ex;
}
}
/// <summary>
/// Method to Get StudentSponsor FeeTypes
/// </summary>
/// <param name="argEn">StuSponFeeTypes Entity as an Input.MatricNo as Input Property.</param>
/// <returns>Returns StuSponFeeTypes Entity</returns>
public List <StuSponFeeTypesEn> GetStuSpnFTList(StuSponFeeTypesEn argEn)
{
try
{
StuSponFeeTypesDAL loDs = new StuSponFeeTypesDAL();
return(loDs.GetStuSponFTList(argEn));
}
catch (Exception ex)
{
throw ex;
}
}
/// <summary>
/// Method to Update StudentSponsor FeeTypes
/// </summary>
/// <param name="argEn">StudentSponsor Entity is an Input.</param>
/// <returns>Returns Boolean</returns>
public bool Update(StuSponFeeTypesEn argEn)
{
bool flag;
using (TransactionScope ts = new TransactionScope())
{
try
{
StuSponFeeTypesDAL loDs = new StuSponFeeTypesDAL();
flag = loDs.Update(argEn);
ts.Complete();
}
catch (Exception ex)
{
throw ex;
}
}
return(flag);
}
/// <summary>
/// Method to Get List of All StudentSponsors
/// </summary>
/// <param name="argEn">StudentSponsor Entity as an Input.MatricNo as Input Property.</param>
/// <returns>Returns List of StudentSponsor</returns>
public List <StudentSponEn> GetStuSponserList(StudentSponEn argEn)
{
List <StudentSponEn> loEnList = new List <StudentSponEn>();
//string sqlCmd = "select SS.*,SP.SASR_Name from sas_StudentSpon SS,sas_Sponsor SP where SS.SASS_Sponsor=SP.SASR_Code";
string sqlCmd = "SELECT SAS_StudentSpon.SASI_MatricNo, SAS_StudentSpon.SASS_Sponsor, SAS_Sponsor.SASR_Name, SAS_StudentSpon.SASS_SDate, " +
" SAS_StudentSpon.SASS_EDate, SAS_StudentSpon.SASS_Status, SAS_StudentSpon.SASS_Num, SAS_StudentSpon.SASS_Type, SAS_StudentSpon.SASS_Limit " +
" FROM SAS_Student INNER JOIN SAS_StudentSpon ON SAS_Student.SASI_MatricNo = SAS_StudentSpon.SASI_MatricNo INNER JOIN " +
" SAS_Sponsor ON SAS_StudentSpon.SASS_Sponsor = SAS_Sponsor.SASR_Code WHERE SAS_StudentSpon.SASI_MatricNo ='" + argEn.MatricNo + "'";
try
{
if (!FormHelp.IsBlank(sqlCmd))
{
using (IDataReader loReader = _DatabaseFactory.ExecuteReader(Helper.GetDataBaseType,
DataBaseConnectionString, sqlCmd).CreateDataReader())
{
while (loReader.Read())
{
StudentSponEn loItem = LoadObject(loReader);
loItem.Name = GetValue <string>(loReader, "SASR_Name");
StuSponFeeTypesDAL loStuSpnFTDal = new StuSponFeeTypesDAL();
StuSponFeeTypesEn loStuSpnFTEn = new StuSponFeeTypesEn();
loStuSpnFTEn.MatricNo = loItem.MatricNo;
loStuSpnFTEn.SASR_Code = loItem.Sponsor;
loItem.ListStuSponFeeTypes = loStuSpnFTDal.GetStuSponFTList(loStuSpnFTEn);
loEnList.Add(loItem);
}
loReader.Close();
}
}
}
catch (Exception ex)
{
throw ex;
}
return(loEnList);
}
