public bool Update(Spotlight spotlight, Database db, DbTransaction transaction) { DbCommand command = db.GetStoredProcCommand("usp_SpotlightUpdate"); db.AddInParameter(command, "UserId", DbType.Guid, spotlight.UserId); db.AddInParameter(command, "Awards", DbType.String, spotlight.Awards); db.AddInParameter(command, "Achievements", DbType.String, spotlight.Achievements); db.AddInParameter(command, "CurentGPA", DbType.String, spotlight.CurentGPA); db.AddInParameter(command, "OraganizationId", DbType.Int16, spotlight.OraganizationId); db.AddInParameter(command, "Involvments", DbType.String, spotlight.Involvments); db.AddInParameter(command, "FraternityId", DbType.Int16, spotlight.FraternityId); db.AddInParameter(command, "SoroityId", DbType.Int16, spotlight.SoroityId); db.AddInParameter(command, "GreekHonorSocitiesId", DbType.Int16, spotlight.GreekHonorSocitiesId); db.AddInParameter(command, "GreakOrganizationId", DbType.Int16, spotlight.GreakOrganizationId); db.AddInParameter(command, "IsDeleted", DbType.Boolean, spotlight.IsDeleted); db.AddInParameter(command, "UpdatedBy", DbType.Guid, spotlight.UpdatedBy); db.AddOutParameter(command, "UpdatedDate", DbType.DateTime, 30); db.ExecuteNonQuery(command, transaction); spotlight.CreatedDate = Convert.ToDateTime(db.GetParameterValue(command, "UpdatedDate").ToString()); spotlight.UpdatedDate = spotlight.CreatedDate; return true; }
public bool Delete(Spotlight spotlight, Database db, DbTransaction transaction) { DbCommand command = db.GetStoredProcCommand("usp_SpotlightDelete"); db.AddInParameter(command, "SpotlightId", DbType.Guid, spotlight.SpotlightId); db.AddInParameter(command, "UpdatedBy", DbType.Guid, spotlight.UpdatedBy); db.ExecuteNonQuery(command, transaction); return true; }
/// <summary> /// Checks if user record with UserId exist in User table of the database. /// </summary> /// <param name="user"></param> /// <returns></returns> public bool IsSpotlightExist(Spotlight spotlight) { Database db = DatabaseFactory.CreateDatabase(Constants.CONNECTIONSTRING); DbCommand command = db.GetStoredProcCommand("usp_Spotlight_IsSpotlightExist"); db.AddInParameter(command, "UserId", DbType.Guid, spotlight.UserId); db.AddOutParameter(command, "IsExist", DbType.Boolean, 1); db.ExecuteNonQuery(command); return Convert.ToBoolean(db.GetParameterValue(command, "IsExist").ToString()); }
public void loaddata() { // school data spotlight = Spotlight.Select(Guid.Parse(Membership.GetUser().ProviderUserKey.ToString())); if (spotlight != null) { Awards.Text = string.IsNullOrEmpty(spotlight.Awards) ? string.Empty : spotlight.Awards; Achievements.Text = string.IsNullOrEmpty(spotlight.Achievements) ? string.Empty : spotlight.Achievements; CurentGPA.Text = string.IsNullOrEmpty(spotlight.CurentGPA) ? string.Empty : spotlight.CurentGPA; Involvments.Text = string.IsNullOrEmpty(spotlight.Involvments) ? string.Empty : spotlight.Involvments; if (spotlight.OraganizationId.HasValue) { for (int i = 0; i < DrpOraganizations.Items.Count; i++) { if (DrpOraganizations.Items[i].Value.ToString().ToLower() == spotlight.OraganizationId.ToString().ToLower()) { DrpOraganizations.ClearSelection(); DrpOraganizations.Items[i].Selected = true; } } } if (spotlight.FraternityId.HasValue) { for (int i = 0; i < DrpFraternity.Items.Count; i++) { if (DrpFraternity.Items[i].Value.ToString().ToLower() == spotlight.OraganizationId.ToString().ToLower()) { DrpFraternity.ClearSelection(); DrpFraternity.Items[i].Selected = true; } } } if (spotlight.SoroityId.HasValue) { for (int i = 0; i < DrpSoroity.Items.Count; i++) { if (DrpSoroity.Items[i].Value.ToString().ToLower() == spotlight.SoroityId.ToString().ToLower()) { DrpSoroity.ClearSelection(); DrpSoroity.Items[i].Selected = true; } } } if (spotlight.GreakOrganizationId.HasValue) { for (int i = 0; i < DrpGreekOrganizations.Items.Count; i++) { if (DrpGreekOrganizations.Items[i].Value.ToString().ToLower() == spotlight.GreakOrganizationId.ToString().ToLower()) { DrpGreekOrganizations.ClearSelection(); DrpGreekOrganizations.Items[i].Selected = true; } } } if (spotlight.GreekHonorSocitiesId.HasValue) { for (int i = 0; i < DrpGreekHonorSocities.Items.Count; i++) { if (DrpGreekHonorSocities.Items[i].Value.ToString().ToLower() == spotlight.GreekHonorSocitiesId.ToString().ToLower()) { DrpGreekHonorSocities.ClearSelection(); DrpGreekHonorSocities.Items[i].Selected = true; } } } } }
public static Spotlight Select(Guid Userid) { Spotlight spotlight = Generic.GetByFieldValue <Spotlight>("Userid", Userid.ToString()); return(spotlight); }