public static DO_Guest.UO_Guest GetObjectByBigDateCodeAndGuestCode(string bigDateCode, string guestCode) { DataAccess.ParameterCollection conditions = new DataAccess.ParameterCollection(); conditions.AddCondition(DataAccess.ParameterType.Initial, DataAccess.TokenTypes.Equal, DO_Guest.Columns.BigDateCode, bigDateCode); conditions.AddCondition(DataAccess.ParameterType.And, DataAccess.TokenTypes.Equal, DO_Guest.Columns.GuestCode, guestCode); DO_Guest.UOList_Guest l = new DO_Guest().GetList(conditions); return l.Count > 0 ? l[0] : null; }
public static DO_Schedule.UO_Schedule GetObjectByBigDateCodeAndScheduleCode(string bigDateCode, string scheduleCode) { DataAccess.ParameterCollection conditions = new DataAccess.ParameterCollection(); conditions.AddCondition(DataAccess.ParameterType.Initial, DataAccess.TokenTypes.Equal, DO_Schedule.Columns.BigDateCode, bigDateCode); conditions.AddCondition(DataAccess.ParameterType.And, DataAccess.TokenTypes.Equal, DO_Schedule.Columns.ScheduleCode, scheduleCode); DO_Schedule.UOList_Schedule l = new DO_Schedule().GetList(conditions); return l.Count > 0 ? l[0] : null; }
public static bool DeleteByBigDateCodeAndGuestCodes(string bigDateCode, string[] guestCodes, string updateBy) { DataAccess.ParameterCollection conditions = new DataAccess.ParameterCollection(); conditions.AddCondition(DataAccess.ParameterType.Initial, DataAccess.TokenTypes.Equal, DO_Guest.Columns.BigDateCode, bigDateCode); conditions.AddCondition(DataAccess.ParameterType.And, DataAccess.TokenTypes.In, DO_Guest.Columns.GuestCode, guestCodes); DataAccess.ParameterCollection values = new DataAccess.ParameterCollection(); values.AddValue(DO_Guest.Columns.IsDeleted, 1); values.AddValue(DO_Guest.Columns.UpdateBy, updateBy); values.AddValue(DO_Guest.Columns.UpdateOn, DataAccess.DateTimeValues.DbTime); return new DO_Guest().Update(values, conditions) > 0; }
public static WeddingLibrary.Database.DataObject.DO_BigDateJoin.UOList_BigDateJoin GetListByEmail(string email) { DataAccess.ParameterCollection conditions = new DataAccess.ParameterCollection(); conditions.AddCondition(DataAccess.ParameterType.Initial, DataAccess.TokenTypes.Equal, WeddingLibrary.Database.DataObject.DO_BigDateJoin.Columns.Email, email); return new WeddingLibrary.Database.DataObject.DO_BigDateJoin().GetList(conditions); }
public static int GetRecordCountByBigDateCode(string bigDateCode) { DataAccess.ParameterCollection conditions = new DataAccess.ParameterCollection(); conditions.AddCondition(DataAccess.ParameterType.Initial, DataAccess.TokenTypes.Equal, DO_Guest.Columns.BigDateCode, bigDateCode); return new DO_Guest().GetRecordsCount(conditions); }