public virtual CloudAccountDA.RecurringItemDetailDataTable GetData()
{
this.Adapter.SelectCommand = this.CommandCollection[0];
CloudAccountDA.RecurringItemDetailDataTable dataTable = new CloudAccountDA.RecurringItemDetailDataTable();
this.Adapter.Fill(dataTable);
return(dataTable);
}
public virtual int Fill(CloudAccountDA.RecurringItemDetailDataTable dataTable)
{
this.Adapter.SelectCommand = this.CommandCollection[0];
if (this.ClearBeforeFill)
{
dataTable.Clear();
}
return(this.Adapter.Fill(dataTable));
}
public virtual CloudAccountDA.RecurringItemDetailDataTable DeleteByRecurringID(int?RecurringID)
{
this.Adapter.SelectCommand = this.CommandCollection[2];
if (RecurringID.HasValue)
{
this.Adapter.SelectCommand.Parameters[1].Value = RecurringID.Value;
}
else
{
this.Adapter.SelectCommand.Parameters[1].Value = DBNull.Value;
}
CloudAccountDA.RecurringItemDetailDataTable dataTable = new CloudAccountDA.RecurringItemDetailDataTable();
this.Adapter.Fill(dataTable);
return(dataTable);
}
private void CallAllRecurringInvoice()
{
this.objRecurringMasterDT = this.objRecurringMasterBll.GetAllActiveTodayRecurring();
if (this.objRecurringMasterDT.Rows.Count <= 0)
{
return;
}
for (int index = 0; index < this.objRecurringMasterDT.Rows.Count; ++index)
{
int iRecurringID = int.Parse(this.objRecurringMasterDT.Rows[index]["RecurringID"].ToString());
int num1 = int.Parse(this.objRecurringMasterDT.Rows[index]["CompanyID"].ToString());
int num2 = int.Parse(this.objRecurringMasterDT.Rows[index]["ClientID"].ToString());
int iFrequencyID = int.Parse(this.objRecurringMasterDT.Rows[index]["HowOften"].ToString());
DateTime dtNextDate = DateTime.Parse(this.objRecurringMasterDT.Rows[index]["NextDate"].ToString());
string str1 = this.objRecurringMasterDT.Rows[index]["RemainingInvoice"].ToString();
bool bRecurringActive = true;
string s;
try
{
s = int.Parse(str1.Trim()).ToString();
}
catch (Exception ex)
{
s = "-1";
}
this.objFrequencyMasterDT = this.objFrequencyMasterBll.GetDataByFrequencyID(iFrequencyID);
if (this.objFrequencyMasterDT.Rows.Count > 0)
{
int num3 = int.Parse(this.objFrequencyMasterDT.Rows[0]["NoOfDays"].ToString());
dtNextDate = dtNextDate.AddDays((double)num3);
}
string sRemainingInvoice;
switch (s)
{
case "-1":
sRemainingInvoice = "infinite";
break;
default:
sRemainingInvoice = (int.Parse(s) - 1).ToString();
if (sRemainingInvoice == "0")
{
bRecurringActive = false;
break;
}
break;
}
this.objRecurringMasterBll.UpdateForSentInvoice(iRecurringID, sRemainingInvoice, dtNextDate, bRecurringActive);
this.objInvoiceMasterDT = this.objInvoiceMasterBll.GetDataByCompanyID(num1);
string str2 = this.objInvoiceMasterDT.Rows.Count <= 0 ? ConfigurationManager.AppSettings["InvoiceNoStart"] : InvoiceMaster.NextNum(this.objInvoiceMasterDT.Rows[this.objInvoiceMasterDT.Rows.Count - 1]["InvoiceNumber"].ToString());
int num4 = this.objInvoiceMasterBll.AddInvoice(str2, iRecurringID);
this.objRecurringItemDetailDT = this.objRecurringItemDetailBll.GetDataByRecurringID(iRecurringID);
if (this.objRecurringItemDetailDT.Rows.Count > 0)
{
this.objInvoiceItemDetailBll.AddInvoiceItem(num4, iRecurringID);
}
this.objRecurringTaskDetailDT = this.objRecurringTaskDetailBll.GetDataByRecurringID(iRecurringID);
if (this.objRecurringTaskDetailDT.Rows.Count > 0)
{
this.objInvoiceTaskDetailBll.AddInvoiceTask(num4, iRecurringID);
}
this.objCompanyClientMasterDT = this.objCompanyClientMasterBll.GetDataByCompanyClientID(num2);
if (this.objCompanyClientMasterDT.Rows.Count > 0)
{
this.SendMail(this.objCompanyClientMasterDT.Rows[0]["Email"].ToString(), str2, num4, num2, num1);
}
}
}
public virtual int Update(CloudAccountDA.RecurringItemDetailDataTable dataTable)
{
return(this.Adapter.Update(dataTable));
}
