public void DeleteBySubstituteId() { Miami.Substitute.Dal.Substitute substitute = new Miami.Substitute.Dal.Substitute(); substitute.LoadByUserId(Micajah.Common.Security.UserContext.Current.UserId); DalSubstitute.Query.ClearAll(); DalSubstitute.Where.SubstituteId.Operator = WhereParameter.Operand.Equal; DalSubstitute.Where.SubstituteId.Value = substitute.SubstituteId; if (DalSubstitute.Query.Load()) { DalSubstitute.DeleteAll(); DalSubstitute.Save(); } }
public int GetSubstituteIdByUserId(int userId) { if (userId > 0) { Miami.Substitute.Dal.Substitute substitute = new Miami.Substitute.Dal.Substitute(); substitute.Query.ClearAll(); substitute.Where.UserId.Operator = WhereParameter.Operand.Equal; substitute.Where.UserId.Value = userId; if (substitute.Query.Load()) { return(substitute.SubstituteId); } } return(0); }
public int GetSubstituteIdByUserId(int userId) { if (userId>0) { Miami.Substitute.Dal.Substitute substitute = new Miami.Substitute.Dal.Substitute(); substitute.Query.ClearAll(); substitute.Where.UserId.Operator = WhereParameter.Operand.Equal; substitute.Where.UserId.Value = userId; if (substitute.Query.Load()) return (substitute.SubstituteId); } return 0; }