public List <userroles> userrolesGetAll()
{
List <userroles> lstuserroles = new List <userroles>();
try
{
DataTable dt = SqlHelper.ExecuteDataset(SqlImplHelper.getConnectionString(), "userrolesGetAll").Tables[0];
if (dt.Rows.Count > 0)
{
int colUserRoleId = dt.Columns["UserRoleId"].Ordinal;
int colUserRoleDescription = dt.Columns["UserRoleDescription"].Ordinal;
for (int i = 0; dt.Rows.Count > i; i++)
{
userroles NewEnt = new userroles();
NewEnt.UserRoleId = Int32.Parse(dt.Rows[i].ItemArray[colUserRoleId].ToString());
NewEnt.UserRoleDescription = dt.Rows[i].ItemArray[colUserRoleDescription].ToString();
lstuserroles.Add(NewEnt);
}
}
return(lstuserroles);
}
catch (Exception ex)
{
throw ex;
}
}
public List<userroles> userrolesGetAll()
{
List<userroles> lstuserroles = new List<userroles>();
try
{
DataTable dt = SqlHelper.ExecuteDataset(SqlImplHelper.getConnectionString(), "userrolesGetAll").Tables[0];
if (dt.Rows.Count > 0)
{
int colUserRoleId = dt.Columns["UserRoleId"].Ordinal;
int colUserRoleDescription = dt.Columns["UserRoleDescription"].Ordinal;
for (int i = 0; dt.Rows.Count > i; i++)
{
userroles NewEnt = new userroles();
NewEnt.UserRoleId = Int32.Parse(dt.Rows[i].ItemArray[colUserRoleId].ToString());
NewEnt.UserRoleDescription = dt.Rows[i].ItemArray[colUserRoleDescription].ToString();
lstuserroles.Add(NewEnt);
}
}
return lstuserroles;
}
catch(Exception ex)
{
throw ex;
}
}
public roles AddNewRole(string userId, string Id)
{
using (var db = new OcphDbContext())
{
try
{
userroles userrole = new userroles {
RoleId = Id, UserId = userId
};
var role = db.Roles.Where(O => O.Id == Id).FirstOrDefault();
if (role != null)
{
if (db.UserRoles.Insert(userrole))
{
return(role);
}
else
{
throw new SystemException("User Role Gagal Ditambah");
}
}
else
{
throw new SystemException("Role Tidak Ditemukan");
}
}
catch (Exception ex)
{
throw new SystemException(ex.Message);
}
}
}
public DataTable SaveUserRoles(userroles U)
{
LogTraceWriter traceWriter = new LogTraceWriter();
traceWriter.Trace(Request, "0", TraceLevel.Info, "{0}", "SaveUserRoles ....");
DataTable Tbl = new DataTable();
SqlConnection conn = new SqlConnection();
try
{
//connetionString="Data Source=ServerName;Initial Catalog=DatabaseName;User ID=UserName;Password=Password"
conn.ConnectionString = System.Configuration.ConfigurationManager.ConnectionStrings["btposdb"].ToString();
//conn.ConnectionString = "Data Source=localhost;Initial Catalog=MyAlerts;integrated security=sspi;";
SqlCommand cmd = new SqlCommand();
cmd.CommandType = CommandType.StoredProcedure;
cmd.CommandText = "InsUpdDelUserRoles";
cmd.Connection = conn;
conn.Open();
SqlParameter UId = new SqlParameter("@Id", SqlDbType.Int);
UId.Value = U.Id;
cmd.Parameters.Add(UId);
SqlParameter URole = new SqlParameter("@UserId", SqlDbType.Int);
URole.Value = U.UserId;
cmd.Parameters.Add(URole);
SqlParameter UUser = new SqlParameter("@roleid", SqlDbType.Int);
UUser.Value = U.RoleId;
cmd.Parameters.Add(UUser);
SqlParameter UCmp = new SqlParameter("@CompanyId", SqlDbType.Int);
UCmp.Value = U.CompanyId;
cmd.Parameters.Add(UCmp);
SqlParameter insupdflag = new SqlParameter("@insupdflag", SqlDbType.VarChar, 10);
insupdflag.Value = U.insupdflag;
cmd.Parameters.Add(insupdflag);
cmd.ExecuteScalar();
conn.Close();
traceWriter.Trace(Request, "0", TraceLevel.Info, "{0}", "SaveUserRoles completed.");
}
catch (Exception ex)
{
conn.Close();
string str = ex.Message;
traceWriter.Trace(Request, "1", TraceLevel.Info, "{0}", "Error in SaveUserRoles:" + ex.Message);
}
// int found = 0;
return(Tbl);
}
public DataTable SaveUserRoles(userroles U)
{
DataTable Tbl = new DataTable();
SqlConnection conn = new SqlConnection();
try
{
conn.ConnectionString = System.Configuration.ConfigurationManager.ConnectionStrings["EES_DB_ConnectionString"].ToString();
SqlCommand cmd = new SqlCommand();
cmd.CommandType = CommandType.StoredProcedure;
cmd.CommandText = "InsUpdDelUserRoles";
cmd.Connection = conn;
conn.Open();
SqlParameter UId = new SqlParameter("@Id", SqlDbType.Int);
UId.Value = U.Id;
cmd.Parameters.Add(UId);
SqlParameter URole = new SqlParameter("@UserId", SqlDbType.Int);
URole.Value = U.UserId;
cmd.Parameters.Add(URole);
SqlParameter UUser = new SqlParameter("@roleid", SqlDbType.Int);
UUser.Value = U.RoleId;
cmd.Parameters.Add(UUser);
SqlParameter UCmp = new SqlParameter("@LocationId", SqlDbType.Int);
UCmp.Value = U.LocationId;
cmd.Parameters.Add(UCmp);
SqlParameter insupdflag = new SqlParameter("@insupdflag", SqlDbType.VarChar);
insupdflag.Value = U.insupdflag;
cmd.Parameters.Add(insupdflag);
cmd.ExecuteScalar();
conn.Close();
//Logger.Trace(LogCategory.WebApp, "InsUpdDelUserRoles stored procedure is executed successfully.", LogLevel.Information, null);
}
catch (Exception ex)
{
conn.Close();
string str = ex.Message;
//Logger.Error(ex, LogCategory.WebApp, "An error occured in SaveUserRoles() procedure", LogLevel.Error, null);
}
// int found = 0;
return(Tbl);
}
public int userrolesAdd( userroles userroles)
{
try
{
return (int)SqlHelper.ExecuteScalar(SqlImplHelper.getConnectionString(), "userrolesAdd",
userroles.UserRoleDescription);
}
catch(Exception ex)
{
throw ex;
}
}
public int userrolesAdd(userroles userroles)
{
try
{
return((int)SqlHelper.ExecuteScalar(SqlImplHelper.getConnectionString(), "userrolesAdd",
userroles.UserRoleDescription));
}
catch (Exception ex)
{
throw ex;
}
}
public userroles userrolesGetById(int UserRoleId)
{
try
{
DataTable dt = SqlHelper.ExecuteDataset(SqlImplHelper.getConnectionString(), "userrolesGetById",
UserRoleId).Tables[0];
userroles NewEnt = new userroles();
if(dt.Rows.Count > 0)
{
DataRow dr = dt.Rows[0];
NewEnt.UserRoleId = Int32.Parse(dr["UserRoleId"].ToString());
NewEnt.UserRoleDescription = dr["UserRoleDescription"].ToString();
}
return NewEnt;
}
catch(Exception ex)
{
throw ex;
}
}
public userroles userrolesGetById(int UserRoleId)
{
try
{
DataTable dt = SqlHelper.ExecuteDataset(SqlImplHelper.getConnectionString(), "userrolesGetById",
UserRoleId).Tables[0];
userroles NewEnt = new userroles();
if (dt.Rows.Count > 0)
{
DataRow dr = dt.Rows[0];
NewEnt.UserRoleId = Int32.Parse(dr["UserRoleId"].ToString());
NewEnt.UserRoleDescription = dr["UserRoleDescription"].ToString();
}
return(NewEnt);
}
catch (Exception ex)
{
throw ex;
}
}
public bool userrolesUpdate(userroles userroles)
{
try
{
int update = SqlHelper.ExecuteNonQuery(SqlImplHelper.getConnectionString(), "userrolesUpdate",
userroles.UserRoleId,
userroles.UserRoleDescription);
if (update > 0)
{
return(true);
}
else
{
return(false);
}
}
catch (Exception ex)
{
throw ex;
}
}
protected void ddlUserGroup_SelectedIndexChanged(object sender, EventArgs e)
{
List <userrolesmapping> lstGroupRolesMapping = new List <userrolesmapping>();
userrolesmappingBus oRolesMapping = new userrolesmappingBus();
userroles auxRol = new userroles();
userrolesBus oRoles = new userrolesBus();
cblRolesRoles.Items.Clear();
if (lstGroupRolesMapping.Count > 0)
{
int index = 0;
foreach (userrolesmapping rowRolMapping in lstGroupRolesMapping)
{
auxRol = oRoles.userrolesGetById(rowRolMapping.UserRoleId);
cblRolesRoles.Items.Add(auxRol.UserRoleDescription);
cblRolesRoles.Items[index].Selected = true;
index++;
}
}
}
public HttpResponseMessage roles(userroles b)
{
LogTraceWriter traceWriter = new LogTraceWriter();
traceWriter.Trace(Request, "0", TraceLevel.Info, "{0}", "SaveUserRoles credentials....");
//connect to database
SqlConnection conn = new SqlConnection();
try
{
//connetionString="Data Source=ServerName;Initial Catalog=DatabaseName;User ID=UserName;Password=Password"
conn.ConnectionString = System.Configuration.ConfigurationManager.ConnectionStrings["btposdb"].ToString();
SqlCommand cmd = new SqlCommand();
cmd.CommandType = CommandType.StoredProcedure;
cmd.CommandText = "InsUpdDelUserRoles";
cmd.Connection = conn;
conn.Open();
SqlParameter Aid = new SqlParameter();
Aid.ParameterName = "@Id";
Aid.SqlDbType = SqlDbType.Int;
Aid.Value = Convert.ToString(b.Id);
cmd.Parameters.Add(Aid);
SqlParameter iid = new SqlParameter();
iid.ParameterName = "@UserId";
iid.SqlDbType = SqlDbType.Int;
iid.Value = Convert.ToString(b.UserId);
cmd.Parameters.Add(iid);
SqlParameter ii = new SqlParameter();
ii.ParameterName = "@CompanyId";
ii.SqlDbType = SqlDbType.Int;
ii.Value = Convert.ToString(b.CompanyId);
cmd.Parameters.Add(ii);
SqlParameter rr = new SqlParameter();
rr.ParameterName = "@RoleId";
rr.SqlDbType = SqlDbType.Int;
rr.Value = Convert.ToString(b.RoleId);
cmd.Parameters.Add(rr);
SqlParameter ss = new SqlParameter();
ss.ParameterName = "@Passkey";
ss.SqlDbType = SqlDbType.VarChar;
ss.Value = b.Passkey;
cmd.Parameters.Add(ss);
//DataSet ds = new DataSet();
//SqlDataAdapter db = new SqlDataAdapter(cmd);
//db.Fill(ds);
// Tbl = Tables[0];
cmd.ExecuteScalar();
conn.Close();
traceWriter.Trace(Request, "0", TraceLevel.Info, "{0}", "SaveUserRoles Credentials completed.");
return(new HttpResponseMessage(HttpStatusCode.OK));
}
catch (Exception ex)
{
if (conn != null && conn.State == ConnectionState.Open)
{
conn.Close();
}
string str = ex.Message;
traceWriter.Trace(Request, "1", TraceLevel.Info, "{0}", "Error in SaveUserRoles:" + ex.Message);
return(Request.CreateErrorResponse(HttpStatusCode.NotFound, ex));
}
}
public bool userrolesUpdate(userroles userroles)
{
userrolesImpl ouserrolesImpl = new userrolesImpl();
return(ouserrolesImpl.userrolesUpdate(userroles));
}
public int userrolesAdd(userroles userroles)
{
userrolesImpl ouserrolesImpl = new userrolesImpl();
return(ouserrolesImpl.userrolesAdd(userroles));
}
public bool userrolesUpdate( userroles userroles)
{
try
{
int update = SqlHelper.ExecuteNonQuery(SqlImplHelper.getConnectionString(), "userrolesUpdate",
userroles.UserRoleId,
userroles.UserRoleDescription);
if (update > 0)
{
return true;
}
else
{
return false;
}
}
catch(Exception ex)
{
throw ex;
}
}
protected void gvUsers_SelectedIndexChanged(object sender, EventArgs e)
{
GridViewRow row = gvUsers.SelectedRow;
users auxUser = new users();
usersBus oUser = new usersBus();
List <userrolesmapping> lstGroupRolesMapping = new List <userrolesmapping>();
userrolesmappingBus oRolesMapping = new userrolesmappingBus();
userroles auxRol = new userroles();
userrolesBus oRoles = new userrolesBus();
try
{
ddlUserGroup.SelectedValue = ((Label)row.FindControl("userGroupId")).Text;
}
catch
{
}
if ((Label)row.FindControl("userId") != null)
{
userId.Value = ((Label)row.FindControl("userId")).Text;
}
else
{
userId.Value = "";
}
if ((Label)row.FindControl("userName") != null)
{
txtUserName.Text = ((Label)row.FindControl("userName")).Text;
}
else
{
txtUserName.Text = "";
}
if ((Label)row.FindControl("userLastName") != null)
{
txtUserLastName.Text = ((Label)row.FindControl("userLastName")).Text;
}
else
{
txtUserLastName.Text = "";
}
if ((Label)row.FindControl("userFirstName") != null)
{
txtUserFirstName.Text = ((Label)row.FindControl("userFirstName")).Text;
}
else
{
txtUserFirstName.Text = "";
}
if ((CheckBox)row.FindControl("userActive") != null)
{
chkActive.Checked = ((CheckBox)row.FindControl("userActive")).Checked;
}
else
{
chkActive.Checked = false;
}
auxUser = oUser.usersGetById(Convert.ToInt32(userId.Value));
txtMail.Text = auxUser.UserMail;
txtPassword.Text = auxUser.UserPassword;
txtSMS.Text = auxUser.UserSMSNumber;
cblRolesRoles.Items.Clear();
lstGroupRolesMapping = oRolesMapping.userrolesmappingGetByUserGroupId(Convert.ToInt32(ddlUserGroup.SelectedValue));
if (lstGroupRolesMapping.Count > 0)
{
int index = 0;
foreach (userrolesmapping rowRolMapping in lstGroupRolesMapping)
{
auxRol = oRoles.userrolesGetById(rowRolMapping.UserRoleId);
cblRolesRoles.Items.Add(auxRol.UserRoleDescription);
cblRolesRoles.Items[index].Selected = true;
index++;
}
}
activateFields(true, false);
btnSave.Enabled = true;
}
public bool userrolesUpdate(userroles userroles)
{
userrolesImpl ouserrolesImpl = new userrolesImpl();
return ouserrolesImpl.userrolesUpdate( userroles);
}
public int userrolesAdd(userroles userroles)
{
userrolesImpl ouserrolesImpl = new userrolesImpl();
return ouserrolesImpl.userrolesAdd( userroles);
}
