private void tsmiPayEdit_Click(object sender, EventArgs e) { if (dgvAllPay.Rows.Count > 0) { Int16 PayID = Convert.ToInt16(dgvAllPay.CurrentRow.Cells[0].Value); TransactionActivity.TransactionLog TL = new TransactionActivity.TransactionLog(); DataTable dtDFPP = TL.Select(PayID);///// DFPP= Delete From Person Pay if (dtDFPP != null) { frmPay fp = new frmPay(); if (dtDFPP.Rows[0]["payMethod"].ToString() == "doc") { //frmCheck FC = new frmCheck(); //FC.PersonalId = Convert.ToInt16(CurrentPesonalID); //FC.ShowDialog(this); fp.Payis = "cheque"; } else if (dtDFPP.Rows[0]["payMethod"].ToString() == "cash") { fp.Payis = "cash"; } fp.CurrentPesonalID = Convert.ToDecimal(CurrentPesonalID); fp.mode = "edit"; fp.PayId = Convert.ToDecimal(dgvAllPay.CurrentRow.Cells[0].Value); fp.Text = "اصلاح پرداختی"; fp.ShowDialog(this); } } }
private void btnOKEdit_Click(object sender, EventArgs e) { string query = " `id` ='" + Convert.ToInt16(strid) + "'"; string change = "`id` = '" + Convert.ToInt16(strid) + "'"; if (CustomerNo_change) { change += " , `CustumerNo` = '" + Convert.ToInt32(CustomerNo.Text) + "'"; } if (dateTimeSaresid_change) { change += " , `t_saresid` = '" + txtChequeDate.Text + "'"; } //if (dateTimeDaryaft_change) //{ // change += " , `t_sodor` = '" + dateTimeDaryaft.Value.ToString() + "'"; //} if (txtCHvajhe_change) { change += " , `dar_vajhe` = '" + txtCHvajhe.Text + "'"; } if (txtCHcost_change) { change += " , `mablagh` = '" + Convert.ToDouble(txtCHcost.Text) + "'"; } if (txtCHowner_change) { change += " , `saheb_hesab` = '" + txtCHowner.Text + "'"; } if (txtCHnumber_change) { change += " , `serail_chek` = '" + txtCHnumber.Text + "'"; } if (txtCHbank_change) { change += " , `bank` = '" + txtCHbank.Text + "'"; } TransactionActivity.TransactionLog TL = new TransactionActivity.TransactionLog(); TL.Edit("پرداخت چک با شماره سریال:" + OldSN + " ", "پرداخت چک با شماره سریال:" + txtCHnumber.Text + " ", OldCustomerNo, Convert.ToDecimal(CustomerNo.Text), Convert.ToDouble(txtCHcost.Text)); //MessageBox.Show(change+"::::"+query); change += " , `typeCheck` = '" + (Convert.ToInt16(rdbGet.Checked ? false : rdbPay.Checked)).ToString() + "'"; //change += ; ch.edit_chek(query, change); btnAddchek.Enabled = true; btnReload.Enabled = true; btnSearch.Enabled = true; btnCancelEdit.Enabled = false; btnOKEdit.Enabled = false; refresh_page(); }
private void calcPesonalAccountStatus() { TransactionActivity.TransactionLog TL = new TransactionActivity.TransactionLog(); //string totDueQuery = ""; string totDueQuery = TL.GetAllSell(cSC.ID).ToString();// "SELECT SUM( `ItemPrice` * `itemCount` ) AS totBuy FROM `invoicedetails`WHERE `InvoiceNo`IN (SELECT `InvoiceId`FROM `invoice` WHERE `InvoiceUserId` = '" + cSC.ID + "')AND `itemCount` != '0'"; DataTable dtcpas = GS.db.Query(totDueQuery); decimal CPI = Convert.ToDecimal(cSC.ID); txtTotBuy.Text = GS.nf(TL.CalcPersonalPriceOfBuy(CPI).ToString()); txtTotPay.Text = GS.nf((TL.CalcPersonalPriceOfCashPay(CPI) + TL.CalcPersonalPriceOfChequePay(CPI)).ToString()); //txtOldDue.Text = GS.nf(TL.CalcPersonalPriceOfOldPay(CPI).ToString()); txtOldDue.Text = GS.nf(TL.CalcPersonalPriceOfOldRemainAccount(CPI).ToString()); dgvReaminAccountList.AutoGenerateColumns = false; dgvReaminAccountList.DataSource = TL.GetOldRemainAccountList(CPI); if (dtcpas != null || txtOldDue.Text == "0") { double TotBuy = Convert.ToDouble(txtTotBuy.Text.ToString()); double TotOldDue = Convert.ToDouble(txtOldDue.Text.ToString()); double TotPay = Convert.ToDouble(txtTotPay.Text.ToString()); double TotSell = Convert.ToDouble(TL.GetAllSell(cSC.ID)); double pas = (TotBuy + TotOldDue) - TotPay - TotSell; if (pas < 0) { txtBestankar.Text = GS.nf(Convert.ToString(pas * (-1))); txtDue.Text = "0"; } else { txtBestankar.Text = "0"; txtDue.Text = GS.nf(Convert.ToString(pas)); } dgvAllInvoiceList.AutoGenerateColumns = false; dgvAllInvoiceList.DataSource = GS.db.Query("SELECT * FROM `invoice` WHERE `InvoiceUserId`='" + cSC.ID + "' AND `type`='" + Invoice.InvoiceType.sell + "'"); dgvAllInvoiceList.Refresh(); dgvPish.AutoGenerateColumns = false; dgvPish.DataSource = GS.db.Query("SELECT * FROM `invoice` WHERE `InvoiceUserId`='" + cSC.ID + "' AND `type`='" + Invoice.InvoiceType.proforma + "'"); dgvPish.Refresh(); dgvAllPay.AutoGenerateColumns = false; dgvAllPay.DataSource = GS.db.Query("SELECT * FROM `accounting` WHERE `personalId`='" + cSC.ID + "' AND `payType` ='pay'"); } else { dgvAllInvoiceList.DataSource = null; } }
private void tsmiAddDue_Click(object sender, EventArgs e) { if (GS.dialog.InputBox("ثبت پرداخت نقدی", "مبلغ مانده حساب این شخص چقدر است؟", "") == DialogResult.OK) { if (GS.dialog.InputValue.Length > 3) { try { var tl = new TransactionActivity.TransactionLog(); //////////// NT= New Transaction TransactionActivity.Transaction NT = new TransactionActivity.Transaction(); ////////// TTO= Transaction Type Order TransactionActivity.TransactionType TTO = TransactionActivity.TransactionType.RemainAccount; ///////// TMT= Transaction Method Type TransactionActivity.TransactionMethod TMT = TransactionActivity.TransactionMethod.Old; //////// set transaction Price NT.Amount = Convert.ToDecimal(GS.dialog.InputValue); /////// personal id for this transaction NT.PersonalID = Convert.ToDecimal(CurrentPesonalID); NT.Method = TMT; NT.Description = "ثبت مانده حساب"; NT.Time = DateTime.Now.ToShortTimeString(); NT.Date = GS.dateManager.GetCurrentPersianDate(); NT.Type = TTO; NT.RemainAccount = tl.RemainAccount(Convert.ToDecimal(CurrentPesonalID)) + Convert.ToDecimal(NT.Amount); byte DFF = Convert.ToByte(TransactionActivity.TransactionStatus.Bedehkar); NT.Status = DFF; tl.NewTransaction(NT); MessageBox.Show("ثبت مانده حساب با موفقیت انجام شد."); } catch { //PayAmount = 0; MessageBox.Show("لطفا فقط عدد وارد کنید."); } } } }
private void tsmiOldRemainaccountDelete_Click(object sender, EventArgs e) { if (dgvReaminAccountList.Rows.Count > 0) { TransactionActivity.TransactionLog TL = new TransactionActivity.TransactionLog(); DataTable dtRemainAccount = TL.Select(Convert.ToDecimal(dgvReaminAccountList.CurrentRow.Cells[0].Value)); if (dtRemainAccount.Rows.Count == 1) { string QMessage = "مانده حساب با مبلغ" + GS.nf(dtRemainAccount.Rows[0]["payPrice"].ToString()) + " و با شرح ( " + dtRemainAccount.Rows[0]["payAbout"].ToString() + " ) حذف شود؟"; if (GS.dialog.Question("حذف مانده حساب", QMessage) == DialogResult.OK) { decimal TLId = Convert.ToDecimal(dtRemainAccount.Rows[0]["id"].ToString()); TL.delete(TLId); SelectPersonal(); } } } }
private void tsmiDeletePay_Click(object sender, EventArgs e) { try { Int16 PayID = Convert.ToInt16(dgvAllPay.CurrentRow.Cells[0].Value); DataTable dtDFPP = new DataTable();///// DFPP= Delete From Person Pay dtDFPP = GS.db.Query("SELECT * FROM `accounting` WHERE `id`='" + PayID.ToString() + "'"); if (dtDFPP != null) { string QMessage = "میخواهید پرداختی شخص با مبلغ " + GS.nf(dtDFPP.Rows[0]["payPrice"].ToString()) + " و با شرح ( " + dtDFPP.Rows[0]["payAbout"].ToString() + " )را حذف کنید؟"; if (GS.dialog.Question("حذف پرداختی ها", QMessage) == DialogResult.OK) { if (dtDFPP.Rows[0]["payMethod"].ToString() == "doc") { if (GS.dialog.Question("حذف چک پرداختی مشتری", "پرداخت از نوع چک می باشد آیا میخواهید آن را حذف کنید؟") == DialogResult.OK) { chek ZSMC = new chek(); // string CheckSerial = Regex.Match(dtDFPP.Rows[0]["payAbout"].ToString(), @"\d").Value.ToString(); string CheckSerial = dtDFPP.Rows[0]["payAbout"].ToString(); string CSN = Regex.Replace(CheckSerial, @"\D", "").ToString(); //MessageBox.Show(CSN); ZSMC.delet_chek(CSN); TransactionActivity.TransactionLog TL = new TransactionActivity.TransactionLog(); TL.delete(PayID); SelectPersonal(); } } else { TransactionActivity.TransactionLog TL = new TransactionActivity.TransactionLog(); TL.delete(PayID); SelectPersonal(); } } }//////// End Validate Result of selected row from pay list } catch { } }
private void btnImportPersonalRemainAccount_Click(object sender, EventArgs e) { Clients m = new Clients(); List <Clients.Client> mm = m.getClients(""); foreach (Clients.Client c in mm) { } return; var myDataTable = new DataTable(); openFileDialog1.ShowDialog(this); if (string.IsNullOrEmpty(openFileDialog1.FileName)) { MessageBox.Show("هیچ فایلی انتخاب نشده است."); return; } string dbFile = openFileDialog1.FileName; using (var conection = new OleDbConnection("Provider=Microsoft.JET.OLEDB.4.0;" + "data source=" + dbFile + ";")) using (DataTable dt = new DataTable()) { string query = "Select * From `tblmembers`"; using (OleDbDataAdapter adapter = new OleDbDataAdapter(query, conection)) { adapter.Fill(dt); } foreach (DataRow dr in dt.Rows) { string AllDue = dr["Alldue"].ToString(); string AllPay = dr["TotPayment"].ToString(); decimal Result = Convert.ToDecimal(AllDue) - Convert.ToDecimal(AllPay); if (Result > 0) { MessageBox.Show(dr["mname"].ToString() + " | " + Result.ToString()); } //} // return; var tl = new TransactionActivity.TransactionLog(); //////////// NT= New Transaction TransactionActivity.Transaction NT = new TransactionActivity.Transaction(); ////////// TTO= Transaction Type Order TransactionActivity.TransactionType TTO = TransactionActivity.TransactionType.RemainAccount; ///////// TMT= Transaction Method Type TransactionActivity.TransactionMethod TMT = TransactionActivity.TransactionMethod.Old; //////// set transaction Price NT.Amount = Convert.ToDecimal(""); /////// personal id for this transaction NT.PersonalID = Convert.ToDecimal(""); NT.Method = TMT; NT.Description = "مانده حساب از سال مالی گذشته"; NT.Time = DateTime.Now.ToShortTimeString(); NT.Date = GS.dateManager.GetCurrentPersianDate(); NT.Type = TTO; NT.RemainAccount = tl.RemainAccount(Convert.ToDecimal("")) + Convert.ToDecimal(NT.Amount); byte DFF = Convert.ToByte(TransactionActivity.TransactionStatus.Bedehkar); NT.Status = DFF; tl.NewTransaction(NT); } } }
private void btnAddchek_Click(object sender, EventArgs e) { //if (CustomerNo.Text != "" && dateTimeSaresid.Value.ToString() != "" && dateTimeDaryaft.Value.ToString() != "" && txtCHvajhe.Text != "" && txtCHcost.Text != "" && txtCHowner.Text != "" && txtCHnumber.Text != "" && txtCHbank.Text != "") if (CustomerNo.Text != "" && txtChequeDate.Text != "" && GS.dateManager.pdp.GetDate() != "" && txtCHvajhe.Text != "" && txtCHcost.Text != "" && txtCHowner.Text != "" && txtCHnumber.Text != "" && txtCHbank.Text != "") { if (check_int(CustomerNo.Text)) { if (check_Double(txtCHcost.Text)) { string payType = ""; ////////// TTP= Transaction Type Pay TransactionActivity.TransactionType TTP; byte TS; var tl = new TransactionActivity.TransactionLog(); //////////// NT= New Transaction TransactionActivity.Transaction NT = new TransactionActivity.Transaction(); string Description = ""; byte Dff = 0; //MessageBox.Show("BB: " + Dff); if (rdbGet.Checked == true) { Dff = Convert.ToByte(TransactionActivity.TransactionStatus.Bestankar); TTP = TransactionActivity.TransactionType.pay; TS = Dff;//TransactionActivity.TransactionStatus.Bestankar; payType = "get"; chType = false; Description = "پرداخت چک با شماره:" + txtCHnumber.Text + "و تاریخ :" + txtChequeDate.Text; NT.RemainAccount = tl.RemainAccount(Convert.ToDecimal(CustomerNo.Text)) - Convert.ToDecimal(txtCHcost.Text); } else { Dff = Convert.ToByte(TransactionActivity.TransactionStatus.Bedehkar); TTP = TransactionActivity.TransactionType.get; TS = Dff;//TransactionActivity.TransactionStatus.Bedehkar; payType = "pay"; chType = true; Description = "دریافت چک با شماره سریال:" + txtCHnumber.Text + " "; NT.RemainAccount = tl.RemainAccount(Convert.ToDecimal(CustomerNo.Text)) + Convert.ToDecimal(txtCHcost.Text); } int AddCheck = ch.add_to_chek(Convert.ToInt32(CustomerNo.Text), txtChequeDate.Text, GS.dateManager.pdp.GetDate(), txtCHvajhe.Text, Convert.ToDouble(txtCHcost.Text), txtCHowner.Text, txtCHnumber.Text, txtCHbank.Text, chType); switch (AddCheck) { case 1: //if (PersonalId > 0) // Description = "پرداخت چک با شماره سریال:"+txtCHnumber.Text; //else // Description = ""; //PayAmount = Convert.ToDecimal(GS.dialog.InputValue); ///////// TMT= Transaction Method Type TransactionActivity.TransactionMethod TMT = TransactionActivity.TransactionMethod.doc; NT.Amount = Convert.ToDecimal(txtCHcost.Text); NT.PersonalID = Convert.ToDecimal(CustomerNo.Text); NT.Method = TMT; NT.Description = Description; NT.Time = DateTime.Now.ToShortTimeString(); NT.Date = GS.dateManager.GetCurrentPersianDate(); NT.Type = TTP; NT.Status = TS; tl.NewTransaction(NT); //string payQuery = "INSERT INTO `accounting` (`personalId`,`payPrice`,`payAbout`,`payMethod`,`payType`,`payTime`,`payDate`) " + //"VALUES(" + //"'" + CustomerNo.Text + "'" + //",'" + txtCHcost.Text + "'" + //",'"+Description+"'" + //",'doc'" + //",'"+payType+"'" + //",'" + DateTime.Now.ToShortTimeString() + "'" + //",'" + GS.GetCurrentDate() + "'" + //")"; //GS.db.Query(payQuery); refresh_page(); if (PersonalId > 0) { this.Close(); } break; case 2: MessageBox.Show("شماره سریال چک تکراری می باشد. چکی با این شماره سریال در سیستم ثبت شده است."); break; case 0: MessageBox.Show("ثبت چک با مشکل مواجه شده است! لطفا مجددا تلاش کنید."); break; } } else { MessageBox.Show("مبلغ صحیح وارد نشده"); } } else { MessageBox.Show("شماره مشتری صحیح وارد نشده"); } } else { MessageBox.Show("تمام فیلد ها را پر کنید"); } }