internal int UpdateRoles(UserRolesModal obj) { int final = 0; try { using (var connection = new OleDbConnection(connString)) { connection.Open(); using (var cmd = new OleDbCommand()) { cmd.CommandTimeout = 300; cmd.Connection = connection; cmd.CommandText = "UPDATE Roles SET DeleteInd =" + 0 + " , RoleName='" + obj.RoleName + "' , LastUpdatedDt=" + DateTime.Now.ToString("MM/dd/yyyy") + " , RoleDesc='" + obj.RoleDesc + "' WHERE RoleId =" + obj.RoleId; final = final + cmd.ExecuteNonQuery(); return(final); } } } catch (Exception ex) { _logger.LogError($"$$$SaveActivityAttend$$$####Error Message ->>>{ex} && {ex.Message}###### + StackTrace {ex.StackTrace}######## + InnerEx{ex.InnerException}#####"); return(0); } }
internal int DeleteRoles(UserRolesModal userRolesModal) { int final = 0; try { using (var connection = new OleDbConnection(connString)) { connection.Open(); using (var cmd = new OleDbCommand()) { cmd.CommandTimeout = 300; cmd.Connection = connection; cmd.CommandText = "UPDATE Roles SET DeleteInd = " + 1 + " WHERE RoleId =" + userRolesModal.RoleId; final = final + cmd.ExecuteNonQuery(); return(final); } } } catch (Exception ex) { _logger.LogError($"$$$SaveActivityAttend$$$####Error Message ->>>{ex} && {ex.Message}###### + StackTrace {ex.StackTrace}######## + InnerEx{ex.InnerException}#####"); return(0); } }
public IActionResult ManageRoles(UserRolesModal userRolesModal, string action) { var result = new RequestResult <bool>() { Data = _rolesManager.ManageRoles(userRolesModal, action), Message = "Success", Success = true }; return(Ok(result)); }
public bool ManageRoles(UserRolesModal userRolesModal, string action) { if (action.ToLower().Trim() == "add") { return(_userRolesDataAccess.AddNewRoles(userRolesModal)); } if (action.ToLower().Trim() == "edit") { return(_userRolesDataAccess.UpdateRoles(userRolesModal)); } if (action.ToLower().Trim() == "delete") { return(_userRolesDataAccess.DeleteRoles(userRolesModal)); } throw new CustomException("Invalid Action"); }
internal int AddNewRoles(UserRolesModal userRolesModal) { int final = 0; var maxCount = GetModelDetails("select MAX(RoleId) as RoleId from Roles").AsEnumerable().FirstOrDefault().Field <int>("RoleId"); try { using (var connection = new OleDbConnection(connString)) { connection.Open(); using (var cmd = new OleDbCommand(@"INSERT into Roles (RoleId, RoleName, LastUpdatedDt, DeleteInd, RoleDesc) VALUES (@RoleId, @RoleName, @LastUpdatedDt, @DeleteInd, @RoleDesc)", connection)) { cmd.CommandTimeout = 300; cmd.Parameters.Add(new OleDbParameter { ParameterName = "@RoleId", Value = maxCount + 1, OleDbType = OleDbType.Integer }); cmd.Parameters.Add(new OleDbParameter { ParameterName = "@RoleName", Value = userRolesModal.RoleName.ToString(), OleDbType = OleDbType.VarWChar }); cmd.Parameters.Add(new OleDbParameter { ParameterName = "@LastUpdatedDt", Value = DateTime.Now, OleDbType = OleDbType.Date }); cmd.Parameters.Add(new OleDbParameter { ParameterName = "@DeleteInd", Value = 0, OleDbType = OleDbType.Integer }); cmd.Parameters.Add(new OleDbParameter { ParameterName = "@RoleDesc", Value = userRolesModal.RoleDesc, OleDbType = OleDbType.VarWChar }); final = final + cmd.ExecuteNonQuery(); return(final); } } } catch (Exception ex) { _logger.LogError($"$$$SaveActivityAttend$$$####Error Message ->>>{ex} && {ex.Message}###### + StackTrace {ex.StackTrace}######## + InnerEx{ex.InnerException}#####"); return(0); } }
internal bool AddNewRoles(UserRolesModal userRolesModal) { return(_dbConnection.AddNewRoles(userRolesModal) > 0 ? true : false); }
internal bool UpdateRoles(UserRolesModal userRolesModal) { return(_dbConnection.UpdateRoles(userRolesModal) > 0 ? true : false); }