//<summary> //Method to Delete StudentBank //</summary> //<param name="argEn">StudentBank Entity is an Input.StudentBankCode as Input Property.</param> //<returns>Returns Boolean</returns> public bool Delete(StudentBankEn argEn) { bool lbRes = false; int iOut = 0; string sqlCmd = "Select count(*) as cnt From SAS_Student WHERE SASI_Bank = @SASB_Code"; try { if (!FormHelp.IsBlank(sqlCmd)) { DbCommand cmdSel = _DatabaseFactory.GetDbCommand(Helper.GetDataBaseType, sqlCmd, DataBaseConnectionString); _DatabaseFactory.AddInParameter(ref cmdSel, "@SASB_Code", DbType.String, argEn.StudentBankCode); _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 In Use"); } } if (iOut == 0) { sqlCmd = "DELETE FROM SAS_StudentBank WHERE SASB_Code = @SASB_Code"; if (!FormHelp.IsBlank(sqlCmd)) { DbCommand cmd = _DatabaseFactory.GetDbCommand(Helper.GetDataBaseType, sqlCmd, DataBaseConnectionString); _DatabaseFactory.AddInParameter(ref cmd, "@SASB_Code", DbType.String, argEn.StudentBankCode); _DbParameterCollection = cmd.Parameters; int liRowAffected = _DatabaseFactory.ExecuteNonQuery(Helper.GetDataBaseType, cmd, DataBaseConnectionString, sqlCmd, _DbParameterCollection); if (liRowAffected > -1) { lbRes = true; } else { throw new Exception("Delete Failed! No Row has been updated..."); } } } } } catch (Exception ex) { throw ex; } return(lbRes); }
/// <summary> /// Method to Load StudentBank Entity /// </summary> /// <param name="argReader">IDataReader Object is an Input.</param> /// <returns>Returns StudentBank Entity</returns> private StudentBankEn LoadObject(IDataReader argReader) { StudentBankEn loItem = new StudentBankEn(); loItem.StudentBankCode = GetValue <string>(argReader, "SASB_Code"); loItem.Description = GetValue <string>(argReader, "SASB_Desc"); loItem.Status = GetValue <bool>(argReader, "SASB_Status"); loItem.UpdatedBy = GetValue <string>(argReader, "SASB_UpdatedBy"); loItem.UpdatedDtTm = GetValue <string>(argReader, "SASB_UpdatedDtTm"); return(loItem); }
/// <summary> /// Method to Get List of All StudentCategory /// </summary> /// <param name="argEn">StudentBank Entity as an Input.StudentBankCode and Description as Input Properties.</param> /// <returns>Returns List of StudentBank</returns> public List <StudentBankEn> GetStudentBankTypeListAll(StudentBankEn argEn) { try { StudentBankDAL loDs = new StudentBankDAL(); return(loDs.GetStudentBankTypeListAll(argEn)); } catch (Exception ex) { throw ex; } }
/// <summary> /// Method to Get List of Active or Inactive StudentBank /// </summary> /// <param name="argEn">StudentBank Entity as an Input.StudentBankCode,Description and Status as Input Properties.</param> /// <returns>Returns List of StudentBank</returns> public List <StudentBankEn> GetStudentBankTypelist(StudentBankEn argEn) { List <StudentBankEn> loEnList = new List <StudentBankEn>(); argEn.StudentBankCode = argEn.StudentBankCode.Replace("*", "%"); argEn.Description = argEn.Description.Replace("*", "%"); string sqlCmd = "select * from SAS_StudentBank where SASB_Code <> '0'"; if (argEn.StudentBankCode.Length != 0) { sqlCmd = sqlCmd + " and SASB_Code like '" + argEn.StudentBankCode + "'"; } if (argEn.Description.Length != 0) { sqlCmd = sqlCmd + " and SASB_Desc like '" + argEn.Description + "'"; } //if (argEn.Status == true) sqlCmd = sqlCmd + " and SASB_Status =1"; if (argEn.Status == true) { sqlCmd = sqlCmd + " and SASB_Status = 'true'"; } //if (argEn.Status == false) sqlCmd = sqlCmd + " and SASB_Status =0"; if (argEn.Status == false) { sqlCmd = sqlCmd + " and SASB_Status = 'false'"; } sqlCmd = sqlCmd + " order by SASB_Code"; try { if (!FormHelp.IsBlank(sqlCmd)) { using (IDataReader loReader = _DatabaseFactory.ExecuteReader(Helper.GetDataBaseType, DataBaseConnectionString, sqlCmd).CreateDataReader()) { while (loReader.Read()) { StudentBankEn loItem = LoadObject(loReader); loEnList.Add(loItem); } loReader.Close(); } } } catch (Exception ex) { throw ex; } return(loEnList); }
/// <summary> /// Method to Delete StudentBank /// </summary> /// <param name="argEn">StudentBank Entity is an Input.</param> /// <returns>Returns Boolean</returns> public bool Delete(StudentBankEn argEn) { bool flag; using (TransactionScope ts = new TransactionScope()) { try { StudentBankDAL loDs = new StudentBankDAL(); flag = loDs.Delete(argEn); ts.Complete(); } catch (Exception ex) { throw ex; } } return(flag); }
/// <summary> /// Method to Insert StudentBank /// </summary> /// <param name="argEn">StudentBank Entity is an Input.</param> /// <returns>Returns Boolean</returns> public bool Insert(StudentBankEn argEn) { bool lbRes = false; int iOut = 0; string sqlCmd = "Select count(*) as cnt From SAS_StudentBank WHERE SASB_Code = @SASB_Code or SASB_Desc = @SASB_Desc"; try { if (!FormHelp.IsBlank(sqlCmd)) { DbCommand cmdSel = _DatabaseFactory.GetDbCommand(Helper.GetDataBaseType, sqlCmd, DataBaseConnectionString); _DatabaseFactory.AddInParameter(ref cmdSel, "@SASB_Code", DbType.String, argEn.StudentBankCode); _DatabaseFactory.AddInParameter(ref cmdSel, "@SASB_Desc", DbType.String, argEn.Description); _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 = "INSERT INTO SAS_StudentBank(SASB_Code,SASB_Desc,SASB_Status,SASB_UpdatedBy,SASB_UpdatedDtTm) VALUES (@SASB_Code,@SASB_Desc,@SASB_Status,@SASB_UpdatedBy,@SASB_UpdatedDtTm) "; if (!FormHelp.IsBlank(sqlCmd)) { DbCommand cmd = _DatabaseFactory.GetDbCommand(Helper.GetDataBaseType, sqlCmd, DataBaseConnectionString); _DatabaseFactory.AddInParameter(ref cmd, "@SASB_Code", DbType.String, argEn.StudentBankCode); _DatabaseFactory.AddInParameter(ref cmd, "@SASB_Desc", DbType.String, argEn.Description); _DatabaseFactory.AddInParameter(ref cmd, "@SASB_Status", DbType.Boolean, argEn.Status); _DatabaseFactory.AddInParameter(ref cmd, "@SASB_UpdatedBy", DbType.String, argEn.UpdatedBy); _DatabaseFactory.AddInParameter(ref cmd, "@SASB_UpdatedDtTm", DbType.String, argEn.UpdatedDtTm); _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); }