/// <summary> /// Method to Get List of Faculty /// </summary> /// <param name="argEn">Faculty Entity is an Input.</param> /// <returns>Returns List of Faculty</returns> public List <FacultyEn> GetList(FacultyEn argEn) { List <FacultyEn> loEnList = new List <FacultyEn>(); argEn.SAFC_Code = argEn.SAFC_Code.Replace("*", "%"); string sqlCmd = "select * from SAS_Faculty WHERE SAFC_CODE <> '0' and SAFC_Status = 't' "; if (argEn.SAFC_Code.Length != 0) { sqlCmd = sqlCmd + " and SAFC_CODE like '" + argEn.SAFC_Code + "'"; } try { if (!FormHelp.IsBlank(sqlCmd)) { using (IDataReader loReader = _DatabaseFactory.ExecuteReader(Helper.GetDataBaseType, DataBaseConnectionString, sqlCmd).CreateDataReader()) { while (loReader.Read()) { FacultyEn loItem = LoadObject(loReader); loEnList.Add(loItem); } loReader.Close(); } } } catch (Exception ex) { throw ex; } return(loEnList); }
/// <summary> /// Method to Get Faculty Entity /// </summary> /// <param name="argEn">Faculty Entity is an Input</param> /// <returns>Returns Faculty Entity</returns> public FacultyEn GetItem(FacultyEn argEn) { FacultyEn loItem = new FacultyEn(); //string sqlCmd = "Select * FROM SAS_Faculty WHERE SAFC_SName = @SAFC_SName"; string sqlCmd = "Select * FROM SAS_Faculty WHERE SAFC_Desc = @SAFC_SName"; try { if (!FormHelp.IsBlank(sqlCmd)) { DbCommand cmd = _DatabaseFactory.GetDbCommand(Helper.GetDataBaseType, sqlCmd, DataBaseConnectionString); //_DatabaseFactory.AddInParameter(ref cmd, "@SAFC_SName", DbType.String, argEn.SAFC_SName); _DatabaseFactory.AddInParameter(ref cmd, "@SAFC_SName", DbType.String, argEn.SAFC_Desc); _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 Delete Faculty /// </summary> /// <param name="argEn">Faculty Entity is an Input.</param> /// <returns>Returns Boolean</returns> public bool Delete(FacultyEn argEn) { bool lbRes = false; int iOut = 0; string sqlCmd = "select sum(rows) as total from(SELECT COUNT(*) AS rows FROM SAS_Student where SASI_Faculty = @SAFC_Code union all select count(*) as rows from SAS_Program WHERE SAFC_Code = @SAFC_Code)AS U"; try { if (!FormHelp.IsBlank(sqlCmd)) { DbCommand cmdSel = _DatabaseFactory.GetDbCommand(Helper.GetDataBaseType, sqlCmd, DataBaseConnectionString); _DatabaseFactory.AddInParameter(ref cmdSel, "@SAFC_Code", DbType.String, argEn.SAFC_Code); _DbParameterCollection = cmdSel.Parameters; using (IDataReader dr = _DatabaseFactory.GetIDataReader(Helper.GetDataBaseType, cmdSel, DataBaseConnectionString, sqlCmd, _DbParameterCollection).CreateDataReader()) { if (dr.Read()) { iOut = clsGeneric.NullToInteger(dr["total"]); } if (iOut > 0) { throw new Exception("Record Already In Use"); } } if (iOut == 0) { string sqlCmd1 = "DELETE FROM SAS_Faculty WHERE SAFC_Code = @SAFC_Code"; if (!FormHelp.IsBlank(sqlCmd1)) { DbCommand cmd = _DatabaseFactory.GetDbCommand(Helper.GetDataBaseType, sqlCmd1, DataBaseConnectionString); _DatabaseFactory.AddInParameter(ref cmd, "@SAFC_Code", DbType.String, argEn.SAFC_Code); _DbParameterCollection = cmd.Parameters; int liRowAffected = _DatabaseFactory.ExecuteNonQuery(Helper.GetDataBaseType, cmd, DataBaseConnectionString, sqlCmd1, _DbParameterCollection); if (liRowAffected > -1) { lbRes = true; } else { throw new Exception("Deletion Failed! No Row has been Deleted..."); } } } } } catch (Exception ex) { throw ex; } return(lbRes); }
/// <summary> /// Method to Get Faculty Entity /// </summary> /// <param name="argEn">Faculty Entity is an Input</param> /// <returns>Returns Faculty Entity</returns> public FacultyEn GetItem(FacultyEn argEn) { try { FacultyDAL loDs = new FacultyDAL(); return(loDs.GetItem(argEn)); } catch (Exception ex) { throw ex; } }
/// <summary> /// Method to Get List of All Faculty /// </summary> /// <param name="argEn">Faculty Entity is an Input.</param> /// <returns>Returns List of Faculty</returns> public List <FacultyEn> GetFacultyList(FacultyEn argEn) { try { FacultyDAL loDs = new FacultyDAL(); return(loDs.GetFacultyList(argEn)); } catch (Exception ex) { throw ex; } }
/// <summary> /// Method to Load Faculty Entity /// </summary> /// <param name="argReader">IDataReader Object is an Input.</param> /// <returns>Returns Faculty Entity</returns> private FacultyEn LoadObject(IDataReader argReader) { FacultyEn loItem = new FacultyEn(); loItem.SAFC_Code = GetValue <string>(argReader, "SAFC_Code"); loItem.SAFC_Desc = GetValue <string>(argReader, "SAFC_Desc"); loItem.SAFC_SName = GetValue <string>(argReader, "SAFC_SName"); loItem.SAFC_Incharge = GetValue <string>(argReader, "SAFC_Incharge"); loItem.SAFC_GlAccount = GetValue <string>(argReader, "SAFC_GlAccount"); loItem.SAFC_Status = GetValue <bool>(argReader, "SAFC_Status"); loItem.SABR_Code = GetValue <int>(argReader, "SABR_Code"); loItem.SAFC_UpdatedBy = GetValue <string>(argReader, "SAFC_UpdatedBy"); loItem.SAFC_UpdatedDtTm = GetValue <string>(argReader, "SAFC_UpdatedDtTm"); return(loItem); }
/// <summary> /// Method to Update Faculty /// </summary> /// <param name="argEn">Faculty Entity is an Input.</param> /// <returns>Returns Boolean</returns> public bool Update(FacultyEn argEn) { bool flag; using (TransactionScope ts = new TransactionScope()) { try { FacultyDAL loDs = new FacultyDAL(); flag = loDs.Update(argEn); ts.Complete(); } catch (Exception ex) { throw ex; } } return(flag); }
/// <summary> /// Method to Check Validation /// </summary> /// <param name="argEn">Faculty Entity as Input.</param> /// <returns>Returns a Boolean</returns> public bool IsValid(FacultyEn argEn) { try { if (argEn.SAFC_Code == null || argEn.SAFC_Code.ToString().Length <= 0) { throw new Exception("SAFC_Code Is Required!"); } if (argEn.SAFC_Desc == null || argEn.SAFC_Desc.ToString().Length <= 0) { throw new Exception("SAFC_Desc Is Required!"); } return(true); } catch (Exception ex) { throw ex; } }
/// <summary> /// Method to Update Faculty /// </summary> /// <param name="argEn">Faculty Entity is an Input.</param> /// <returns>Returns Boolean</returns> public bool Update(FacultyEn argEn) { bool lbRes = false; int iOut = 0; try { string sqlCmd = "Select count(safc_code) as cnt From SAS_Faculty WHERE SAFC_Code != @SAFC_Code and SAFC_Desc = @SAFC_Desc"; if (!FormHelp.IsBlank(sqlCmd)) { DbCommand cmdSel = _DatabaseFactory.GetDbCommand(Helper.GetDataBaseType, sqlCmd, DataBaseConnectionString); _DatabaseFactory.AddInParameter(ref cmdSel, "@SAFC_Code", DbType.StringFixedLength, argEn.SAFC_Code); _DatabaseFactory.AddInParameter(ref cmdSel, "@SAFC_Desc", DbType.StringFixedLength, argEn.SAFC_Desc); _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_Faculty SET SAFC_Code = @SAFC_Code, SAFC_Desc = @SAFC_Desc, SAFC_SName = @SAFC_SName, SAFC_Incharge = @SAFC_Incharge, SAFC_GlAccount = @SAFC_GlAccount, SABR_Code = @SABR_Code, SAFC_UpdatedBy = @SAFC_UpdatedBy, SAFC_UpdatedDtTm = @SAFC_UpdatedDtTm,SAFC_Status = @SAFC_Status WHERE SAFC_Code = @SAFC_Code"; if (!FormHelp.IsBlank(sqlCmd)) { DbCommand cmd = _DatabaseFactory.GetDbCommand(Helper.GetDataBaseType, sqlCmd, DataBaseConnectionString); _DatabaseFactory.AddInParameter(ref cmd, "@SAFC_Code", DbType.String, argEn.SAFC_Code); _DatabaseFactory.AddInParameter(ref cmd, "@SAFC_Desc", DbType.String, argEn.SAFC_Desc); _DatabaseFactory.AddInParameter(ref cmd, "@SAFC_SName", DbType.String, argEn.SAFC_SName); _DatabaseFactory.AddInParameter(ref cmd, "@SAFC_Incharge", DbType.String, argEn.SAFC_Incharge); _DatabaseFactory.AddInParameter(ref cmd, "@SAFC_GlAccount", DbType.String, argEn.SAFC_GlAccount); _DatabaseFactory.AddInParameter(ref cmd, "@SAFC_Status", DbType.Boolean, argEn.SAFC_Status); _DatabaseFactory.AddInParameter(ref cmd, "@SABR_Code", DbType.Int32, argEn.SABR_Code); _DatabaseFactory.AddInParameter(ref cmd, "@SAFC_UpdatedBy", DbType.String, argEn.SAFC_UpdatedBy); _DatabaseFactory.AddInParameter(ref cmd, "@SAFC_UpdatedDtTm", DbType.String, argEn.SAFC_UpdatedDtTm); _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); }