public static Int32 Save(string CURRENT_USER, Int32 CURRENT_REGISTRY_ID, STD_ROLE objSave)
{
Int32 objReturn = 0;
STD_ROLEDB objDB = new STD_ROLEDB();
objReturn = objDB.Save(CURRENT_USER, CURRENT_REGISTRY_ID, objSave);
return(objReturn);
}
public static STD_ROLE GetItem(string CURRENT_USER, Int32 CURRENT_REGISTRY_ID, Int32 ID)
{
STD_ROLE objReturn = null;
STD_ROLEDB objDB = new STD_ROLEDB();
objReturn = objDB.GetItem(CURRENT_USER, CURRENT_REGISTRY_ID, ID);
return(objReturn);
}
public STD_ROLE ParseReaderCustom(DataRow row)
{
STD_ROLE objReturn = new STD_ROLE
{
CODE = (string)GetNullableObject(row.Field <object>("STD_ROLE_CODE")),
CREATED = (DateTime)GetNullableObject(row.Field <object>("STD_ROLE_CREATED")),
CREATEDBY = (string)GetNullableObject(row.Field <object>("STD_ROLE_CREATEDBY")),
DESCRIPTION_TEXT = (string)GetNullableObject(row.Field <object>("STD_ROLE_DESCRIPTION_TEXT")),
ID = (Int32)GetNullableObject(row.Field <object>("STD_ROLE_ID")),
INACTIVE_DATE = (DateTime?)GetNullableObject(row.Field <object>("STD_ROLE_INACTIVE_DATE")),
INACTIVE_FLAG = (bool)GetNullableObject(row.Field <object>("STD_ROLE_INACTIVE_FLAG")),
NAME = (string)GetNullableObject(row.Field <object>("STD_ROLE_NAME")),
PARENT_ROLE_ID = (Int32?)GetNullableObject(row.Field <object>("STD_ROLE_PARENT_ROLE_ID")),
SORT_ORDER = (Int32)GetNullableObject(row.Field <object>("STD_ROLE_SORT_ORDER")),
STD_REGISTRY_ID = (Int32)GetNullableObject(row.Field <object>("STD_ROLE_STD_REGISTRY_ID")),
SUPER_USER_FLAG = (bool)GetNullableObject(row.Field <object>("STD_ROLE_SUPER_USER_FLAG")),
UPDATED = (DateTime)GetNullableObject(row.Field <object>("STD_ROLE_UPDATED")),
UPDATEDBY = (string)GetNullableObject(row.Field <object>("STD_ROLE_UPDATEDBY"))
};
return(objReturn);
}
private void UpdateRoles(int registryId, int roleId)
{
List <USER_ROLES> userRoles = UserRoles;
int userId = 0;
int.TryParse(hideUserId.Value, out userId);
if (registryId > 0)
{
bool foundRegistry = false;
if (userRoles != null)
{
for (int i = 0; i < userRoles.Count; i++)
{
if (userRoles[i].STD_ROLE == null)
{
userRoles[i].STD_ROLE = ServiceInterfaceManager.STD_ROLE_GET(HttpContext.Current.User.Identity.Name, UserSession.CurrentRegistryId, userRoles[i].STD_ROLE_ID);
}
if (userRoles[i].STD_ROLE != null && userRoles[i].STD_ROLE.STD_REGISTRY_ID == registryId)
{
foundRegistry = true;
userRoles[i].UPDATED = DateTime.Now;
userRoles[i].UPDATEDBY = HttpContext.Current.User.Identity.Name;
if (roleId > 0)
{
userRoles[i].INACTIVE_FLAG = false;
userRoles[i].INACTIVE_DATE = null;
if (userRoles[i].STD_ROLE_ID != roleId)
{
userRoles[i].STD_ROLE = ServiceInterfaceManager.STD_ROLE_GET(HttpContext.Current.User.Identity.Name, UserSession.CurrentRegistryId, roleId);
}
userRoles[i].STD_ROLE_ID = roleId;
}
else
{
userRoles[i].INACTIVE_FLAG = true;
userRoles[i].INACTIVE_DATE = DateTime.Now;
//userRoles[i].STD_ROLE_ID = roleId;
}
}
}
}
if (!foundRegistry && roleId > 0)
{
if (userRoles == null)
{
userRoles = new List <USER_ROLES>();
}
USER_ROLES userRole = new USER_ROLES();
userRole.CREATED = userRole.UPDATED = DateTime.Now;
userRole.CREATEDBY = userRole.UPDATEDBY = HttpContext.Current.User.Identity.Name;
userRole.INACTIVE_FLAG = false;
userRole.INACTIVE_DATE = null;
userRole.USER_ID = userId;
STD_ROLE stdRole = ServiceInterfaceManager.STD_ROLE_GET(HttpContext.Current.User.Identity.Name, UserSession.CurrentRegistryId, roleId);
if (stdRole != null)
{
userRole.STD_ROLE_ID = stdRole.ID;
userRole.STD_ROLE = stdRole;
userRoles.Add(userRole);
}
}
}
if (userRoles != null && userRoles.Count > 0)
{
UserRoles = userRoles;
}
}
public STD_ROLE GetItem(string CURRENT_USER, Int32 CURRENT_REGISTRY_ID, Int32 ID)
{
STD_ROLE objReturn = null;
SqlConnection sConn = null;
SqlCommand sCmd = null;
SqlDataAdapter sAdapter = null;
DataSet objTemp = null;
try
{
sConn = new SqlConnection(SqlConnectionString);
sConn.Open();
sCmd = new SqlCommand("CRS.usp_STD_ROLE_getitem", sConn);
sCmd.CommandTimeout = SqlCommandTimeout;
sCmd.CommandType = CommandType.StoredProcedure;
sCmd.Parameters.AddWithValue("@CURRENT_USER", CURRENT_USER);
sCmd.Parameters.AddWithValue("@CURRENT_REGISTRY_ID", CURRENT_REGISTRY_ID);
sCmd.Parameters.AddWithValue("@ID", ID);
objTemp = new DataSet();
sAdapter = new SqlDataAdapter(sCmd);
LogDetails logDetails = new LogDetails(String.Format("{0}.{1}", System.Reflection.MethodBase.GetCurrentMethod().DeclaringType.FullName, System.Reflection.MethodBase.GetCurrentMethod().Name), CURRENT_USER, CURRENT_REGISTRY_ID);
sAdapter.Fill(objTemp);
LogManager.LogTiming(logDetails);
CheckDataSet(objTemp);
if (objTemp != null && objTemp.Tables.Count > 0 && objTemp.Tables[0].Rows.Count > 0)
{
objReturn = ParseReader(objTemp.Tables[0].Rows[0]);
}
sConn.Close();
}
catch (Exception ex)
{
LogManager.LogError(ex.Message, String.Format("{0}.{1}", System.Reflection.MethodBase.GetCurrentMethod().DeclaringType.FullName, System.Reflection.MethodBase.GetCurrentMethod().Name), CURRENT_USER, CURRENT_REGISTRY_ID);
throw ex;
}
finally
{
if (sAdapter != null)
{
sAdapter.Dispose();
sAdapter = null;
}
if (sCmd != null)
{
sCmd.Dispose();
sCmd = null;
}
if (sConn != null)
{
if (sConn.State != ConnectionState.Closed)
{
sConn.Close();
}
sConn.Dispose();
sConn = null;
}
}
return(objReturn);
}
public Int32 Save(string CURRENT_USER, Int32 CURRENT_REGISTRY_ID, STD_ROLE objSave)
{
Int32 objReturn = 0;
SqlConnection sConn = null;
SqlCommand sCmd = null;
SqlParameter p = null;
try
{
sConn = new SqlConnection(SqlConnectionString);
sConn.Open();
sCmd = new SqlCommand("CRS.usp_STD_ROLE_save", sConn);
sCmd.CommandTimeout = SqlCommandTimeout;
sCmd.CommandType = CommandType.StoredProcedure;
sCmd.Parameters.AddWithValue("@CURRENT_USER", CURRENT_USER);
sCmd.Parameters.AddWithValue("@CURRENT_REGISTRY_ID", CURRENT_REGISTRY_ID);
p = new SqlParameter("@CODE", SqlDbType.VarChar, 50);
p.Precision = 0;
p.Scale = 0;
AddParameter(ref sCmd, ref p, objSave.CODE);
p = new SqlParameter("@CREATED", SqlDbType.DateTime, 8);
p.Precision = 23;
p.Scale = 3;
AddParameter(ref sCmd, ref p, objSave.CREATED);
p = new SqlParameter("@CREATEDBY", SqlDbType.VarChar, 30);
p.Precision = 0;
p.Scale = 0;
AddParameter(ref sCmd, ref p, objSave.CREATEDBY);
p = new SqlParameter("@DESCRIPTION_TEXT", SqlDbType.VarChar, 500);
p.Precision = 0;
p.Scale = 0;
AddParameter(ref sCmd, ref p, objSave.DESCRIPTION_TEXT);
p = new SqlParameter("@ID", SqlDbType.Int, 4);
p.Direction = ParameterDirection.InputOutput;
p.Precision = 10;
p.Scale = 0;
AddParameter(ref sCmd, ref p, objSave.ID);
p = new SqlParameter("@INACTIVE_DATE", SqlDbType.DateTime, 8);
p.Precision = 23;
p.Scale = 3;
AddParameter(ref sCmd, ref p, objSave.INACTIVE_DATE);
p = new SqlParameter("@INACTIVE_FLAG", SqlDbType.Bit, 1);
p.Precision = 1;
p.Scale = 0;
AddParameter(ref sCmd, ref p, objSave.INACTIVE_FLAG);
p = new SqlParameter("@NAME", SqlDbType.VarChar, 100);
p.Precision = 0;
p.Scale = 0;
AddParameter(ref sCmd, ref p, objSave.NAME);
p = new SqlParameter("@PARENT_ROLE_ID", SqlDbType.Int, 4);
p.Precision = 10;
p.Scale = 0;
AddParameter(ref sCmd, ref p, objSave.PARENT_ROLE_ID);
p = new SqlParameter("@SORT_ORDER", SqlDbType.Int, 4);
p.Precision = 10;
p.Scale = 0;
AddParameter(ref sCmd, ref p, objSave.SORT_ORDER);
p = new SqlParameter("@STD_REGISTRY_ID", SqlDbType.Int, 4);
p.Precision = 10;
p.Scale = 0;
AddParameter(ref sCmd, ref p, objSave.STD_REGISTRY_ID);
p = new SqlParameter("@SUPER_USER_FLAG", SqlDbType.Bit, 1);
p.Precision = 1;
p.Scale = 0;
AddParameter(ref sCmd, ref p, objSave.SUPER_USER_FLAG);
p = new SqlParameter("@UPDATED", SqlDbType.DateTime, 8);
p.Precision = 23;
p.Scale = 3;
AddParameter(ref sCmd, ref p, objSave.UPDATED);
p = new SqlParameter("@UPDATEDBY", SqlDbType.VarChar, 30);
p.Precision = 0;
p.Scale = 0;
AddParameter(ref sCmd, ref p, objSave.UPDATEDBY);
LogDetails logDetails = new LogDetails(String.Format("{0}.{1}", System.Reflection.MethodBase.GetCurrentMethod().DeclaringType.FullName, System.Reflection.MethodBase.GetCurrentMethod().Name), CURRENT_USER, CURRENT_REGISTRY_ID);
int cnt = sCmd.ExecuteNonQuery();
LogManager.LogTiming(logDetails);
objReturn = (Int32)sCmd.Parameters["@ID"].Value;
sConn.Close();
}
catch (Exception ex)
{
LogManager.LogError(ex.Message, String.Format("{0}.{1}", System.Reflection.MethodBase.GetCurrentMethod().DeclaringType.FullName, System.Reflection.MethodBase.GetCurrentMethod().Name), CURRENT_USER, CURRENT_REGISTRY_ID);
throw ex;
}
finally
{
if (sCmd != null)
{
sCmd.Dispose();
sCmd = null;
}
if (sConn != null)
{
if (sConn.State != ConnectionState.Closed)
{
sConn.Close();
}
sConn.Dispose();
sConn = null;
}
}
return(objReturn);
}
public static Boolean Delete(string CURRENT_USER, Int32 CURRENT_REGISTRY_ID, STD_ROLE objDelete)
{
return(Delete(CURRENT_USER, CURRENT_REGISTRY_ID, objDelete.ID));
}
