public RoleViewModel Insert(RoleViewModel objEntity)
{
try
{
Database objDB = base.GetDatabase();
// Create a suitable command type and add the required parameter.
using (DbCommand sprocCmd = objDB.GetStoredProcCommand(SPS_ROLEVIEWMODELINSERT))
{
objDB.AddInParameter(sprocCmd, COLUMN_NAME_ROLE_NAME, DbType.String, objEntity.RoleName);
objDB.AddInParameter(sprocCmd, COLUMN_NAME_SHORT_NAME, DbType.String, objEntity.ShortName);
objDB.AddInParameter(sprocCmd, COLUMN_NAME_ROLE_STATUS, DbType.Int16, objEntity.RoleStatus);
objDB.AddInParameter(sprocCmd, COLUMN_NAME_SORT_ORDER, DbType.Int16, objEntity.SortOrder);
objDB.AddInParameter(sprocCmd, COLUMN_NAME_CREATED_BY, DbType.Int32, objEntity.CreatedBy);
objDB.AddOutParameter(sprocCmd, COLUMN_NAME_ROLE_ID, DbType.Int32, objEntity.RoleId);
objDB.AddOutParameter(sprocCmd, COLUMN_NAME_RESULT, DbType.Int32, objEntity.Result);
objDB.ExecuteNonQuery(sprocCmd);
objEntity.RoleId = Convert.ToInt16(objDB.GetParameterValue(sprocCmd, COLUMN_NAME_ROLE_ID));
objEntity.Result = Convert.ToInt32(objDB.GetParameterValue(sprocCmd, COLUMN_NAME_RESULT));
}
}
catch (Exception ex)
{
throw ex;
}
finally
{
}
return objEntity;
}
public int Delete(int Flag, RoleViewModel objEntity)
{
int result = 0;
try
{
Database objDB = base.GetDatabase();
// Create a suitable command type and add the required parameter.
using (DbCommand sprocCmd = objDB.GetStoredProcCommand(SPS_ROLEVIEWMODELDELETE))
{
objDB.AddInParameter(sprocCmd, COLUMN_NAME_FLAG, DbType.Int32, Flag);
objDB.AddInParameter(sprocCmd, COLUMN_NAME_ROLE_ID, DbType.Int32, objEntity.RoleId);
objDB.AddOutParameter(sprocCmd, COLUMN_NAME_RESULT, DbType.Int32, result);
objDB.ExecuteNonQuery(sprocCmd);
result = Convert.ToInt32(objDB.GetParameterValue(sprocCmd, COLUMN_NAME_RESULT));
}
}
catch (Exception ex)
{
throw ex;
}
finally
{
}
return result;
}
public List<RoleViewModel> Select(int Flag, RoleViewModel objEntity)
{
var objEntityList = new List<RoleViewModel>();
try
{
Database objDB = base.GetDatabase();
// Create a suitable command type and add the required parameter.
using (DbCommand sprocCmd = objDB.GetStoredProcCommand(SPS_ROLEVIEWMODELSELECT))
{
objDB.AddInParameter(sprocCmd, COLUMN_NAME_FLAG, DbType.Int32, Flag);
objDB.AddInParameter(sprocCmd, COLUMN_NAME_ROLE_ID, DbType.Int32, objEntity.RoleId);
using (IDataReader reader = objDB.ExecuteReader(sprocCmd))
{
while (reader.Read())
{
var objEntityViewModel = new RoleViewModel();
objEntityViewModel.RoleId = reader.GetColumnValue<Int16>(COLUMN_NAME_ROLE_ID);
objEntityViewModel.RoleName = reader.GetColumnValue<string>(COLUMN_NAME_ROLE_NAME);
objEntityViewModel.ShortName = reader.GetColumnValue<string>(COLUMN_NAME_SHORT_NAME);
objEntityViewModel.RoleStatus = (StatusEnum)reader.GetColumnValue<Int16>(COLUMN_NAME_ROLE_STATUS);
objEntityViewModel.SortOrder = reader.GetColumnValue<Int16>(COLUMN_NAME_SORT_ORDER);
objEntityViewModel.CreatedDate = reader.GetColumnValue<DateTime>(COLUMN_NAME_CREATED_DATE);
objEntityViewModel.CreatedBy = reader.GetColumnValue<Int32>(COLUMN_NAME_CREATED_BY);
objEntityViewModel.ModifiedDate = reader.GetColumnValue<DateTime>(COLUMN_NAME_MODIFIED_DATE);
objEntityViewModel.ModifiedBy = reader.GetColumnValue<Int32>(COLUMN_NAME_MODIFIED_BY);
if (objEntityViewModel != null)
{
objEntityList.Add(objEntityViewModel);
}
}
}
}
}
catch (Exception ex)
{
throw ex;
}
finally
{
}
return objEntityList;
}
