/// <summary> /// Method to Get List of All StudentCategoryAccess /// </summary> /// <param name="argEn">StudentCategoryAccess Entity as an Input.StudentCategoryCode as Input Property.</param> /// <returns>Returns List of StudentCategoryAccess</returns> public List <StudentCategoryAccessEn> GetStuCatAccessList(StudentCategoryAccessEn argEn) { List <StudentCategoryAccessEn> loEnList = new List <StudentCategoryAccessEn>(); string sqlCmd = "select SCA.MenuID,MM.MenuName,MM.PageName,SCA.Status,SCA.SASC_Code" + " from SAS_StudentCategoryAccess SCA INNER JOIN UR_MenuMaster MM" + " on SCA.MenuID=MM.MenuID where MM.MenuID <> 114 and SCA.SASC_Code=@SASC_Code"; try { if (!FormHelp.IsBlank(sqlCmd)) { DbCommand cmd = _DatabaseFactory.GetDbCommand(Helper.GetDataBaseType, sqlCmd, DataBaseConnectionString); _DatabaseFactory.AddInParameter(ref cmd, "@SASC_Code", DbType.String, argEn.StudentCategoryCode); _DbParameterCollection = cmd.Parameters; using (IDataReader loReader = _DatabaseFactory.GetIDataReader(Helper.GetDataBaseType, cmd, DataBaseConnectionString, sqlCmd, _DbParameterCollection).CreateDataReader()) { while (loReader.Read()) { StudentCategoryAccessEn loItem = LoadObject(loReader); loItem.MenuName = GetValue <string>(loReader, "MenuName"); loItem.PageName = GetValue <string>(loReader, "PageName"); loEnList.Add(loItem); } loReader.Close(); } } } catch (Exception ex) { throw ex; } return(loEnList); }
/// <summary> /// Method to Delete StudentCategoryAccess /// </summary> /// <param name="argEn">StudentCategoryAccess Entity is an Input.StudentCategoryCode as Input Property.</param> /// <returns>Returns Boolean</returns> public bool Delete(StudentCategoryAccessEn argEn) { bool lbRes = false; string sqlCmd = "DELETE FROM SAS_StudentCategoryAccess WHERE SASC_Code = @SASC_Code"; try { if (!FormHelp.IsBlank(sqlCmd)) { DbCommand cmd = _DatabaseFactory.GetDbCommand(Helper.GetDataBaseType, sqlCmd, DataBaseConnectionString); _DatabaseFactory.AddInParameter(ref cmd, "@SASC_Code", DbType.String, argEn.StudentCategoryCode); _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 StudentCategoryAccess /// </summary> /// <param name="argEn">StudentCategoryAccess Entity as an Input.</param> /// <returns>Returns List of StudentCategoryAccess</returns> public List <StudentCategoryAccessEn> GetList(StudentCategoryAccessEn argEn) { List <StudentCategoryAccessEn> loEnList = new List <StudentCategoryAccessEn>(); string sqlCmd = "select * from SAS_StudentCategoryAccess"; try { if (!FormHelp.IsBlank(sqlCmd)) { using (IDataReader loReader = _DatabaseFactory.ExecuteReader(Helper.GetDataBaseType, DataBaseConnectionString, sqlCmd).CreateDataReader()) { while (loReader.Read()) { StudentCategoryAccessEn loItem = LoadObject(loReader); loEnList.Add(loItem); } loReader.Close(); } } } catch (Exception ex) { throw ex; } return(loEnList); }
/// <summary> /// Method to Get StudentCategoryAccess Entity /// </summary> /// <param name="argEn">StudentCategoryAccess Entity is an Input.StudentCategoryCode as Input Property.</param> /// <returns>Returns StudentCategoryAccess Entity</returns> public StudentCategoryAccessEn GetItem(StudentCategoryAccessEn argEn) { StudentCategoryAccessEn loItem = new StudentCategoryAccessEn(); string sqlCmd = "Select * FROM SAS_StudentCategoryAccess WHERE SASC_Code = @SASC_Code"; try { if (!FormHelp.IsBlank(sqlCmd)) { DbCommand cmd = _DatabaseFactory.GetDbCommand(Helper.GetDataBaseType, sqlCmd, DataBaseConnectionString); _DatabaseFactory.AddInParameter(ref cmd, "@SASC_Code", DbType.String, argEn.StudentCategoryCode); _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 Insert StudentCategoryAccess /// </summary> /// <param name="argEn">StudentCategoryAccess Entity is an Input.</param> /// <returns>Returns Boolean</returns> public bool Insert(StudentCategoryAccessEn argEn) { bool lbRes = false; string sqlCmd = "INSERT INTO SAS_StudentCategoryAccess(SASC_Code,MenuID,Status) VALUES (@SASC_Code,@MenuID,@Status) "; try { if (!FormHelp.IsBlank(sqlCmd)) { DbCommand cmd = _DatabaseFactory.GetDbCommand(Helper.GetDataBaseType, sqlCmd, DataBaseConnectionString); _DatabaseFactory.AddInParameter(ref cmd, "@SASC_Code", DbType.String, argEn.StudentCategoryCode); _DatabaseFactory.AddInParameter(ref cmd, "@MenuID", DbType.Int32, argEn.MenuID); _DatabaseFactory.AddInParameter(ref cmd, "@Status", DbType.Boolean, argEn.Status); _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 Menus /// </summary> /// <param name="argEn">StudentCategoryAccess Entity as an Input.MenuName as Input Property.</param> /// <returns>Returns List of StudentCategoryAccess</returns> public List <StudentCategoryAccessEn> GetMenuList(StudentCategoryAccessEn argEn) { List <StudentCategoryAccessEn> loEnList = new List <StudentCategoryAccessEn>(); string sqlCmd = "select * from UR_MenuMaster where MenuID <> 114 AND status = true AND MenuName= '" + argEn.MenuName + "'"; try { if (!FormHelp.IsBlank(sqlCmd)) { using (IDataReader loReader = _DatabaseFactory.ExecuteReader(Helper.GetDataBaseType, DataBaseConnectionString, sqlCmd).CreateDataReader()) { while (loReader.Read()) { StudentCategoryAccessEn loItem = LoadMenuObject(loReader); loEnList.Add(loItem); } loReader.Close(); } } } catch (Exception ex) { throw ex; } return(loEnList); }
/// <summary> /// Method to Load StudentCategoryAccess Entity /// </summary> /// <param name="argReader">IDataReader Object is an Input.</param> /// <returns>Returns StudentCategoryAccess Entity</returns> private StudentCategoryAccessEn LoadObject(IDataReader argReader) { StudentCategoryAccessEn loItem = new StudentCategoryAccessEn(); loItem.StudentCategoryCode = GetValue <string>(argReader, "SASC_Code"); loItem.MenuID = GetValue <int>(argReader, "MenuID"); loItem.Status = GetValue <bool>(argReader, "Status"); return(loItem); }
/// <summary> /// Method to Check Validation /// </summary> /// <param name="argEn">StudentCategoryAccess Entity is as Input.</param> /// <returns>Returns a Boolean</returns> public bool IsValid(StudentCategoryAccessEn argEn) { try { return(true); } catch (Exception ex) { throw ex; } }
/// <summary> /// Method to Load Menus /// </summary> /// <param name="argReader">IDataReader Object is an Input.</param> /// <returns>Returns StudentCategoryAccess Entity</returns> private StudentCategoryAccessEn LoadMenuObject(IDataReader argReader) { StudentCategoryAccessEn loItem = new StudentCategoryAccessEn(); //loItem.StudentCategoryCode = GetValue<string>(argReader, "SASC_Code"); loItem.MenuID = GetValue <int>(argReader, "MenuID"); loItem.MenuName = GetValue <string>(argReader, "MenuName"); loItem.PageName = GetValue <string>(argReader, "PageName"); loItem.Status = false; return(loItem); }
/// <summary> /// Method to Get StudentCategoryAccess Entity /// </summary> /// <param name="argEn">StudentCategoryAccess Entity is an Input.StudentCategoryCode as Input Property.</param> /// <returns>Returns StudentCategoryAccess Entity</returns> public StudentCategoryAccessEn GetItem(StudentCategoryAccessEn argEn) { try { StudentCategoryAccessDAL loDs = new StudentCategoryAccessDAL(); return(loDs.GetItem(argEn)); } catch (Exception ex) { throw ex; } }
/// <summary> /// Method to Get List of All StudentCategoryAccess /// </summary> /// <param name="argEn">StudentCategoryAccess Entity as an Input.StudentCategoryCode as Input Property.</param> /// <returns>Returns List of StudentCategoryAccess</returns> public List <StudentCategoryAccessEn> GetStuCatAccessList(StudentCategoryAccessEn argEn) { try { StudentCategoryAccessDAL loDs = new StudentCategoryAccessDAL(); return(loDs.GetStuCatAccessList(argEn)); } catch (Exception ex) { throw ex; } }
/// <summary> /// Method to Get List of All StudentStatus /// </summary> /// <param name="argEn">StudentStatus Entity as an Input.StudentStatusCode and Description as Input Property.</param> /// <returns>Returns List of StudentStatus</returns> public List <StudentStatusEn> GetStudentStatusListAll(StudentStatusEn argEn) { List <StudentStatusEn> loEnList = new List <StudentStatusEn>(); StudentCategoryAccessDAL dobjSCAccess = new StudentCategoryAccessDAL(); StudentCategoryAccessEn eobjSCAccess; argEn.StudentStatusCode = argEn.StudentStatusCode.Replace("*", "%"); argEn.Description = argEn.Description.Replace("*", "%"); string sqlCmd = "select SASS_Code,SASS_Description,SASS_Status,SASS_BlStatus from SAS_StudentStatus where SASS_Code <> '0'"; if (argEn.StudentStatusCode.Length != 0) { sqlCmd = sqlCmd + " and SASS_Code like '" + argEn.StudentStatusCode + "'"; } if (argEn.Description.Length != 0) { sqlCmd = sqlCmd + " and SASS_Description like '" + argEn.Description + "'"; } sqlCmd = sqlCmd + " order by SASS_Code"; try { if (!FormHelp.IsBlank(sqlCmd)) { using (IDataReader loReader = _DatabaseFactory.ExecuteReader(Helper.GetDataBaseType, DataBaseConnectionString, sqlCmd).CreateDataReader()) { while (loReader.Read()) { StudentStatusEn loItem = LoadObject(loReader); eobjSCAccess = new StudentCategoryAccessEn(); eobjSCAccess.StudentCategoryCode = loItem.StudentStatusCode; loItem.LstStudentCategoryAccess = dobjSCAccess.GetStuCatAccessList(eobjSCAccess); loEnList.Add(loItem); eobjSCAccess = null; } loReader.Close(); } } } catch (Exception ex) { throw ex; } return(loEnList); }
/// <summary> /// Method to Insert StudentCategoryAccess /// </summary> /// <param name="argEn">StudentCategoryAccess Entity is an Input.</param> /// <returns>Returns Boolean</returns> public bool Insert(StudentCategoryAccessEn argEn) { bool flag; using (TransactionScope ts = new TransactionScope()) { try { StudentCategoryAccessDAL loDs = new StudentCategoryAccessDAL(); flag = loDs.Insert(argEn); ts.Complete(); } catch (Exception ex) { throw ex; } } return(flag); }
/// <summary> /// Method to Update StudentCategory /// </summary> /// <param name="argEn">StudentCategory Entity is an Input.</param> /// <returns>Returns Boolean</returns> public bool Update(StudentCategoryEn argEn) { bool lbRes = false; int iOut = 0; StudentCategoryAccessEn eobjSCAccess = new StudentCategoryAccessEn(); StudentCategoryAccessDAL dobjSCAccess = new StudentCategoryAccessDAL(); string sqlCmd = "Select count(*) as cnt From SAS_StudentCategory WHERE SASC_Code != @SASC_Code and SASC_Desc = @SASC_Desc"; try { if (!FormHelp.IsBlank(sqlCmd)) { DbCommand cmdSel = _DatabaseFactory.GetDbCommand(Helper.GetDataBaseType, sqlCmd, DataBaseConnectionString); _DatabaseFactory.AddInParameter(ref cmdSel, "@SASC_Code", DbType.String, argEn.StudentCategoryCode); _DatabaseFactory.AddInParameter(ref cmdSel, "@SASC_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 = "UPDATE SAS_StudentCategory SET SASC_Code = @SASC_Code, SASC_Desc = @SASC_Desc, SABR_Code = @SABR_Code, SASC_Status = @SASC_Status, SASC_UpdatedBy = @SASC_UpdatedBy, SASC_UpdatedDtTm = @SASC_UpdatedDtTm WHERE SASC_Code = @SASC_Code"; if (!FormHelp.IsBlank(sqlCmd)) { DbCommand cmd = _DatabaseFactory.GetDbCommand(Helper.GetDataBaseType, sqlCmd, DataBaseConnectionString); _DatabaseFactory.AddInParameter(ref cmd, "@SASC_Code", DbType.String, argEn.StudentCategoryCode); _DatabaseFactory.AddInParameter(ref cmd, "@SASC_Desc", DbType.String, argEn.Description); _DatabaseFactory.AddInParameter(ref cmd, "@SABR_Code", DbType.Int32, argEn.Code); _DatabaseFactory.AddInParameter(ref cmd, "@SASC_Status", DbType.Boolean, argEn.Status); _DatabaseFactory.AddInParameter(ref cmd, "@SASC_UpdatedBy", DbType.String, argEn.UpdatedBy); _DatabaseFactory.AddInParameter(ref cmd, "@SASC_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("Update Failed! No Row has been updated..."); } } } } } catch (Exception ex) { throw ex; } return(lbRes); }
/// <summary> /// Method to Update StudentStatus /// </summary> /// <param name="argEn">StudentStatus Entity is an Input.</param> /// <returns>Returns Boolean</returns> public bool Update(StudentStatusEn argEn) { bool lbRes = false; int iOut = 0; StudentCategoryAccessEn eobjSCAccess = new StudentCategoryAccessEn(); StudentCategoryAccessDAL dobjSCAccess = new StudentCategoryAccessDAL(); string sqlCmd = "Select count(*) as cnt From SAS_StudentStatus WHERE SASS_Code != @SASS_Code and SASS_Description = @SASS_Description"; try { if (!FormHelp.IsBlank(sqlCmd)) { DbCommand cmdSel = _DatabaseFactory.GetDbCommand(Helper.GetDataBaseType, sqlCmd, DataBaseConnectionString); _DatabaseFactory.AddInParameter(ref cmdSel, "@SASS_Code", DbType.String, argEn.StudentStatusCode); _DatabaseFactory.AddInParameter(ref cmdSel, "@SASS_Description", 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 = "UPDATE SAS_StudentStatus SET SASS_Code = @SASS_Code, SASS_Description = @SASS_Description, SASS_BlStatus = @SASS_BlStatus, SABR_Code = @SABR_Code, SASS_Status = @SASS_Status, SASS_UpdatedUser = @SASS_UpdatedUser, SASS_UpdatedDtTm = @SASS_UpdatedDtTm WHERE SASS_Code = @SASS_Code"; if (!FormHelp.IsBlank(sqlCmd)) { DbCommand cmd = _DatabaseFactory.GetDbCommand(Helper.GetDataBaseType, sqlCmd, DataBaseConnectionString); _DatabaseFactory.AddInParameter(ref cmd, "@SASS_Code", DbType.String, argEn.StudentStatusCode); _DatabaseFactory.AddInParameter(ref cmd, "@SASS_Description", DbType.String, argEn.Description); _DatabaseFactory.AddInParameter(ref cmd, "@SASS_BlStatus", DbType.Boolean, argEn.BlStatus); _DatabaseFactory.AddInParameter(ref cmd, "@SABR_Code", DbType.Int32, argEn.Code); _DatabaseFactory.AddInParameter(ref cmd, "@SASS_Status", DbType.Boolean, argEn.Status); _DatabaseFactory.AddInParameter(ref cmd, "@SASS_UpdatedUser", DbType.String, argEn.UpdatedUser); _DatabaseFactory.AddInParameter(ref cmd, "@SASS_UpdatedDtTm", DbType.String, argEn.UpdatedDtTm); _DbParameterCollection = cmd.Parameters; int liRowAffected = _DatabaseFactory.ExecuteNonQuery(Helper.GetDataBaseType, cmd, DataBaseConnectionString, sqlCmd, _DbParameterCollection); eobjSCAccess.StudentCategoryCode = argEn.StudentStatusCode; //Deleting any existing StudentCategoryAccess for this studentstatus dobjSCAccess.Delete(eobjSCAccess); int i = 0; //Inserting StudentCategoryAccess for this studentstatus while (i < argEn.LstStudentCategoryAccess.Count) { eobjSCAccess = argEn.LstStudentCategoryAccess[i]; dobjSCAccess.Insert(eobjSCAccess); eobjSCAccess = null; i = i + 1; } if (liRowAffected > -1) { lbRes = true; } else { throw new Exception("Update Failed! No Row has been updated..."); } } } } } catch (Exception ex) { throw ex; } return(lbRes); }