/// <summary> /// Method to Get List of Sponsor FeeTypes by SponsorCode /// </summary> /// <param name="argEn">SponsorFeeTypes Entity as an Input.SponsorCode as Input Property.</param> /// <returns>Returns List of SponsorFeeTypes</returns> public List <SponsorFeeTypesEn> GetSPFeeTypeList(SponsorFeeTypesEn argEn) { List <SponsorFeeTypesEn> loEnList = new List <SponsorFeeTypesEn>(); string sqlCmd = "select SFT.SASR_Code,SFT.SAFT_Code,FT.SAFT_Desc from SAS_SponsorFeeTypes SFT INNER JOIN " + "SAS_FeeTypes FT ON SFT.SAFT_Code=FT.SAFT_Code where SFT.SASR_Code=@SASR_Code"; try { if (!FormHelp.IsBlank(sqlCmd)) { DbCommand cmd = _DatabaseFactory.GetDbCommand(Helper.GetDataBaseType, sqlCmd, DataBaseConnectionString); _DatabaseFactory.AddInParameter(ref cmd, "@SASR_Code", DbType.String, argEn.SponserCode); _DbParameterCollection = cmd.Parameters; using (IDataReader loReader = _DatabaseFactory.GetIDataReader(Helper.GetDataBaseType, cmd, DataBaseConnectionString, sqlCmd, _DbParameterCollection).CreateDataReader()) { while (loReader.Read()) { SponsorFeeTypesEn loItem = LoadObject(loReader); loItem.FeeTypeDesc = GetValue <string>(loReader, "SAFT_Desc"); loEnList.Add(loItem); } loReader.Close(); } } } catch (Exception ex) { throw ex; } return(loEnList); }
/// <summary> /// Method to Get List of SponsorFeeTypes /// </summary> /// <param name="argEn">SponsorFeeTypes Entity as an Input.</param> /// <returns>Returns List of SponsorFeeTypes</returns> public List <SponsorFeeTypesEn> GetList(SponsorFeeTypesEn argEn) { List <SponsorFeeTypesEn> loEnList = new List <SponsorFeeTypesEn>(); string sqlCmd = "select * from SAS_SponsorFeeTypes"; try { if (!FormHelp.IsBlank(sqlCmd)) { using (IDataReader loReader = _DatabaseFactory.ExecuteReader(Helper.GetDataBaseType, DataBaseConnectionString, sqlCmd).CreateDataReader()) { while (loReader.Read()) { SponsorFeeTypesEn loItem = LoadObject(loReader); loEnList.Add(loItem); } loReader.Close(); } } } catch (Exception ex) { throw ex; } return(loEnList); }
/// <summary> /// Method to Delete SponsorFeeTypes /// </summary> /// <param name="argEn">SponsorFeeTypes Entity is an Input.SASR_Code as Input Property.</param> /// <returns>Returns Boolean</returns> public bool Delete(SponsorFeeTypesEn argEn) { bool lbRes = false; string sqlCmd = "DELETE FROM SAS_SponsorFeeTypes WHERE SASR_Code = @SASR_Code"; try { if (!FormHelp.IsBlank(sqlCmd)) { DbCommand cmd = _DatabaseFactory.GetDbCommand(Helper.GetDataBaseType, sqlCmd, DataBaseConnectionString); _DatabaseFactory.AddInParameter(ref cmd, "@SASR_Code", DbType.String, argEn.SponserCode); _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 SponsorFeeTypes Entity /// </summary> /// <param name="argEn">SponsorFeeTypes Entity is an Input.SASR_Code as Input Property.</param> /// <returns>Returns SponsorFeeTypes Entity</returns> public SponsorFeeTypesEn GetItem(SponsorFeeTypesEn argEn) { SponsorFeeTypesEn loItem = new SponsorFeeTypesEn(); string sqlCmd = "Select * FROM SAS_SponsorFeeTypes WHERE SASR_Code = @SASR_Code"; try { if (!FormHelp.IsBlank(sqlCmd)) { DbCommand cmdSel = _DatabaseFactory.GetDbCommand(Helper.GetDataBaseType, sqlCmd, DataBaseConnectionString); _DatabaseFactory.AddInParameter(ref cmdSel, "@SASR_Code", DbType.String, argEn.SponserCode); _DbParameterCollection = cmdSel.Parameters; using (IDataReader loReader = _DatabaseFactory.GetIDataReader(Helper.GetDataBaseType, cmdSel, DataBaseConnectionString, sqlCmd, _DbParameterCollection).CreateDataReader()) { if (loReader != null) { loReader.Read(); loItem = LoadObject(loReader); } loReader.Close(); } } } catch (Exception ex) { throw ex; } return(loItem); }
/// <summary> /// Method to Load SponsorFeeTypes Entity /// </summary> /// <param name="argReader">IDataReader Object is an Input.</param> /// <returns>Returns SponsorFeeTypes Entity</returns> private SponsorFeeTypesEn LoadObject(IDataReader argReader) { SponsorFeeTypesEn loItem = new SponsorFeeTypesEn(); loItem.SponserCode = GetValue <string>(argReader, "SASR_Code"); loItem.FeeTypeCode = GetValue <string>(argReader, "SAFT_Code"); return(loItem); }
/// <summary> /// Method to Check Validation /// </summary> /// <param name="argEn">SponsorFeeTypes Entity is as Input.</param> /// <returns>Returns a Boolean</returns> public bool IsValid(SponsorFeeTypesEn argEn) { try { return(true); } catch (Exception ex) { throw ex; } }
/// <summary> /// Method to Get SponsorFeeTypes Entity /// </summary> /// <param name="argEn">SponsorFeeTypes Entity is an Input.SASR_Code as Input Property.</param> /// <returns>Returns SponsorFeeTypes Entity</returns> public SponsorFeeTypesEn GetItem(SponsorFeeTypesEn argEn) { try { SponsorFeeTypesDAL loDs = new SponsorFeeTypesDAL(); return(loDs.GetItem(argEn)); } catch (Exception ex) { throw ex; } }
/// <summary> /// Method to Get List of Sponsor FeeTypes by SponsorCode /// </summary> /// <param name="argEn">SponsorFeeTypes Entity as an Input.SponsorCode as Input Property.</param> /// <returns>Returns List of SponsorFeeTypes</returns> public List <SponsorFeeTypesEn> GetSPFeeTypeList(SponsorFeeTypesEn argEn) { try { SponsorFeeTypesDAL loDs = new SponsorFeeTypesDAL(); return(loDs.GetSPFeeTypeList(argEn)); } catch (Exception ex) { throw ex; } }
/// <summary> /// Method to Insert SponsorFeeTypes /// </summary> /// <param name="argEn">SponsorFeeTypes Entity is an Input.Sponsor Code and Feetype Code as Input Properties.</param> /// <returns>Returns Boolean</returns> public bool Update(SponsorFeeTypesEn argEn) { bool flag; using (TransactionScope ts = new TransactionScope()) { try { SponsorFeeTypesDAL loDs = new SponsorFeeTypesDAL(); flag = loDs.Update(argEn); ts.Complete(); } catch (Exception ex) { throw ex; } } return(flag); }
/// <summary> /// Method to Get List Active or Inactive of Sponsors /// </summary> /// <param name="argEn">Sponsors Entity as an Input.SponsorCode,Name,Type,GLAccount and Status as Input Properties.</param> /// <returns>Returns List of Sponsors</returns> public List <SponsorEn> GetSponserList(SponsorEn argEn) { List <SponsorEn> loEnList = new List <SponsorEn>(); SponsorFeeTypesDAL dobjSPFeeType = new SponsorFeeTypesDAL(); SponsorFeeTypesEn eobjSPFeeType; argEn.SponserCode = argEn.SponserCode.Replace("*", "%"); argEn.Name = argEn.Name.Replace("*", "%"); argEn.Type = argEn.Type.Replace("*", "%"); argEn.GLAccount = argEn.GLAccount.Replace("*", "%"); string sqlCmd = "select SASR_Code,SASR_Name,SASSR_SName,SASR_Address,SASR_Address1,SASR_Address2,SASR_Contact,SASR_Phone,SASR_Fax,SASR_Email,SASR_WebSite,SASR_Type,SASR_Desc,SASR_GLAccount,SASR_Status,SASR_ptptn from SAS_Sponsor where SASR_Code <> '0'"; if (argEn.SponserCode.Length != 0) { sqlCmd = sqlCmd + " and SASR_Code like '" + argEn.SponserCode + "'"; } if (argEn.Name.Length != 0) { sqlCmd = sqlCmd + " and SASR_Name like '" + argEn.Name + "'"; } if (argEn.Type.Length != 0) { sqlCmd = sqlCmd + " and SASR_Type like '" + argEn.Type + "'"; } if (argEn.GLAccount.Length != 0) { sqlCmd = sqlCmd + " and SASR_GLAccount like '" + argEn.GLAccount + "'"; } if (argEn.Status == true) { sqlCmd = sqlCmd + " and SASR_Status ='true'"; } if (argEn.Status == false) { sqlCmd = sqlCmd + " and SASR_Status ='false'"; } //if (argEn.ptptn == true) sqlCmd = sqlCmd + " and SASR_ptptn ='true'"; //if (argEn.ptptn == false) sqlCmd = sqlCmd + " and SASR_ptptn ='false'"; sqlCmd = sqlCmd + " order by SASR_Code"; try { if (!FormHelp.IsBlank(sqlCmd)) { using (IDataReader loReader = _DatabaseFactory.ExecuteReader(Helper.GetDataBaseType, DataBaseConnectionString, sqlCmd).CreateDataReader()) { while (loReader.Read()) { SponsorEn loItem = LoadObject(loReader); eobjSPFeeType = new SponsorFeeTypesEn(); eobjSPFeeType.SponserCode = loItem.SponserCode; loItem.LstSponserFeeTypes = dobjSPFeeType.GetSPFeeTypeList(eobjSPFeeType); loEnList.Add(loItem); } loReader.Close(); } } } catch (Exception ex) { throw ex; } return(loEnList); }
/// <summary> /// Method to Update Sponsor /// </summary> /// <param name="argEn">Sponsor Entity is an Input.</param> /// <returns>Returns Boolean</returns> public bool Update(SponsorEn argEn) { bool lbRes = false; int iOut = 0, resetPTPTN = 0;; string sqlCmd = "Select count(*) as cnt From SAS_Sponsor WHERE SASR_Code != @SASR_Code and SASR_Name = @SASR_Name"; try { if (!FormHelp.IsBlank(sqlCmd)) { DbCommand cmdSel = _DatabaseFactory.GetDbCommand(Helper.GetDataBaseType, sqlCmd, DataBaseConnectionString); _DatabaseFactory.AddInParameter(ref cmdSel, "@SASR_Code", DbType.String, argEn.SponserCode); _DatabaseFactory.AddInParameter(ref cmdSel, "@SASR_Name", DbType.String, argEn.Name); _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("Record Already Exist"); } } if (iOut == 0) { sqlCmd = "UPDATE SAS_Sponsor SET SASR_Code = @SASR_Code, SASR_Name = @SASR_Name, SASSR_SName = @SASSR_SName, SASR_Address = @SASR_Address, SASR_Address1 = @SASR_Address1, SASR_Address2 = @SASR_Address2, SASR_Contact = @SASR_Contact, SASR_Phone = @SASR_Phone, SASR_Fax = @SASR_Fax, SASR_Email = @SASR_Email, SASR_WebSite = @SASR_WebSite, SASR_Type = @SASR_Type, SASR_Desc = @SASR_Desc, SASR_GLAccount = @SASR_GLAccount, SABR_Code = @SABR_Code, SASR_UpdatedBy = @SASR_UpdatedBy, SASR_UpdatedDtTm = @SASR_UpdatedDtTm, SASR_Status = @SASR_Status, SASR_ptptn = @SASR_ptptn WHERE SASR_Code = @SASR_Code"; if (!FormHelp.IsBlank(sqlCmd)) { DbCommand cmd = _DatabaseFactory.GetDbCommand(Helper.GetDataBaseType, sqlCmd, DataBaseConnectionString); _DatabaseFactory.AddInParameter(ref cmd, "@SASR_Code", DbType.String, argEn.SponserCode); _DatabaseFactory.AddInParameter(ref cmd, "@SASR_Name", DbType.String, argEn.Name); _DatabaseFactory.AddInParameter(ref cmd, "@SASSR_SName", DbType.String, argEn.SName); _DatabaseFactory.AddInParameter(ref cmd, "@SASR_Address", DbType.String, argEn.Address); _DatabaseFactory.AddInParameter(ref cmd, "@SASR_Address1", DbType.String, argEn.Address1); _DatabaseFactory.AddInParameter(ref cmd, "@SASR_Address2", DbType.String, argEn.Address2); _DatabaseFactory.AddInParameter(ref cmd, "@SASR_Contact", DbType.String, argEn.Contact); _DatabaseFactory.AddInParameter(ref cmd, "@SASR_Phone", DbType.String, argEn.Phone); _DatabaseFactory.AddInParameter(ref cmd, "@SASR_Fax", DbType.String, argEn.Fax); _DatabaseFactory.AddInParameter(ref cmd, "@SASR_Email", DbType.String, argEn.Email); _DatabaseFactory.AddInParameter(ref cmd, "@SASR_WebSite", DbType.String, argEn.WebSite); _DatabaseFactory.AddInParameter(ref cmd, "@SASR_Type", DbType.String, argEn.Type); _DatabaseFactory.AddInParameter(ref cmd, "@SASR_Desc", DbType.String, argEn.Description); _DatabaseFactory.AddInParameter(ref cmd, "@SASR_GLAccount", DbType.String, argEn.GLAccount); _DatabaseFactory.AddInParameter(ref cmd, "@SABR_Code", DbType.Int32, argEn.Code); _DatabaseFactory.AddInParameter(ref cmd, "@SASR_UpdatedBy", DbType.String, argEn.UpdatedBy); _DatabaseFactory.AddInParameter(ref cmd, "@SASR_UpdatedDtTm", DbType.String, argEn.UpdatedDtTm); _DatabaseFactory.AddInParameter(ref cmd, "@SASR_Status", DbType.Boolean, argEn.Status); _DatabaseFactory.AddInParameter(ref cmd, "@SASR_ptptn", DbType.Boolean, argEn.ptptn); _DbParameterCollection = cmd.Parameters; int liRowAffected = _DatabaseFactory.ExecuteNonQuery(Helper.GetDataBaseType, cmd, DataBaseConnectionString, sqlCmd, _DbParameterCollection); SponsorFeeTypesEn eobjSPFeeType = new SponsorFeeTypesEn(); SponsorFeeTypesDAL dobjSPFeeType = new SponsorFeeTypesDAL(); int i = 0; eobjSPFeeType.SponserCode = argEn.SponserCode; //Deleting the existing sponsor feetypes dobjSPFeeType.Delete(eobjSPFeeType); //Inserting new Sponsor feetypes while (i < argEn.LstSponserFeeTypes.Count) { eobjSPFeeType = argEn.LstSponserFeeTypes[i]; dobjSPFeeType.Insert(eobjSPFeeType); eobjSPFeeType = null; i = i + 1; } if (liRowAffected > -1) { lbRes = true; if (argEn.ptptn == true) { sqlCmd = "UPDATE SAS_Sponsor SET SASR_ptptn = false " + "WHERE SASR_Code != " + clsGeneric.AddQuotes(argEn.SponserCode); //Update Details to Database resetPTPTN = _DatabaseFactory.ExecuteSqlStatement(Helper.GetDataBaseType, DataBaseConnectionString, sqlCmd); if (resetPTPTN > -1) { lbRes = true; } else { throw new Exception("Reset Current Semester Failed! No Row has been updated..."); } } } else { throw new Exception("Update Failed! No Row has been updated..."); } } } } } catch (Exception ex) { throw ex; } return(lbRes); }