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