public static List <ScheduledUsersBL> getData() { SummitDS.ScheduledUsersDataTable thisTable = getAdapter().GetData(); if (thisTable != null && thisTable.Rows.Count > 0) { return(BuildFromTable(thisTable)); } return(null); }
/// <summary> /// Get Data By User id , Shop Id and Frequency Id /// </summary> /// <param name="iUserId"></param> /// <param name="iShopId"></param> /// <param name="iFrequencyId"></param> /// <returns></returns> public static ScheduledUsersBL getDataByUserIdShopIdAndFrequencyId(Int32 iUserId, Int32 iShopId, Int32 iFrequencyId) { SummitDS.ScheduledUsersDataTable thisTable = getAdapter().GetDataByUserIdShopIdAndFrequencyId(iUserId, iShopId, iFrequencyId); if (thisTable != null && thisTable.Rows.Count > 0) { return(BuildFromRow(thisTable.Rows[0])); } return(null); }
public static ScheduledUsersBL getDataById(Int32 iScheduledUsersId) { SummitDS.ScheduledUsersDataTable thisTable = getAdapter().GetDataById(iScheduledUsersId); if (thisTable != null && thisTable.Rows.Count > 0) { return(BuildFromRow(thisTable.Rows[0])); } return(null); }
protected override void SaveToRow() { SummitDS.ScheduledUsersDataTable _thisTable = new SummitDS.ScheduledUsersDataTable(); if (_rowToSave == null) { _rowToSave = _thisTable.NewScheduledUsersRow(); } SummitDS.ScheduledUsersRow _dataRow = _rowToSave as SummitDS.ScheduledUsersRow; if (_dataRow != null) { if (IsExisting()) { if (iShopId.HasValue) { _dataRow.shop_id = iShopId.Value; } else { _dataRow.Setshop_idNull(); } //_dataRow.customer_id = this.m_iCustomerId; //_dataRow.vehiclestatus_id = this.m_iVehicleStatusId; if (m_dtSendDate.HasValue) { _dataRow.send_date = m_dtSendDate.Value; } else { _dataRow.Setsend_dateNull(); } if (iFrequency.HasValue) { _dataRow.frequency_id = iFrequency.Value; } else { _dataRow.Setfrequency_idNull(); } if (bIsMailSent.HasValue) { _dataRow.isMailSent = bIsMailSent.Value; } else { _dataRow.SetisMailSentNull(); } if (bIsSmsSent.HasValue) { _dataRow.isSmsSent = bIsSmsSent.Value; } else { _dataRow.SetisSmsSentNull(); } if (iUserId.HasValue) { _dataRow.user_id = iUserId.Value; } else { _dataRow.Setuser_idNull(); } } else { if (iShopId.HasValue) { _dataRow.shop_id = iShopId.Value; } else { _dataRow.Setshop_idNull(); } //_dataRow.customer_id = this.m_iCustomerId; //_dataRow.vehiclestatus_id = this.m_iVehicleStatusId; if (m_dtSendDate.HasValue) { _dataRow.send_date = m_dtSendDate.Value; } else { _dataRow.Setsend_dateNull(); } if (bIsMailSent.HasValue) { _dataRow.isMailSent = bIsMailSent.Value; } else { _dataRow.SetisMailSentNull(); } if (bIsSmsSent.HasValue) { _dataRow.isSmsSent = bIsSmsSent.Value; } else { _dataRow.SetisSmsSentNull(); } if (iFrequency.HasValue) { _dataRow.frequency_id = iFrequency.Value; } else { _dataRow.Setfrequency_idNull(); } if (iUserId.HasValue) { _dataRow.user_id = iUserId.Value; } else { _dataRow.Setuser_idNull(); } _thisTable.AddScheduledUsersRow(_dataRow); } } }