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