public UserPaswordHistoryBO GetCurrentPaswordDetails(DBEgine dbEngine,int userID) { UserPaswordHistoryBO hs = null; try { SqlParameter[] parms = new SqlParameter[1]; SqlParameter p1 = new SqlParameter(); p1.ParameterName = "@UserID"; p1.SqlDbType = SqlDbType.Int; p1.Direction = ParameterDirection.Input; p1.Value = userID; parms[0] = p1; DataTable dtHistry = dbEngine.ExecuteDataTable("UserManagement.UM_GetCurrentPasswordDetails", parms); if (dtHistry.Rows.Count > 0) { foreach (DataRow r in dtHistry.Rows) { hs = new UserPaswordHistoryBO(); if (r.Table.Columns.Contains("UserPaswordHistoryID")) if (r["UserPaswordHistoryID"] != DBNull.Value) hs.UserPaswordHistoryID = (int)r["UserPaswordHistoryID"]; if (r.Table.Columns.Contains("UserID")) if (r["UserID"] != DBNull.Value) hs.UserID = (int)r["UserID"]; if (r.Table.Columns.Contains("Password")) if (r["Password"] != DBNull.Value) hs.Password = r["Password"].ToString(); if (r.Table.Columns.Contains("CreatedBy")) if (r["CreatedBy"] != DBNull.Value) hs.CreatedBy = (int)r["CreatedBy"]; if (r.Table.Columns.Contains("CreatedDate")) if (r["CreatedDate"] != DBNull.Value) hs.CreatedDate = DateTime.Parse(r["CreatedDate"].ToString()); if (r.Table.Columns.Contains("DayProcessID")) if (r["DayProcessID"] != DBNull.Value) hs.DayProcessID = r["DayProcessID"].ToString(); if (r.Table.Columns.Contains("IsCurrent")) if (r["IsCurrent"] != DBNull.Value) hs.IsCurrent = (bool)r["IsCurrent"]; } } return hs; } catch { throw; } }
public static List<RelationshipBO> GetAllRelationship() { List<RelationshipBO> listRel = new List<RelationshipBO>(); DBEgine dbEgine = new DBEgine(); try { dbEgine.DBOpen(); DataTable dt = dbEgine.ExecuteDataTable("U_GetAllRelationship", null); if (dt.Rows.Count > 0) { foreach (DataRow r in dt.Rows) { var relationshipBO = new RelationshipBO(); if (r["RelationShipID"] != DBNull.Value) relationshipBO.RelationShipID = (int)r["RelationShipID"]; if (r["RelationShipName"] != DBNull.Value) relationshipBO.RelationShipName = r["RelationShipName"].ToString(); if (r["IsActive"] != DBNull.Value) relationshipBO.IsActive = (bool)r["IsActive"]; if (r["CreatedBy"] != DBNull.Value) relationshipBO.CreatedBy = (int)r["CreatedBy"]; if (r["CreatedDate"] != DBNull.Value) relationshipBO.CreatedDate = (DateTime)r["CreatedDate"]; if (r["ModifiedBy"] != DBNull.Value) relationshipBO.ModifiedBy = (int)r["ModifiedBy"]; if (r["ModifiedDate"] != DBNull.Value) relationshipBO.ModifiedDate = (DateTime)r["ModifiedDate"]; listRel.Add(relationshipBO); } } } catch { throw; } finally { dbEgine.DBClose(); } return listRel; }
public bool IsUserSessionComplete(int userID) { DBEgine dbEngine = new DBEgine(); bool isCompleted = true; try { dbEngine.DBOpen(); SqlParameter[] parms = new SqlParameter[1]; SqlParameter p1 = new SqlParameter(); p1.ParameterName = "UserID"; p1.SqlDbType = SqlDbType.Int; p1.Value = userID; parms[0] = p1; DataTable dtStatus = dbEngine.ExecuteDataTable("UM_IsSessionCompletedByUser", parms); if (dtStatus.Rows.Count > 0) isCompleted = (bool)dtStatus.Rows[0]["IsLogout"]; } catch { throw; } finally { dbEngine.DBClose(); } return isCompleted; }
public bool IsPassWordAlreadyTaken(int userId, string userPassword) { bool exist = false; DBEgine dbEgine = new DBEgine(); try { dbEgine.DBOpen(); SqlParameter[] parms = new SqlParameter[2]; SqlParameter p1 = new SqlParameter(); p1.ParameterName = "@UserId"; p1.SqlDbType = SqlDbType.Int; p1.Direction = ParameterDirection.Input; p1.Value = userId; parms[0] = p1; SqlParameter p2 = new SqlParameter(); p2.ParameterName = "@Password"; p2.SqlDbType = SqlDbType.NVarChar; p2.Size = 500; p2.Direction = ParameterDirection.Input; p2.Value = userPassword; parms[1] = p2; DataTable dt=dbEgine.ExecuteDataTable("UM_IsPassWordAlreadyTaken", parms); if (dt.Rows.Count>0) { exist = true; } dbEgine.DBClose(); } catch { throw; } finally { dbEgine.DBClose(); } return exist; }