public StatusDTO <UserEntitlementDTO> InsertUserEntitlement(UserEntitlementDTO data) { using (IDbSvc dbSvc = new DbSvc(_configSvc)) { try { dbSvc.OpenConnection(); MySqlCommand command = new MySqlCommand(); command.CommandText = "UserEntitlementMap"; command.CommandType = CommandType.StoredProcedure; command.Connection = dbSvc.GetConnection() as MySqlConnection; command.Parameters.Add("@UserMasterId1", MySqlDbType.String).Value = data.UserDetails.UserMasterId; command.Parameters.Add("@UserRoleId1", MySqlDbType.String).Value = data.RoleDetails.UserRoleId; MySqlDataReader rdr = command.ExecuteReader(CommandBehavior.CloseConnection); _dtData = new DataTable(); _dtData.Load(rdr); StatusDTO <UserEntitlementDTO> status = new StatusDTO <UserEntitlementDTO>(); return(status); } catch (Exception exp) { throw exp; } } }
public StatusDTO <UserEntitlementDTO> UpdateUserEntitlement(UserEntitlementDTO data) { StatusDTO <UserEntitlementDTO> status = new StatusDTO <UserEntitlementDTO>(); status.IsSuccess = false; using (IDbSvc dbSvc = new DbSvc(_configSvc)) { try { dbSvc.OpenConnection(); MySqlCommand command = new MySqlCommand(); command.CommandText = "UPDATE userentitlement set UserRoleId=@UserRoleId1 WHERE UserEntitleMentId=@UserEntitleMentId"; command.Parameters.Add("@UserEntitleMentId", MySqlDbType.Int32).Value = data.RowId; command.Parameters.Add("@UserRoleId1", MySqlDbType.Int32).Value = data.RoleDetails.UserRoleId; command.Connection = dbSvc.GetConnection() as MySqlConnection; if (command.ExecuteNonQuery() > 0) { status.IsSuccess = true; } return(status); } catch (Exception exp) { _logger.Log(exp); throw exp; } } }
public JsonResult DeleteUserEntitlement(UserEntitlementDTO uTrans) { if (_userSvc.DeleteUserEntitlement(uTrans).IsSuccess) { return(Json(new { status = true, message = "Deleted successfully." }, JsonRequestBehavior.AllowGet)); } return(Json(new { status = false, message = "Delete failed." }, JsonRequestBehavior.AllowGet)); }
//To get user entitlementlist public List <UserEntitlementDTO> GetUserEntitlement(int userMasterId) { using (IDbSvc dbSvc = new DbSvc(_configSvc)) { try { dbSvc.OpenConnection(); MySqlCommand command = new MySqlCommand(); command.CommandText = "SELECT UserEntitleMentId, UserMasterId, UserRoleId FROM userentitlement WHERE UserMasterId=@umId"; command.Parameters.Add("@umId", MySqlDbType.Int32).Value = userMasterId; command.Connection = dbSvc.GetConnection() as MySqlConnection; MySqlDataAdapter mDa = new MySqlDataAdapter(command); _dtData = new DataTable(); mDa.Fill(_dtData); List <UserEntitlementDTO> lstUEnt = null; if (_dtData != null && _dtData.Rows.Count > 0) { lstUEnt = new List <UserEntitlementDTO>(); UserEntitlementDTO uEntDTO = null; foreach (DataRow dr in _dtData.Rows) { uEntDTO = new UserEntitlementDTO(); uEntDTO.UserDetails = new UserMasterDTO(); uEntDTO.RoleDetails = new EntitlementDTO(); uEntDTO.RowId = (int)dr["UserEntitleMentId"]; uEntDTO.UserDetails.UserMasterId = (int)dr["UserMasterId"]; uEntDTO.RoleDetails.UserRoleId = (int)dr["UserRoleId"]; lstUEnt.Add(uEntDTO); } } return(lstUEnt); } catch (Exception exp) { _logger.Log(exp); throw exp; } } }