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