public int UnlockUser(UserUnlockBO obj) { DBEgine dbEgine = new DBEgine(); try { dbEgine.DBOpen(); SqlParameter[] parms = new SqlParameter[5]; SqlParameter p1 = new SqlParameter(); p1.ParameterName = "@UserId"; p1.SqlDbType = SqlDbType.Int; p1.Direction = ParameterDirection.Input; p1.Value = obj.User.UserId; parms[0] = p1; SqlParameter p2 = new SqlParameter(); p2.ParameterName = "@IsLock"; p2.SqlDbType = SqlDbType.Int; p2.Direction = ParameterDirection.Input; p2.Value = obj.IsLock; parms[1] = p2; SqlParameter p3 = new SqlParameter(); p3.ParameterName = "@UnLockRemark"; p3.SqlDbType = SqlDbType.VarChar; p3.Direction = ParameterDirection.Input; p3.Value = obj.UnlockRemark; parms[2] = p3; SqlParameter p4 = new SqlParameter(); p4.ParameterName = "@CreatedBy"; p4.SqlDbType = SqlDbType.Int; p4.Direction = ParameterDirection.Input; p4.Value = obj.CreatedBy; parms[3] = p4; SqlParameter p5 = new SqlParameter(); p5.ParameterName = "@ReturnStatus"; p5.SqlDbType = SqlDbType.Int; p5.Direction = ParameterDirection.Output; p5.Value = 0; parms[4] = p5; dbEgine.ExecNonQueryStoredProc("UM_UnlockUser", parms); return int.Parse(p5.Value.ToString()); } catch { throw; } finally { dbEgine.DBClose(); } }
private List<UserUnlockBO> FillUserUnlockInformation(SqlDataReader dr) { List<UserUnlockBO> userUnLockList = new List<UserUnlockBO>(); UserUnlockBO userUnLock; try { while (dr.Read()) { userUnLock = new UserUnlockBO(); userUnLock.CreatedBy = dr.GetInt32(dr.GetOrdinal("CreatedBy")); userUnLock.CreatedDate = dr.GetDateTime(dr.GetOrdinal("CreatedDate")); userUnLock.UnlockRemark = dr.GetValue(dr.GetOrdinal("UnlockRemark")).ToString(); userUnLock.UserUnlockHistoryId = dr.GetInt32(dr.GetOrdinal("UserUnlockHistoryId")); int userId = dr.GetInt32(dr.GetOrdinal("UserId")); userUnLock.User = new UserBO(); userUnLock.User.UserId = userId; //userUnLock.User.LoadUserByUserId(); userUnLock.User = new UserDAL().LoadUserByUserId(userUnLock.User); userUnLockList.Add(userUnLock); } } catch { throw; } return userUnLockList; }