private void DisplayData() { string vWhere = string.Empty; if (!string.IsNullOrEmpty(txtFilter.Text)) { vWhere = " AND ChartOfAccounts.AccountName Like '%" + txtFilter.Text + "%'"; } if (int.Parse(CmbFilter.SelectedValue.ToString()) > 0) { vWhere += " AND ChartOfAccounts.AccountType=" + CmbFilter.SelectedValue; } try { DAL.ChartOfAccounts objDAL = new DAL.ChartOfAccounts(); objDAL.connectionstring = vConnectionString; dt = objDAL.getRecord(vWhere); Grid.AutoGenerateColumns = false; Grid.DataSource = dt; } catch (Exception exc) { MessageBox.Show(exc.Message.ToString()); } }
private void PopulateCombos() { try { DataTable dt = new DataTable(); DAL.ChartOfAccounts obj = new DAL.ChartOfAccounts(); obj.connectionstring = vConnectionString; dt = obj.getRecord(string.Empty); DataRow dr = dt.NewRow(); dr["AccountNo"] = "0"; dr["AccountName"] = "ALL"; dr["AccountType"] = ""; dt.Rows.Add(dr); CmbFilter.DataSource = dt; CmbFilter.ValueMember = "AccountNo"; CmbFilter.DisplayMember = "AccountName"; CmbFilter.SelectedValue = "0"; CmbFilter.SelectedText = "ALL"; } catch (Exception exc) { MessageBox.Show(exc.Message); } }
private void CmdDelete_Click(object sender, EventArgs e) { try { if (!vOpenMode) { return; } DialogResult dMsg = MessageBox.Show("Are you Sure To Delete!!!", "Confirmation", MessageBoxButtons.YesNo, MessageBoxIcon.Question); if (dMsg == DialogResult.No) { return; } if (!string.IsNullOrEmpty(TxtID.Tag.ToString())) { var AccDAL = new DAL.ChartOfAccounts(); AccDAL.connectionstring = objDAL.connectionstring; DAL.Parties obj = new DAL.Parties(); obj.connectionstring = objDAL.connectionstring; obj.DeleteRecord(Int32.Parse(TxtID.Tag.ToString())); } MessageBox.Show("Record Deleted Successfully.", "Task Completed", MessageBoxButtons.OK, MessageBoxIcon.Information); LoadGrid(); CmdClear_Click(sender, e); } catch (Exception exc) { MessageBox.Show(exc.Message); } }
private void CmdSave_Click(object sender, EventArgs e) { try { if (txtName.Text.Trim() == string.Empty) { MessageBox.Show("Please Enter Party Name."); txtName.Focus(); return; } Objects.Parties obj = new Objects.Parties(); obj.PartyID = TxtPrefix.Text + "" + TxtID.Text; obj.PartyName = txtName.Text.Trim(); obj.Phone1 = txtPhone1.Text.Trim(); obj.Phone2 = txtPhone2.Text.Trim(); obj.City = TxtCity.Text.Trim(); obj.Address = TxtAddress.Text.Trim(); obj.EMail = txtEmail.Text.Trim(); int vDueDays; int.TryParse(txtDueDays.Text, out vDueDays); obj.DueDays = vDueDays; int vDiscRatio; int.TryParse(txtDiscRatio.Text, out vDiscRatio); obj.DiscRatio = vDiscRatio; obj.Description = txtDescription.Text.Trim(); obj.ContactPerson = txtContactPerson.Text.Trim(); obj.OfficeID = int.Parse(CmbOffice.SelectedValue.ToString()); obj.SectorID = int.Parse(CmbSector.SelectedValue.ToString()); obj.GroupID = int.Parse(CmbGroups.SelectedValue.ToString());// idher name likhain grou obj.Mobile = txtMobileNo.Text.Trim(); obj.Fax = txtFax.Text.Trim(); obj.InActive = ChkInActive.Checked; // obj. = ChkVendor.Checked; if (ChkVendor.Checked == true) { obj.PartyType = "V"; } else { obj.PartyType = "C"; } decimal vDebitLimit = 0; decimal vCreditLimit = 0; decimal.TryParse(this.txtDebitLimit.Text, out vDebitLimit); decimal.TryParse(this.txtCreditLimit.Text, out vCreditLimit); obj.CreditLimit = vCreditLimit; obj.DebitLimit = vDebitLimit; //Insert Account var AccDAL = new DAL.ChartOfAccounts(); AccDAL.connectionstring = objDAL.connectionstring; Objects.ChartOfAccounts objAcc = new Objects.ChartOfAccounts(); if (!string.IsNullOrEmpty(TxtID.Tag.ToString())) { objAcc.AccountNo = TxtID.Tag.ToString(); } objAcc.AccountName = obj.PartyName; objAcc.AccountType = "Parties"; objAcc.InActive = true; objAcc.AccountDepth = 2; objAcc.AccountNameUrdu = txtNameUrdu.Text.Trim(); objAcc.Narration = txtDescription.Text.Trim(); objAcc.OfficeID = Int32.Parse(CmbOffice.SelectedValue.ToString()); objAcc.OpeningDebit = vDebitLimit; objAcc.OpeningCredit = vCreditLimit; objAcc.ParentAccountNo = "62"; objAcc.ResidualValue = decimal.Parse(vDueDays.ToString()); objAcc.IsDetailed = false; objAcc.IsSold = false; objAcc.EntryDate = DateTime.Now; objAcc.AdjustedCredit = 0; objAcc.AdjustedDebit = 0; objAcc.BalFlag = false; objAcc.ExpFlag = false; objAcc.IsEditable = false; objAcc.IsLocked = false; objAcc.IsPosted = false; decimal vDisRatio; decimal.TryParse(txtDiscRatio.Text, out vDisRatio); objAcc.Life = vDisRatio; objAcc.PLFlag = Convert.ToBoolean(obj.PayablesFlag).ToString(); objAcc.UserNo = 1; if (!vOpenMode) { objAcc.AccountNo = obj.PartyID; //objDAL.getNextNo().ToString(); AccDAL.InsertRecord(objAcc); //Insert Party // obj.PartyID = objDAL.getNextNo().ToString (); // obj.AccountID= objAcc.AccountNo; objDAL.InsertRecord(obj); } else { // UPdate Opeinig in Account // AccDAL.UpdateRecord(objAcc); objDAL.UpdateRecord(obj); } MessageBox.Show("SaveRecord"); LoadGrid(); CmdClear_Click(sender, e); } catch (Exception exc) { MessageBox.Show(exc.Message); } }
private void CmdSave_Click(object sender, EventArgs e) { try { if (TxtName.Text.Trim() == string.Empty) { //MessageBox.Show(exc.Message); TxtName.Focus(); return; } Objects.Salesmen obj = new Objects.Salesmen(); obj.SalesmanID = TxtPrefix.Text + " " + TxtID.Text; obj.SalesmanName = TxtName.Text.Trim(); obj.Address = TxtAddress.Text.Trim(); obj.Phone = txtPhone1.Text.Trim(); obj.City = TxtCity.Text.Trim(); obj.Mobile = txtMobileNo.Text.Trim(); obj.NIC = txtNIC.Text.Trim(); // obj.CommissionRatio = decimal.Parse(txtCommisionRatio.Text.ToString()); int vCommRatio; int.TryParse(txtCommisionRatio.Text, out vCommRatio); obj.CommissionRatio = vCommRatio; obj.IsStockHolder = chkStockHolder.Checked; obj.IsStaff = chkStaff.Checked; obj.OfficeID = int.Parse(CmbOffice.SelectedValue.ToString()); obj.Designation = txtDesignation.Text.Trim(); // decimal vOpDebit = 0; //decimal vOpCredit = 0; //Insert Account var AccDAL = new DAL.ChartOfAccounts(); AccDAL.connectionstring = objDAL.connectionstring; Objects.ChartOfAccounts objAcc = new Objects.ChartOfAccounts(); // if (!string.IsNullOrEmpty(TxtID.Tag.ToString())) objAcc.AccountNo = obj.SalesmanID; objAcc.AccountName = obj.SalesmanName; objAcc.AccountType = "Parties"; objAcc.InActive = true; objAcc.AccountDepth = 1; objAcc.AccountNameUrdu = ""; objAcc.Narration = ""; objAcc.OfficeID = Int32.Parse(CmbOffice.SelectedValue.ToString()); objAcc.OpeningDebit = 0; objAcc.OpeningCredit = 0; objAcc.ParentAccountNo = "63"; objAcc.ResidualValue = 0; objAcc.IsDetailed = false; objAcc.IsSold = false; objAcc.EntryDate = DateTime.Now; objAcc.AdjustedCredit = 0; objAcc.AdjustedDebit = 0; objAcc.BalFlag = false; objAcc.ExpFlag = false; objAcc.IsEditable = false; objAcc.IsLocked = false; objAcc.IsPosted = false; decimal vCommissionRatio; decimal.TryParse(txtCommisionRatio.Text, out vCommissionRatio); objAcc.Life = vCommissionRatio; objAcc.PLFlag = ""; objAcc.UserNo = 1; if (!vOpenMode) { objAcc.AccountNo = obj.SalesmanID; //objDAL.getNextNo().ToString(); AccDAL.InsertRecord(objAcc); objDAL.InsertRecord(obj); } else { objDAL.UpdateRecord(obj); } MessageBox.Show("SaveRecord"); LoadGrid(); CmdClear_Click(sender, e); } catch (Exception exc) { MessageBox.Show(exc.Message); } }