/// <s
/// ummary>
/// Method to Delete HostelStrAmount
/// </summary>
/// <param name="argEn">HostelStrAmount Entity is an Input.</param>
/// <returns>Returns Boolean</returns>
public bool Delete(HostelStrAmountEn argEn)
{
bool lbRes = false;
string sqlCmd = "DELETE FROM SAS_HostelStrAmount WHERE SAHS_Code = @SAHS_Code";
try
{
if (!FormHelp.IsBlank(sqlCmd))
{
DbCommand cmd = _DatabaseFactory.GetDbCommand(Helper.GetDataBaseType, sqlCmd, DataBaseConnectionString);
_DatabaseFactory.AddInParameter(ref cmd, "@SAHS_Code", DbType.String, argEn.HSCode);
_DbParameterCollection = cmd.Parameters;
int liRowAffected = _DatabaseFactory.ExecuteNonQuery(Helper.GetDataBaseType, cmd,
DataBaseConnectionString, sqlCmd, _DbParameterCollection);
if (liRowAffected > -1)
{
lbRes = true;
}
else
{
throw new Exception("Deletion Failed! No Row has been updated...");
}
}
}
catch (Exception ex)
{
throw ex;
}
return(lbRes);
}
/// <summary>
/// Method to Get List of HostelStructureAmount
/// </summary>
/// <param name="argEn">HostelStrAmount Entity is an Input.</param>
/// <returns>Returns List of HostelStrAmounts</returns>
public List <HostelStrAmountEn> GetList(HostelStrAmountEn argEn)
{
List <HostelStrAmountEn> loEnList = new List <HostelStrAmountEn>();
string sqlCmd = "select * from SAS_HostelStrAmount";
try
{
if (!FormHelp.IsBlank(sqlCmd))
{
using (IDataReader loReader = _DatabaseFactory.ExecuteReader(Helper.GetDataBaseType,
DataBaseConnectionString, sqlCmd).CreateDataReader())
{
while (loReader.Read())
{
HostelStrAmountEn loItem = LoadObject(loReader);
loEnList.Add(loItem);
}
loReader.Close();
}
}
}
catch (Exception ex)
{
throw ex;
}
return(loEnList);
}
/// <summary>
/// Method to Get HostelStrAmount Entity
/// </summary>
/// <param name="argEn">HostelStrAmount Entity is an Input.HSCode as Input Property.</param>
/// <returns>Returns HostelStrAmount Entity</returns>
public HostelStrAmountEn GetItem(HostelStrAmountEn argEn)
{
HostelStrAmountEn loItem = new HostelStrAmountEn();
string sqlCmd = "Select * FROM SAS_HostelStrAmount WHERE SAHS_Code = @SAHS_Code";
try
{
if (!FormHelp.IsBlank(sqlCmd))
{
DbCommand cmd = _DatabaseFactory.GetDbCommand(Helper.GetDataBaseType, sqlCmd, DataBaseConnectionString);
_DatabaseFactory.AddInParameter(ref cmd, "@SAHS_Code", DbType.String, argEn.HSCode);
_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);
}
//Created By : Jessica
//Created Date : 19/02/16
/// <summary>
/// Method to Get List of Hostel Amounts
/// </summary>
/// <param name="argEn">HostelStruct Entity is an Input.HSCode as input Property</param>
/// <returns>Returns List of HostelStruct</returns>
public List <HostelStructEn> GetHostelDetailsAmtList(HostelStructEn argEn)
{
List <HostelStructEn> loEnList = new List <HostelStructEn>();
string sqlCmd = @"
select hsd.SAHS_Code , hsd.saft_code, hsd.sahd_priority,
hsd.safs_taxmode, ft.*,
local.saha_amount as Local_Amount, local.safa_gstamount as Local_GSTAmount, nonlocal.saha_amount as NonLocal_Amount, nonlocal.safa_gstamount as NonLocal_GSTAmount
, local.sasc_code as Local_Category, nonlocal.sasc_code as NonLocal_Category, hsd.sahd_type
from sas_hostelstrDetails hsd
inner join SAS_FeeTypes ft on ft.saft_code = hsd.saft_code
left join (select saha_amount, safa_gstamount, sahs_code, saft_code, sasc_code from sas_hostelstrAmount where sas_hostelstrAmount.sasc_code in ('Local', 'W') )as local on local.sahs_code = hsd.sahs_code and local.saft_code = hsd.saft_code
left join (select saha_amount, safa_gstamount, sahs_code, saft_code, sasc_code from sas_hostelstrAmount where sas_hostelstrAmount.sasc_code in ('International', 'BW') )as nonlocal on nonlocal.sahs_code = hsd.sahs_code and nonlocal.saft_code = hsd.saft_code
WHERE hsd.SAHS_Code = @SAHS_Code";
sqlCmd = sqlCmd + " order by hsd.saft_code";
try
{
if (!FormHelp.IsBlank(sqlCmd))
{
DbCommand cmd = _DatabaseFactory.GetDbCommand(Helper.GetDataBaseType, sqlCmd, DataBaseConnectionString);
_DatabaseFactory.AddInParameter(ref cmd, "@SAHS_Code", DbType.String, argEn.HostelStructureCode);
_DbParameterCollection = cmd.Parameters;
using (IDataReader loReader = _DatabaseFactory.GetIDataReader(Helper.GetDataBaseType, cmd,
DataBaseConnectionString, sqlCmd, _DbParameterCollection).CreateDataReader())
{
HostelStrAmountDAL loHostelStrAmt = new HostelStrAmountDAL();
HostelStrAmountEn loHostelStrAmtEn = new HostelStrAmountEn();
while (loReader.Read())
{
HostelStructEn loItemDetails = new HostelStructEn();
loItemDetails.HostelStructureCode = GetValue <string>(loReader, "SAHS_Code");
loItemDetails.FTCode = GetValue <string>(loReader, "saft_code");
loItemDetails.Description = GetValue <string>(loReader, "saft_desc");
loItemDetails.LocalAmount = GetValue <double>(loReader, "Local_Amount");
loItemDetails.LocalGSTAmount = GetValue <double>(loReader, "Local_GSTAmount");
loItemDetails.NonLocalAmount = GetValue <double>(loReader, "NonLocal_Amount");
loItemDetails.NonLocalGSTAmount = GetValue <double>(loReader, "NonLocal_GSTAmount");
loItemDetails.TaxId = GetValue <int>(loReader, "safs_taxmode");
loItemDetails.NonLocalTempAmount = loItemDetails.NonLocalAmount - loItemDetails.NonLocalGSTAmount;
loItemDetails.LocalTempAmount = loItemDetails.LocalAmount - loItemDetails.LocalGSTAmount;
loItemDetails.LocalCategory = GetValue <string>(loReader, "Local_Category");
loItemDetails.NonLocalCategory = GetValue <string>(loReader, "NonLocal_Category");
loItemDetails.FeeCategory = GetValue <string>(loReader, "sahd_type");
loItemDetails.Priority = GetValue <int>(loReader, "sahd_priority");
loEnList.Add(loItemDetails);
}
loReader.Close();
}
}
}
catch (Exception ex)
{
throw ex;
}
return(loEnList);
}
/// <summary>
/// Method to Check Validation
/// </summary>
/// <param name="argEn">HostelStrAmount Entity is as Input.</param>
/// <returns>Returns a Boolean</returns>
public bool IsValid(HostelStrAmountEn argEn)
{
try
{
return(true);
}
catch (Exception ex)
{
throw ex;
}
}
/// <summary>
/// Method to Load HostelStrAmount Entity
/// </summary>
/// <param name="argReader">IDataReader Object is an Input.</param>
/// <returns>Returns HostelStrAmount Entity</returns>
private HostelStrAmountEn LoadObject(IDataReader argReader)
{
HostelStrAmountEn loItem = new HostelStrAmountEn();
loItem.HSCode = GetValue <string>(argReader, "SAHS_Code");
loItem.FTCode = GetValue <string>(argReader, "SAFT_Code");
loItem.SCCode = GetValue <string>(argReader, "SASC_Code");
loItem.HAAmount = GetValue <double>(argReader, "SAHA_Amount");
return(loItem);
}
/// <summary>
/// Method to Get FeeTypes Entity
/// </summary>
/// <param name="argEn">HostelStrAmount Entity is an Input.HSCode as Input Property.</param>
/// <returns>Returns HostelStrAmount Entity</returns>
public HostelStrAmountEn GetItem(HostelStrAmountEn argEn)
{
try
{
HostelStrAmountDAL loDs = new HostelStrAmountDAL();
return(loDs.GetItem(argEn));
}
catch (Exception ex)
{
throw ex;
}
}
/// <summary>
/// Method to Get List of HostelStructureAmount
/// </summary>
/// <param name="argEn">HostelStrAmount Entity is an Input.</param>
/// <returns>Returns List of HostelStrAmounts</returns>
public List <HostelStrAmountEn> GetList(HostelStrAmountEn argEn)
{
try
{
HostelStrAmountDAL loDs = new HostelStrAmountDAL();
return(loDs.GetList(argEn));
}
catch (Exception ex)
{
throw ex;
}
}
/// <summary>
/// Method to Update HostelStrAmount
/// </summary>
/// <param name="argEn">HostelStrAmount Entity is an Input.</param>
/// <returns>Returns Boolean</returns>
public bool Update(HostelStrAmountEn argEn)
{
bool flag;
using (TransactionScope ts = new TransactionScope())
{
try
{
HostelStrAmountDAL loDs = new HostelStrAmountDAL();
flag = loDs.Update(argEn);
ts.Complete();
}
catch (Exception ex)
{
throw ex;
}
}
return(flag);
}
/// <summary>
/// Method to Get List of Hostel Amounts
/// </summary>
/// <param name="argEn">HostelStrDetails Entity is an Input.HSCode as input Property</param>
/// <returns>Returns List of HostelStrDetails</returns>
public List <HostelStrDetailsEn> GetHostelAmtList(HostelStrDetailsEn argEn)
{
List <HostelStrDetailsEn> loEnList = new List <HostelStrDetailsEn>();
string sqlCmd = "SELECT SAS_HostelStrDetails.*, SAS_FeeTypes.SAFT_Desc " +
"FROM SAS_HostelStrDetails INNER JOIN SAS_FeeTypes ON SAS_HostelStrDetails.SAFT_Code = SAS_FeeTypes.SAFT_Code " +
"WHERE SAS_HostelStrDetails.SAHS_Code = @SAHS_Code";
try
{
if (!FormHelp.IsBlank(sqlCmd))
{
DbCommand cmd = _DatabaseFactory.GetDbCommand(Helper.GetDataBaseType, sqlCmd, DataBaseConnectionString);
_DatabaseFactory.AddInParameter(ref cmd, "@SAHS_Code", DbType.String, argEn.HSCode);
_DbParameterCollection = cmd.Parameters;
using (IDataReader loReader = _DatabaseFactory.GetIDataReader(Helper.GetDataBaseType, cmd,
DataBaseConnectionString, sqlCmd, _DbParameterCollection).CreateDataReader())
{
HostelStrAmountDAL loHostelStrAmt = new HostelStrAmountDAL();
HostelStrAmountEn loHostelStrAmtEn = new HostelStrAmountEn();
while (loReader.Read())
{
HostelStrDetailsEn loItem = LoadObject(loReader);
loItem.Description = GetValue <string>(loReader, "SAFT_Desc");
loHostelStrAmtEn.HSCode = loItem.HSCode;
loHostelStrAmtEn.FTCode = loItem.FTCode;
//getting the list of Hostel FeeAmounts
loItem.ListFeeAmount = loHostelStrAmt.GetDescList(loHostelStrAmtEn);
loEnList.Add(loItem);
}
loReader.Close();
}
}
}
catch (Exception ex)
{
throw ex;
}
return(loEnList);
}
/// <summary>
/// Method to Insert HostelStrAmount
/// </summary>
/// <param name="argEn">HostelStrAmount Entity is an Input.</param>
/// <returns>Returns Boolean</returns>
public bool Insert(HostelStrAmountEn argEn)
{
bool lbRes = false;
string sqlCmd;
try
{
sqlCmd = "INSERT INTO SAS_HostelStrAmount(SAHS_Code,SAFT_Code,SASC_Code,SAHA_Amount,safa_gstamount) VALUES (@SAHS_Code,@SAFT_Code,@SASC_Code,@SAHA_Amount, @safa_gstamount) ";
if (!FormHelp.IsBlank(sqlCmd))
{
DbCommand cmd = _DatabaseFactory.GetDbCommand(Helper.GetDataBaseType, sqlCmd, DataBaseConnectionString);
_DatabaseFactory.AddInParameter(ref cmd, "@SAHS_Code", DbType.String, clsGeneric.NullToString(argEn.HSCode));
_DatabaseFactory.AddInParameter(ref cmd, "@SAFT_Code", DbType.String, clsGeneric.NullToString(argEn.FTCode));
_DatabaseFactory.AddInParameter(ref cmd, "@SASC_Code", DbType.String, clsGeneric.NullToString(argEn.SCCode));
_DatabaseFactory.AddInParameter(ref cmd, "@SAHA_Amount", DbType.Double, clsGeneric.NullToDecimal(argEn.HAAmount));
_DatabaseFactory.AddInParameter(ref cmd, "@safa_gstamount", DbType.Double, clsGeneric.NullToDecimal(argEn.GstAmount));
_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 List of HostelStructureAmount
/// </summary>
/// <param name="argEn">HostelStrAmount Entity is an Input.HSCode as Input Property</param>
/// <returns>Returns List of HostelStrAmounts</returns>
public List <HostelStrAmountEn> GetDescList(HostelStrAmountEn argEn)
{
List <HostelStrAmountEn> loEnList = new List <HostelStrAmountEn>();
string sqlCmd = "SELECT SAS_HostelStrAmount.SASC_Code,SAS_HostelStrAmount.SAFT_Code, SAS_HostelStrAmount.SAHS_Code,SAS_FeeTypes.SAFT_Desc, SAS_StudentCategory.SASC_Desc," +
" SAS_StudentCategory.SASC_Code AS Expr1,SAS_HostelStrAmount.SAHA_Amount FROM SAS_StudentCategory INNER JOIN " +
"SAS_HostelStrAmount ON SAS_StudentCategory.SASC_Code = SAS_HostelStrAmount.SASC_Code INNER JOIN " +
"SAS_FeeTypes ON SAS_HostelStrAmount.SAFT_Code = SAS_FeeTypes.SAFT_Code WHERE SAS_HostelStrAmount.SAHS_Code = @SAHS_Code and SAS_HostelStrAmount.SAFT_Code = @SAFT_Code";
try
{
if (!FormHelp.IsBlank(sqlCmd))
{
DbCommand cmd = _DatabaseFactory.GetDbCommand(Helper.GetDataBaseType, sqlCmd, DataBaseConnectionString);
_DatabaseFactory.AddInParameter(ref cmd, "@SAHS_Code", DbType.String, argEn.HSCode);
_DatabaseFactory.AddInParameter(ref cmd, "@SAFT_Code", DbType.String, argEn.FTCode);
_DbParameterCollection = cmd.Parameters;
using (IDataReader loReader = _DatabaseFactory.GetIDataReader(Helper.GetDataBaseType, cmd,
DataBaseConnectionString, sqlCmd, _DbParameterCollection).CreateDataReader())
{
while (loReader.Read())
{
HostelStrAmountEn loItem = LoadObject(loReader);
loItem.Description = GetValue <string>(loReader, "SAFT_Desc");
loItem.SCDesc = GetValue <string>(loReader, "SASC_Desc");
loEnList.Add(loItem);
}
loReader.Close();
}
}
}
catch (Exception ex)
{
throw ex;
}
return(loEnList);
}
