public int TransferInvoiceToSellType(bool current) { int ni = Current.Number; InvoiceType it = InvoiceType.sell; if (!current) { GenerateNewInvoiceNumber(InvoiceType.sell); it = InvoiceType.proforma; db.Query(string.Format(@"UPDATE {4}`invoice` SET `type` = '{0}',`InvoiceId`='{1}' WHERE `InvoiceId`='{2}' AND `type`='{3}'", InvoiceType.sell, ni, Current.Number, it, DBName)); db.Query(string.Format(@"UPDATE {4}`invoicedetails` SET `type` = '{0}',`InvoiceNo`='{1}' WHERE `InvoiceNo`='{2}' AND `type`='{3}'", InvoiceType.sell, ni, Current.Number, it, DBName)); } decimal customer = GetCustomer(InvoiceType.sell); decimal amount = GetPrice(InvoiceType.sell); //////////// NT= New Transaction TransactionActivity.Transaction NT = new TransactionActivity.Transaction(); ////////// TTO= Transaction Type Order TransactionActivity.TransactionType TTO = TransactionActivity.TransactionType.Order; ///////// TMT= Transaction Method Type TransactionActivity.TransactionMethod TMT = TransactionActivity.TransactionMethod.Order; //////// set transaction Price NT.Amount = amount; /////// personal id for this transaction NT.PersonalID = customer; NT.Method = TMT; NT.Description = "سفارش فاکتور شماره " + ni.ToString(); NT.Time = DateTime.Now.ToShortTimeString(); NT.Date = Generals.CreateGenerals().dateManager.GetCurrentPersianDate(); NT.Type = TTO; NT.RemainAccount = tl.RemainAccount(customer) + amount; byte DFF = Convert.ToByte(TransactionActivity.TransactionStatus.Bedehkar); NT.Status = DFF; //tl.NewTransaction(NT); tl.FillTransaction(NT, GetTransactionID(InvoiceType.sell)); return(ni); }
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 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 btnAdd_Click(object sender, EventArgs e) { if ((txtPrice.Text != "") && (GS.IsNumber(txtPrice.Text) == true) && (rbPos.Checked == true || rbCash.Checked == true || rbCheque.Checked == true)) { switch (PayType) { case 1: PayDescription = "پرداخت وجه نقد - اسکناس" + " - " + txtDescription.Text; break; case 2: PayDescription = "پرداخت وجه نقد - کارت" + " - " + txtDescription.Text; break; } try { if (mode == "edit") { if (Payis != "cheque") { TL.Edit(PayId, Convert.ToDouble(txtPrice.Text), PayDescription, txtDate.Text, CurrentPesonalID); } else { TL.Edit(PayId, txtDate.Text); } } else { //////////// NT= New Transaction TransactionActivity.Transaction NT = new TransactionActivity.Transaction(); ////////// TTO= Transaction Type Order TransactionActivity.TransactionType TTO = TransactionActivity.TransactionType.pay; ///////// TMT= Transaction Method Type TransactionActivity.TransactionMethod TMT = TransactionActivity.TransactionMethod.cash; //////// set transaction Price NT.Amount = Convert.ToDecimal(txtPrice.Text); /////// personal id for this transaction NT.PersonalID = CurrentPesonalID; NT.Method = TMT; NT.Description = PayDescription; NT.Time = DateTime.Now.ToShortTimeString(); if (string.IsNullOrEmpty(txtDate.Text)) { MessageBox.Show("لطفا تاریخ پرداخت را مشخص کنید."); txtDate.Focus(); return; } NT.Date = txtDate.Text; NT.Type = TTO; NT.RemainAccount = TL.RemainAccount(CurrentPesonalID) - Convert.ToDecimal(NT.Amount); byte DFF = Convert.ToByte(TransactionActivity.TransactionStatus.Bestankar); NT.Status = DFF; TL.NewTransaction(NT); } MessageBox.Show("ثبت پرداخت با موفقیت انجام شد."); txtPrice.Text = ""; txtDate.Text = ""; frmPay_Load(sender, e); } catch { MessageBox.Show("لطفا فقط عدد وارد کنید."); } } else { MessageBox.Show("لطفا مبلغ و سایر اطلاعات را وارد کنید"); }/////// end price validation }