/// <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); }