public AccountTranaction(bool IsLocal)
{
Mycommon = new DataService(IsLocal);
MyGeneral = new CommonOperations(IsLocal);
IsLocalLoging = IsLocal;
}
private void SetCompanyProfile()
{
CommonOperations.ThreeSConfiguration _Exdata = new CommonOperations.ThreeSConfiguration();
CommonOperations myco = new CommonOperations(Program.AccountStatic.LoggingAsLocal);
_Exdata = myco.GetCompanyConfig();
Program.AccountStatic.CurrentAccPeriod = _Exdata.CurrentAccPeriod;
Program.AccountStatic.CompanyID = _Exdata.CompanyID;
}
public frmJobList()
{
InitializeComponent();
MyCommon = new CommonOperations(Program.AccountStatic.LoggingAsLocal);
MyPay = new Payment(Program.AccountStatic.LoggingAsLocal);
DataTable tb = MyPay.GetProjectList();
MyCommon.LoadDatatoTableWithoutBind(dgvProject, tb, "Load JOBS");
}
private void frmReceiptVoucher_Load(object sender, EventArgs e)
{
panel1.Top = (this.Height - panel1.Height) / 2;
panel1.Left = (this.Width - panel1.Width) / 2;
MyAccount = new AccountCreation(Program.AccountStatic.LoggingAsLocal);
MyCommon = new CommonOperations(Program.AccountStatic.LoggingAsLocal);
MyReceipt = new Receipt(Program.AccountStatic.LoggingAsLocal);
LoadToCombo();
}
private void frmCompanyConfig_Load(object sender, EventArgs e)
{
MyCom = new CommonOperations(Program.AccountStatic.LoggingAsLocal);
Myaccount=new AccountCreation (Program.AccountStatic.LoggingAsLocal);
panel1.Top = (this.Height - panel1.Height) / 2;
panel1.Left = (this.Width - panel1.Width) / 2;
Myaccount.LoadSupplier (dgvList);
DataTable tb=MyCom .GetDataTableAccount ("Select CurID from tblcurrency","xx");
MyCom.LoadDatatoComboWithOutBind(txtCurrency, tb, "CurID", true);
}
private void LoadData()
{
MyCommon = new CommonOperations(Program.AccountStatic.LoggingAsLocal);
DataTable dt2 = new DataTable();
dt2=MyCommon.GetDataTableAccount("select * from acknoladgement","Get Ack");
if (dt2.Rows.Count > 0)
{
dataGridView1.DataSource = null;
dataGridView1.DataSource = dt2;
}
}
private void frmInvoice_Load(object sender, EventArgs e)
{
MyCommon = new CommonOperations(Program.AccountStatic.LoggingAsLocal);
// MyAccount = new AccountCreation(Program.AccountStatic.LoggingAsLocal);
// MyInvoice = new Invoice(Program.AccountStatic.LoggingAsLocal);
panel1.Top = (this.Height - panel1.Height) / 2;
panel1.Left = (this.Width - panel1.Width) / 2;
//MyAccount.LoadCustomer(cmbSupplier);
//MyCommon.LoadStatusComboAccount(cmbStatus, 4);
//LoadList();
}
private void frmAccountCreation_Load(object sender, EventArgs e)
{
MyCommon = new CommonOperations(Program.AccountStatic.LoggingAsLocal);
MyAccount = new AccountCreation(Program.AccountStatic.LoggingAsLocal);
panel1.Top = (this.Height - panel1.Height) / 2;
panel1.Left = (this.Width - panel1.Width) / 2;
InitializeScreen();
panel7.Enabled = false;
panel8.Enabled = false;
LoadExistingAccount();
LoadExtAccountInHiaraky();
}
private void frmBill_Load(object sender, EventArgs e)
{
MyBill = new Billing(Program.AccountStatic.LoggingAsLocal);
MyCommon = new CommonOperations(Program.AccountStatic.LoggingAsLocal);
MyAccount = new AccountCreation(Program.AccountStatic.LoggingAsLocal);
panel1.Top = (this.Height - panel1.Height) / 2;
panel1.Left = (this.Width - panel1.Width) / 2;
//MyAccount.LoadSupplier(cmbSupplier);
//MyAccount.LoadSupplier(cmbSearchSupplier);
//Edit by manjula *** Load suppliers from MRP
LoadSuppliers();
MyCommon.LoadStatusComboAccount(cmbStatus, 4);
EditScreen(false);
}
private void frmJournal_Load(object sender, EventArgs e)
{
MyAccount = new AccountCreation(Program.AccountStatic.LoggingAsLocal);
MyCommon = new CommonOperations(Program.AccountStatic.LoggingAsLocal);
MyJournal = new Journal(Program.AccountStatic.LoggingAsLocal);
IsLocalLoging = Program.AccountStatic.LoggingAsLocal;
panel1.Top = (this.Height - panel1.Height) / 2;
panel1.Left = (this.Width - panel1.Width) / 2;
MyCommon.LoadCurrency(cmbCurrency);
MyCommon.LoadStatusComboAccount(cmbPayFor, 6);
string HmCur = "", HmRate = "";
string respond = MyCommon.GetHomeCurrencyAndExrate(out HmCur, out HmRate);
cmbCurrency.Text = HmCur;
MyCommon.LoadStatusComboAccount(cmbStatus, 4);
}
private void frmPaymentVoucher_Load(object sender, EventArgs e)
{
try
{
MyAccount = new AccountCreation(Program.AccountStatic.LoggingAsLocal);
MyCommon = new CommonOperations(Program.AccountStatic.LoggingAsLocal);
MyPay = new Payment(Program.AccountStatic.LoggingAsLocal);
panel4.Top = (this.Height - panel4.Height) / 2;
panel4.Left = (this.Width - panel4.Width) / 2;
LoadToCombo();
EnableCurrent(false);
}
catch (Exception ex)
{
MessageBox.Show(ex.Message);
}
}
private void frmPrintZone_Load(object sender, EventArgs e)
{
string ApproveDate = "";
string AccNo = "";
string TotValue = "";
string Payee = "";
string ChequeNo = "";
string PrepaiedDate = "";
string AmountInWords = "";
string PrintCount = "0";
MyCommon = new CommonOperations(Program.AccountStatic.LoggingAsLocal);
DataTable dtSingle = new DataTable();
dtSingle = MyCommon.GetDataTableAccount("select PaymentID,FCr,AccountID,PayToName,ChequeNumber,Approvedate,AccountDate from accounterp.tblpayment where PaymentID='" + Voucherid + "'", "GetBill Data");
if (dtSingle.Rows.Count > 0)
{
TotValue =dtSingle.Rows[0][1].ToString();
AccNo = dtSingle.Rows[0][2].ToString();
Payee = dtSingle.Rows[0][3].ToString();
ChequeNo = dtSingle.Rows[0][4].ToString();
ApproveDate = dtSingle.Rows[0][5].ToString();
PrepaiedDate = dtSingle.Rows[0][6].ToString();
AmountInWords = objChangeNumber.changeToWords(TotValue);
}
// Set the processing mode for the ReportViewer to Local
reportViewer1.ProcessingMode = ProcessingMode.Local;
LocalReport localReport = reportViewer1.LocalReport;
localReport.ReportPath = "PrintPaymentVoucher.rdlc";
ReportParameter[] reportParameterCollection = new ReportParameter[9];
reportParameterCollection[0] = new ReportParameter();
reportParameterCollection[0].Name = "VoucherID";
reportParameterCollection[0].Values.Add(Voucherid);
reportParameterCollection[1] = new ReportParameter();
reportParameterCollection[1].Name = "Amount";
reportParameterCollection[1].Values.Add(TotValue);
reportParameterCollection[2] = new ReportParameter();
reportParameterCollection[2].Name = "Approvedate";
reportParameterCollection[2].Values.Add(ApproveDate);
reportParameterCollection[3] = new ReportParameter();
reportParameterCollection[3].Name = "Payee";
reportParameterCollection[3].Values.Add(Payee);
reportParameterCollection[4] = new ReportParameter();
reportParameterCollection[4].Name = "AccNo";
reportParameterCollection[4].Values.Add(AccNo);
reportParameterCollection[5] = new ReportParameter();
reportParameterCollection[5].Name = "ChequeNo";
reportParameterCollection[5].Values.Add(ChequeNo);
reportParameterCollection[6] = new ReportParameter();
reportParameterCollection[6].Name = "PrepaiedDate";
reportParameterCollection[6].Values.Add(PrepaiedDate);
reportParameterCollection[7] = new ReportParameter();
reportParameterCollection[7].Name = "AmountInWords";
reportParameterCollection[7].Values.Add(AmountInWords);
reportParameterCollection[8] = new ReportParameter();
reportParameterCollection[8].Name = "No";
reportParameterCollection[8].Values.Add(PrintCount);
//Load DataSet
DataTable dt = new DataTable();
string str = "select pb.pono as pono,pb.billno as billno,pb.billno as grnno,pd.Fdr as amount from tblpayablebill as pb " +
"inner join tblpaymetdetails as pd on pb.BIllno=pd.JobNo where pd.PvnNo='" + Voucherid + "'";
dt = MyCommon.GetDataTableAccount(str,"GetBill Data");
if (dt.Rows.Count > 0)
{
ReportDataSource rds = new ReportDataSource("DataSetPaymentVoucher", dt);
try
{
reportViewer1.LocalReport.SetParameters(reportParameterCollection);
reportViewer1.LocalReport.DataSources.Add(rds);
}
catch (Exception ex)
{
}
}
// Refresh the report
reportViewer1.RefreshReport();
}
private void rbtLocal_CheckedChanged(object sender, EventArgs e)
{
try
{
WrireConf("local");
Program.AccountStatic.LoggingAsLocal = true;
MyUser = new UserHandling(Program.AccountStatic.LoggingAsLocal);
MyGeneral = new CommonOperations(Program.AccountStatic.LoggingAsLocal);
MyGeneral.LoadCompany(cmbCompanyName);
}
catch (Exception ex)
{
}
}
public BankCheques(bool IsLocal)
{
Mycommon = new CommonOperations(IsLocal);
}
public AccountCreation(bool IsLocal)
{
Mycommon = new DataService(IsLocal);
MyGeneral = new CommonOperations(IsLocal);
}
public Receipt(bool IsLocal) //Constructor
{
Mycommon = new CommonOperations(IsLocal);
}
public Invoice(bool IsLocal)
{
Mycommon = new CommonOperations(IsLocal);
}
// private DataService MyDataService = new DataService();
public UserHandling(bool IsLocalConnection)
{
IsLoacal = IsLocalConnection;
MYCommon = new CommonOperations(IsLoacal);
}
public Email(bool Islocal)
{
Mycommon = new CommonOperations(Islocal);
}
public Billing(bool IsLocal)
{
Mycommon = new DataService(IsLocal);
MyGeneral = new CommonOperations(IsLocal);
}
private void frmLedgers_Load(object sender, EventArgs e)
{
MyCommon = new CommonOperations(Program.AccountStatic.LoggingAsLocal);
MyAccount = new AccountCreation(Program.AccountStatic.LoggingAsLocal);
MyCommon.LoadStatusComboAccount(cmbRptType, 5);
}
