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);
}
