private void cmbFromAcc_SelectedIndexChanged(object sender, EventArgs e)
{
string GetFromAccID = "";
GetFromAccID = MyCommon.GetSelectedID(cmbFromAcc, true);
string Currentcy = "";
txtExRate.Text = MyAccount.GetExRate(GetFromAccID, out Currentcy).ToString();
lblCurrentcy.Text = Currentcy;
decimal FinalBalance = 0;
string rspt = MyAccount.GetFinalBalance(GetFromAccID, Program.AccountStatic.CurrentAccPeriod, out FinalBalance);
lblBalance.Text = FinalBalance.ToString("##0.00");
if (GetFromAccID == "10000")
{
ComboboxItem cmb = new ComboboxItem();
cmbPayMethod.Text = cmb.GetReleventTextFromID(cmbPayMethod, "1", true);
cmbPayMethod.Enabled = false;
}
else
cmbPayMethod.Enabled = true;
}
private void DisplayExtDetails(string PVN)
{
string respond = "";
respond = MyPay.GetExistPayment_General(PVN, out _ExtData);
ComboboxItem cmb = new ComboboxItem();
if (respond == "True")
{
//Added By manju
if (_ExtData.PayStatus == 3)
{
btnPrint.Enabled = true;
}
txtPVNno.Text = _ExtData.PaymentID;
cmbFromAcc.Text = cmb.GetReleventTextFromID(cmbFromAcc, _ExtData.AccountID, true);
cmbPayFor.Text = cmb.GetReleventTextFromID(cmbPayFor, _ExtData.PayToCatID.ToString(), true);
cmbPayMethod.Text = cmb.GetReleventTextFromID(cmbPayMethod, _ExtData.PaymentMethod.ToString(), true);
cmbPayTo.Text = _ExtData.PayToName;
cmbPayTo_SelectedIndexChanged(null, null);
txtfromMemo.Text = _ExtData.Description;
dtpPVNDate.Value = _ExtData.PayActualDate;
if (_ExtData.IsAdvancePayment == 1)
chkAsAdvancePayment.Checked = true;
else
chkAsAdvancePayment.Checked = false;
DataTable tb = MyPay.GetPAyDetailList(PVN);
MyCommon.LoadDatatoTableWithoutBind(dgvAccList, tb, "Load Payment list");
CalTotalLine();
}
tabControl1.SelectTab(0);
}
private void DisplayExtDetails(string RcptNumber)
{
string respond = "";
respond = MyReceipt.GetExistReceipt(RcptNumber, out _ExtData);
ComboboxItem cmb = new ComboboxItem();
if (respond == "True")
{
txtRcptNumber.Text = _ExtData.ReceiptID;
cmbFromAcc.Text = cmb.GetReleventTextFromID(cmbFromAcc, _ExtData.AccountID, true);
cmbPayFor.Text = cmb.GetReleventTextFromID(cmbPayFor, _ExtData.RcptFromCatID.ToString(), true);
cmbPayMethod.Text = cmb.GetReleventTextFromID(cmbPayMethod, _ExtData.ReceiptMethod.ToString(), true);
cmbPayTo.Text = _ExtData.RcptFromName;
cmbPayTo_SelectedIndexChanged(null, null);
txtfromMemo.Text = _ExtData.Description;
dtpPVNDate.Value = _ExtData.RcptActualDate;
DataTable tb = MyReceipt.GetReceiptDetailsList(RcptNumber);
MyCommon.LoadDatatoTableWithoutBind(dgvAccList, tb, "Load Payment list");
CalTotalLine();
}
tabControl1.SelectTab(0);
}
private void DisplayExistingData(string InvoiceNumber,int SupID)
{
string respond = MyBill.GetExistBilling(InvoiceNumber,SupID, out _ExtData);
ComboboxItem cmb=new ComboboxItem ();
if (respond == "True")
{
DataTable tb = MyBill.GetBillList(InvoiceNumber);
MyCommon.LoadDatatoTableWithoutBind(dgvAccount, tb, "load Details");
//cmbSupplier.Text = cmb.GetReleventTextFromID(cmbSupplier, _ExtData.PayToID.ToString(), true);
//Edited by manjula
cmbSupplier_SelectedIndexChanged(null, null);
//Added by Manju
StatusAll = 9;
LINKPayment objLink = new LINKPayment();
objLink.Status = 9;
objLink.SupName = cmbSupplier.SelectedValue.ToString();
LoadGRN(objLink);
cmbGRN.Text = _ExtData.BillNo;
cmbGRN_SelectedIndexChanged(null, null);
StatusAll = 0;
txtDescription.Text = _ExtData.Description;
dtpBilingDate.Value = _ExtData.BillDate;
lblExchangerate.Text = _ExtData.CurRate.ToString("#0.00");
CalTotalAmount();
tabControl1.SelectTab(0);
}
}
public void GetCustomerMaster()
{
try
{
Finance.MRPServiceReference.ServiceClient objService = new Finance.MRPServiceReference.ServiceClient();
List<EntityHandler.CustomerMaster> objList = new List<EntityHandler.CustomerMaster>();
EntityHandler.CustomerMaster [] objArry = objService.GetCustomerMaster();
objList = new BusinessHandler.CustomerMaster().BALGetCustomerMaster();
cmbSupplier.Items.Clear();
ComboboxItem itemDefault = new ComboboxItem();
itemDefault.Text = "--Select--";
itemDefault.Value = "0";
cmbSupplier.Items.Add(itemDefault);
for (int i = 0; i < objArry.Length; i++)
{
ComboboxItem item = new ComboboxItem();
item.Text = objArry[i].Name;
item.Value = objArry[i].Customer_Code;
cmbSupplier.Items.Add(item);
}
}
catch (Exception ex)
{
MessageBox.Show(ex.Message.ToString());
}
}
public void LoadToComboWithSelectedValue(ComboBox ObgCombo, string CmdStr,string ID,string Textvalue)
{
DataTable mytb = new DataTable();
mytb = GetDataTable(CmdStr, "Load Status Combo");
ObgCombo.Items.Clear();
if (mytb != null)
{
foreach (DataRow r in mytb.Rows)
{
ComboboxItem item = new ComboboxItem();
item.Text = r[Textvalue].ToString();
item.Value = r[ID].ToString();
ObgCombo.Items.Add(item);
}
}
}
public void LoadStatusComboAccount(ComboBox ObgCombo, string CmdStr)
{
DataTable mytb = new DataTable();
mytb = GetDataTableAccount(CmdStr, "Load Status Combo");
ObgCombo.Items.Clear();
if (mytb != null)
{
foreach (DataRow r in mytb.Rows)
{
ComboboxItem item = new ComboboxItem();
item.Text = r[1].ToString();
item.Value = r[0].ToString();
ObgCombo.Items.Add(item);
}
}
}
private void InitializeScreen()
{
ComboboxItem cmb = new ComboboxItem();
MyCommon.ClearCurrentPanel(ref panel7);
MyAccount.LoadAccountType (cmbAccountType);
MyAccount.LoadAccountType(cmbSearchAccType);
MyCommon.LoadStatusComboAccount(cmbAccStatus, 1);
MyAccount.LoadCurrency(cmbCurrenyType);
cmbCurrenyType.Text = cmb.GetReleventTextFromID(cmbCurrenyType,"LKR", true);
cmbAccStatus.Text = cmb.GetReleventTextFromID(cmbAccStatus, "1", true);
}
public void LoadCurrency(ComboBox ObgCombo)
{
string sql1 = "select CurID,CurID from tblcurrency";
DataTable mytb = new DataTable();
mytb = Mycommon.GetDataTableAccount(sql1, "Load Status Combo");
ObgCombo.Items.Clear();
if (mytb != null)
{
foreach (DataRow r in mytb.Rows)
{
ComboboxItem item = new ComboboxItem();
item.Text = r["CurID"].ToString();
item.Value = r["CurID"].ToString();
ObgCombo.Items.Add(item);
}
}
}
private void DisplayExtData(string AccNo)
{
AccountType.AccountCreationDataType _Savedata = new AccountType.AccountCreationDataType();
string respond = MyAccount.GetExistAccountCreation(AccNo, out _Savedata);
InitializeScreen();
ComboboxItem cmb = new ComboboxItem();
if (respond == "True")
{
txtAccID.Text = _Savedata.AccountID.ToString ();
txtAccountDescription.Text = _Savedata.AccountName;
cmbAccountType.Text = cmb.GetReleventTextFromID(cmbAccountType, _Savedata.MainAccType.ToString(), true);
if (_Savedata.IsSubAccount == 1)
{ chkIsSubaccount.CheckState = CheckState.Checked;
cmbMainAccount.Text = cmb.GetReleventTextFromID(cmbMainAccount, _Savedata.MainAccountID.ToString (), true);
}
else
chkIsSubaccount.CheckState = CheckState.Unchecked;
cmbCurrenyType.Text = cmb.GetReleventTextFromID(cmbCurrenyType, _Savedata.Currency , true);
cmbBankAccountNo.Text = _Savedata.BankAccountNo;
cmbAccStatus.Text = cmb.GetReleventTextFromID(cmbAccStatus, _Savedata.AccountStatus.ToString (), true);
}
}
private void cmbSearchAccType_SelectedIndexChanged(object sender, EventArgs e)
{
ComboboxItem cmb = new ComboboxItem();
string CatID = cmb.GetReleventTextFromID(cmbSearchAccType, cmbSearchAccType.Text, false);
DataTable tb = MyAccount.GetAccountListByCat(Program.AccountStatic.CompanyID, 1, int.Parse(CatID));
MyCommon.LoadDatatoTableWithoutBind(dgvAccountList, tb, "Load Account List");
}
private void cmbAccountType_SelectedIndexChanged(object sender, EventArgs e)
{
ComboboxItem cmb = new ComboboxItem();
if (cmb.GetReleventTextFromID(cmbAccountType, cmbAccountType.Text, false) == "1")
cmbBankAccountNo.Enabled = true;
else
cmbBankAccountNo.Enabled = false;
}
private string SetDataToCLass(out AccountType.AccountCreationDataType _Savedata)
{
ComboboxItem cmb=new ComboboxItem();
_Savedata = new AccountType.AccountCreationDataType();
_Savedata.AccountID = txtAccID.Text;
_Savedata.AccountName = txtAccountDescription.Text;
_Savedata.AccountStatus = int.Parse(cmb .GetReleventTextFromID(cmbAccStatus,cmbAccStatus.Text ,false));
_Savedata.BankAccountNo = cmbBankAccountNo.Text;
_Savedata.CreatedUser = Program.AccountStatic.UserName;
_Savedata.Currency = cmbCurrenyType.Text;
if (chkIsSubaccount.CheckState == CheckState.Checked)
{
_Savedata.IsSubAccount = 1;
_Savedata.MainAccountID = cmb.GetReleventTextFromID(cmbMainAccount, cmbMainAccount.Text, false );
}
else
{
_Savedata.IsSubAccount = 0;
_Savedata.MainAccountID = "0";
}
_Savedata.lastaccdate = DateTime.Today;
_Savedata.MainAccType = int.Parse(cmb.GetReleventTextFromID(cmbAccountType, cmbAccountType.Text, false));
_Savedata.CompanyID = Program.AccountStatic.CompanyID;
return "True";
}
private void cmbCurrency_SelectedIndexChanged(object sender, EventArgs e)
{
ComboboxItem cmb = new ComboboxItem();
lblExrate.Text = cmb.GetReleventTextFromID(cmbCurrency, cmbCurrency.Text, false);
}
private void dgvAccList_CellDoubleClick(object sender, DataGridViewCellEventArgs e)
{
ComboboxItem cmb = new ComboboxItem();
if (e.RowIndex != -1)
{
lblLRef.Text = dgvAccList.Rows[e.RowIndex].Cells["dgvAccList_Ref"].Value.ToString();
lblToID.Text = dgvAccList.Rows[e.RowIndex].Cells["dgvAccList_AccountID"].Value.ToString();
txtToAccount.Text = MyAccount.GetAccountName(lblToID.Text);
txtToMemo.Text = dgvAccList.Rows[e.RowIndex].Cells["dgvAccList_Memo"].Value.ToString();
txtJobNumber.Text = dgvAccList.Rows[e.RowIndex].Cells["dgvAccList_Job"].Value.ToString();
txtVat.Text = dgvAccList.Rows[e.RowIndex].Cells["dgvAccList_Vat"].Value.ToString();
txtAmount.Text = dgvAccList.Rows[e.RowIndex].Cells["dgvAccList_Fcur"].Value.ToString();
}
}
public void LoadAccountType(ComboBox ObgCombo)
{
string sql1 = "select SysID,AccountType from accounttype";
DataTable mytb = new DataTable();
mytb = Mycommon.GetDataTableAccount(sql1, "Load Status Combo");
ObgCombo.Items.Clear();
if (mytb != null)
{
foreach (DataRow r in mytb.Rows)
{
ComboboxItem item = new ComboboxItem();
item.Text = r["AccountType"].ToString();
item.Value = r["SysID"].ToString();
ObgCombo.Items.Add(item);
}
}
}
public string GetSelectedID(ComboBox cmb,bool GetValue)
{
ComboboxItem cmbItem = new ComboboxItem();
try
{
cmbItem = (ComboboxItem)cmb.SelectedItem;
if (GetValue)
return cmbItem.Value.ToString();
else
return cmbItem.Text;
}
catch (Exception ex)
{
return "";
}
}
public void LoadBankAccount(ComboBox ObgCombo)
{
string sql1 = "SELECT AccountNo,concat(AccountNo,' [', AccountType,'-', CurrenyType,']') as AcName "
+ " FROM tblbankaccount ";
DataTable mytb = new DataTable();
mytb = Mycommon.GetDataTableAccount(sql1, "Load Status Combo");
ObgCombo.Items.Clear();
if (mytb != null)
{
foreach (DataRow r in mytb.Rows)
{
ComboboxItem item = new ComboboxItem();
item.Text = r["AccountNo"].ToString();
item.Value = r["AcName"].ToString();
ObgCombo.Items.Add(item);
}
}
}
public void LoadStatusCombo(ComboBox ObgCombo, int Type)
{
string CmdStr = "Select ID,StatusName from tblcombostatus where Category=" + Type + " Order by ID asc";
DataTable mytb = new DataTable();
mytb = GetDataTable(CmdStr, "Load Status Combo");
ObgCombo.Items.Clear();
if (mytb != null)
{
foreach (DataRow r in mytb.Rows )
{
ComboboxItem item = new ComboboxItem();
item.Text = r["StatusName"].ToString();
item.Value = r["ID"].ToString();
ObgCombo.Items.Add(item);
}
}
}
public void LoadMainAccount(ComboBox ObgCombo,int CompanyID)
{
string sql1 = "SELECT AccountID , AccountName "
+ " FROM accountname where CompanyID=" + CompanyID + " order by AccountID asc";
DataTable mytb = new DataTable();
mytb = Mycommon.GetDataTableAccount(sql1, "Load Status Combo");
ObgCombo.Items.Clear();
if (mytb != null)
{
foreach (DataRow r in mytb.Rows)
{
ComboboxItem item = new ComboboxItem();
item.Text = r["AccountName"].ToString() +" [" + r["AccountID"].ToString() + "]" ;
item.Value = r["AccountID"].ToString();
ObgCombo.Items.Add(item);
}
}
}
public void LoadStatusComboWithExtraword(ComboBox ObgCombo, string CmdStr,string IDvalue,string Displaytext)
{
// string CmdStr = "Select ID,StatusName from tblcombostatus where Category=" + Type + " Order by ID asc";
DataTable mytb = new DataTable();
mytb = GetDataTable(CmdStr, "Load Status Combo");
ObgCombo.Items.Clear();
ComboboxItem item = new ComboboxItem();
item.Text = Displaytext;
item.Value = IDvalue;
ObgCombo.Items.Add(item);
if (mytb != null)
{
foreach (DataRow r in mytb.Rows)
{
item = new ComboboxItem();
item.Text = r[1].ToString();
item.Value = r[0].ToString();
ObgCombo.Items.Add(item);
}
}
}
public void GetAccountListByCat(int CompanyName,ComboBox cmb, int CatID)
{
string sql1 = "";
if (CatID != 0)
{
sql1 = "SELECT accountname.AccountID , accountname.AccountName "
+ " FROM accountname "
+ " where AccountStatus=1 and accountname.CompanyID=" + CompanyName + " and accountname.MainAccType=" + CatID + " Order By accountname.AccountID Asc";
}
else
{
sql1 = "SELECT accountname.AccountID , accountname.AccountName "
+ " FROM accountname "
+ " where AccountStatus=1 and accountname.CompanyID=" + CompanyName + " Order By accountname.AccountID Asc";
}
DataTable tb = Mycommon.GetDataTableAccount(sql1, "Get Account List");
cmb.Items.Clear();
if (tb != null)
{
foreach (DataRow r in tb.Rows)
{
ComboboxItem item = new ComboboxItem();
item.Text = r["AccountName"].ToString() +" [" + r["AccountID"].ToString() + "]" ;
item.Value = r["AccountID"].ToString();
cmb.Items.Add(item);
}
}
}
private void cmbCompanyName_SelectedIndexChanged(object sender, EventArgs e)
{
ComboboxItem cmb=new ComboboxItem ();
Program.AccountStatic.CompanyID = int.Parse(cmb.GetReleventTextFromID(cmbCompanyName, cmbCompanyName.Text, false));
txtUserName.Enabled = true;
txtPWD.Enabled = true;
}
private void DisplayData()
{
ComboboxItem cmb = new ComboboxItem();
cmbGRN.Text = _saveData.InvoiceNo;
cmbSupplier.Text = cmb.GetReleventTextFromID(cmbSupplier, _saveData.RcvFromID.ToString (), true);
dtpInvoiceDate.Value = _saveData.InvoiceDate;
// dtpBilingDate.Value = _saveData.
txtDescription.Text = _saveData.Description;
DataTable tb = MyInvoice.GetExistInvoiceDetails(cmbGRN.Text);
lblDueDate.Text = _saveData.TobeRcvDate.ToString("dd/MMM/yyyy");
MyCommon.LoadDatatoTableWithoutBind(dgvAccount, tb, "Load deails");
CalTotalAmount();
tabControl1.SelectTab(0);
}