public virtual CloudAccountDA.FrequencyMasterDataTable GetData()
{
this.Adapter.SelectCommand = this.CommandCollection[0];
CloudAccountDA.FrequencyMasterDataTable dataTable = new CloudAccountDA.FrequencyMasterDataTable();
this.Adapter.Fill(dataTable);
return(dataTable);
}
public virtual int Fill(CloudAccountDA.FrequencyMasterDataTable dataTable)
{
this.Adapter.SelectCommand = this.CommandCollection[0];
if (this.ClearBeforeFill)
{
dataTable.Clear();
}
return(this.Adapter.Fill(dataTable));
}
private void SetRecord(string iD)
{
this.objFrequencyMasterDT = this.objFrequencyMasterBll.GetDataByFrequencyID(int.Parse(iD));
if (this.objFrequencyMasterDT.Rows.Count <= 0)
{
return;
}
this.hfFrequency.Value = this.objFrequencyMasterDT.Rows[0]["FrequencyID"].ToString();
this.txtName.Text = this.objFrequencyMasterDT.Rows[0]["FrequencyName"].ToString();
this.txtNoOfDays.Text = this.objFrequencyMasterDT.Rows[0]["NoOfDays"].ToString();
this.txtDesc.Text = this.objFrequencyMasterDT.Rows[0]["FrequencyDesc"].ToString();
this.chkStatus.Checked = this.objFrequencyMasterDT.Rows[0]["FrequencyStatus"].ToString() == "True";
}
private void ViewRecord(string i)
{
this.objFrequencyMasterDT = this.objFrequencyMasterBll.GetDataByFrequencyID(int.Parse(i));
if (this.objFrequencyMasterDT.Rows.Count <= 0)
{
return;
}
this.hfFrequency.Value = this.objFrequencyMasterDT.Rows[0]["FrequencyID"].ToString();
this.lblName.Text = this.objFrequencyMasterDT.Rows[0]["FrequencyName"].ToString();
this.lblNoOfDays.Text = this.objFrequencyMasterDT.Rows[0]["NoOfDays"].ToString();
this.lblDesc.Text = this.objFrequencyMasterDT.Rows[0]["FrequencyDesc"].ToString();
this.lblStatus.Text = this.objFrequencyMasterDT.Rows[0]["FrequencyStatus"].ToString() == "True" ? "True" : "False";
}
public virtual CloudAccountDA.FrequencyMasterDataTable GetDataByFrequencyID(int?FrequencyID)
{
this.Adapter.SelectCommand = this.CommandCollection[1];
if (FrequencyID.HasValue)
{
this.Adapter.SelectCommand.Parameters[1].Value = FrequencyID.Value;
}
else
{
this.Adapter.SelectCommand.Parameters[1].Value = DBNull.Value;
}
CloudAccountDA.FrequencyMasterDataTable dataTable = new CloudAccountDA.FrequencyMasterDataTable();
this.Adapter.Fill(dataTable);
return(dataTable);
}
public virtual CloudAccountDA.FrequencyMasterDataTable GetDataByFrequencyName(string FrequencyName)
{
this.Adapter.SelectCommand = this.CommandCollection[2];
if (FrequencyName == null)
{
this.Adapter.SelectCommand.Parameters[1].Value = DBNull.Value;
}
else
{
this.Adapter.SelectCommand.Parameters[1].Value = FrequencyName;
}
CloudAccountDA.FrequencyMasterDataTable dataTable = new CloudAccountDA.FrequencyMasterDataTable();
this.Adapter.Fill(dataTable);
return(dataTable);
}
protected void btnSubmit_Click(object sender, EventArgs e)
{
if (!this.Page.IsValid)
{
return;
}
if (this.txtName.Text.Trim().Length > 0 && this.txtNoOfDays.Text.Trim().Length > 0)
{
this.objFrequencyMasterDT = this.objFrequencyMasterBll.GetDataByFrequencyName(this.txtName.Text);
if (this.objFrequencyMasterDT.Rows.Count > 0)
{
this.DisplayAlert("Frequency Already Exist..");
this.checkInDB = true;
}
else
{
this.checkInDB = false;
}
if (!this.checkInDB)
{
int num = this.objFrequencyMasterBll.AddFrequency(this.txtName.Text.Trim(), int.Parse(this.txtNoOfDays.Text.Trim()), this.txtDesc.Text.Trim(), this.chkStatus.Checked);
if (num != 0)
{
this.DisplayAlert("Details Added Successfully.");
this.Response.Redirect("~/BillTransact/FrequencyMaster.aspx?cmd=view&ID=" + (object)num);
}
else
{
this.DisplayAlert("Fail to Add New Details.");
this.Clear();
}
}
else
{
this.DisplayAlert("Fail to Add New Details.");
this.Clear();
}
}
else
{
this.DisplayAlert("Please Fill All Details...!");
}
}
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.FrequencyMasterDataTable dataTable)
{
return(this.Adapter.Update(dataTable));
}
