Ejemplo n.º 1
0
 public ChequeAddForm(Cheque chq)
     : this()
 {
     this.edit = true;
     this.editID = chq.ID;
     this.cmbAccountants.SelectedValue = chq.Invoice.TarafID;
     this.chkPaidInvoices.Checked = true;
     this.txtInvoiceID.Text = chq.InvoiceID.ToString();
     this.lstInvoiceForCheque.FindItemWithText(chq.InvoiceID.ToString(), true, 0, true).Selected = true;
     this.cmbBankNameAccount.SelectedValue = chq.AccountID;
     this.txtChequeNumber.Text = chq.CheckNum.ToString();
     this.txtChequePrice.Text = chq.Price.ToString();
     this.abrChequeDate.SelectedDate = (Utilities.getMiladiFromPersian(chq.Date));
 }
Ejemplo n.º 2
0
 public static void SaveDocument(Cheque chq)
 {
     var DB = new StoreDBEntities();
     long accountid = 0;
     try
     {
         accountid = DB.Accounts.First(x => x.DistributorID == chq.Invoice.TarafID).Id;
     }
     catch (InvalidOperationException)
     {
         Account newAcc = new Account
         {
             Name = chq.Invoice.Distributor.Name,
             Description = " ",
             CustomerID = 0,
             DistributorID = chq.Invoice.TarafID,
             BankAccountID = 0
         };
         DB.Accounts.AddObject(newAcc);
         DB.SaveChanges();
         accountid = DB.Accounts.OrderByDescending(x => x.Id).First().Id;
     }
     Document newDoc = new Document
     {
         AccountID = accountid,
         Description = "چک شماره" + chq.CheckNum + " بابت فاکتور خ شماره " + chq.InvoiceID,
         Value = chq.Price,
         Date = chq.Invoice.Date,
         SetDate = Utilities.getCurrentPersianDate(),
         Debt_Credit = true,
         ChequeID = chq.ID
     };
     DB.Documents.AddObject(newDoc);
     DB.SaveChanges();
     //--------------------------
     long bankID = 0;
     try
     {
         bankID = DB.Accounts.First(x => x.BankAccountID == chq.BankAccount.ID).Id;
     }
     catch (InvalidOperationException)
     {
         Account newAcc = new Account
         {
             Name = "بانک " + chq.BankAccount.BankName,
             Description = " ",
             CustomerID = 0,
             DistributorID = 0,
             BankAccountID = chq.BankAccount.ID
         };
         DB.Accounts.AddObject(newAcc);
         DB.SaveChanges();
         bankID = DB.Accounts.OrderByDescending(x => x.Id).First().Id;
     }
     Document newBankDoc = new Document
     {
         AccountID = bankID,
         Description = "چک شماره" + chq.CheckNum + " در وجه " + chq.Invoice.Distributor.Name,
         Value = chq.Price,
         Date = chq.Date,
         SetDate = Utilities.getCurrentPersianDate(),
         Debt_Credit = false,
         ChequeID = chq.ID
     };
     DB.Documents.AddObject(newBankDoc);
     DB.SaveChanges();
 }
Ejemplo n.º 3
0
 /// <summary>
 /// Create a new Cheque object.
 /// </summary>
 /// <param name="id">Initial value of the ID property.</param>
 /// <param name="accountID">Initial value of the AccountID property.</param>
 /// <param name="checkNum">Initial value of the CheckNum property.</param>
 /// <param name="invoiceID">Initial value of the InvoiceID property.</param>
 /// <param name="date">Initial value of the Date property.</param>
 /// <param name="price">Initial value of the Price property.</param>
 /// <param name="paid">Initial value of the Paid property.</param>
 public static Cheque CreateCheque(global::System.Int64 id, global::System.Int64 accountID, global::System.Int32 checkNum, global::System.Int64 invoiceID, global::System.String date, global::System.Int32 price, global::System.Boolean paid)
 {
     Cheque cheque = new Cheque();
     cheque.ID = id;
     cheque.AccountID = accountID;
     cheque.CheckNum = checkNum;
     cheque.InvoiceID = invoiceID;
     cheque.Date = date;
     cheque.Price = price;
     cheque.Paid = paid;
     return cheque;
 }
Ejemplo n.º 4
0
        private void btnSaveChequeData_Click(object sender, System.EventArgs e)
        {
            if (this.txtInvoiceID.Text == "")
            {
                this.errorProvider.SetError(this.txtInvoiceID, " شماره فاکتور وارد نشده است");
                return;
            }
            if (this.txtChequeNumber.Text == "")
            {
                this.errorProvider.SetError(this.txtChequeNumber, "شماره چک وارد نشده است");
                return;
            }
            if (this.txtChequePrice.Text == "")
            {
                this.errorProvider.SetError(this.txtChequePrice, "مبلغ چک وارد نشده است");
                return;
            }
            if (this.cmbBankNameAccount.SelectedValue == null)
            {
                this.errorProvider.SetError(this.cmbBankNameAccount, "حساب بانکی انتخاب نشده است");
                return;
            }
            long cheqID = 0L;
            if (this.edit)
            {
                Cheque cheque = this.DB.Cheques.First((Cheque x) => x.ID == this.editID);
                cheqID = editID;
                cheque.Date = this.abrChequeDate.SelectedDateString;
                cheque.AccountID = (long)this.cmbBankNameAccount.SelectedValue;
                cheque.Price = int.Parse(this.txtChequePrice.Text);
                cheque.CheckNum = int.Parse(this.txtChequeNumber.Text);
                DB.Cheques.ApplyCurrentValues(cheque);
                this.DB.SaveChanges();
                this.edit = false;
            }
            else
            {
                long accid = long.Parse(this.cmbBankNameAccount.SelectedValue.ToString());
                int num = int.Parse(this.txtChequeNumber.Text);
                long invid = long.Parse(this.txtInvoiceID.Text);
                string dte = this.abrChequeDate.SelectedDateString;
                int prc = int.Parse(this.txtChequePrice.Text);
                bool pd = false;
                Cheque chq = new Cheque()
                {
                    AccountID = accid,
                    CheckNum = num,
                    InvoiceID = invid,
                    Price = prc,
                    Date = dte,
                    Paid = pd
                };
                DB.Cheques.AddObject(chq);
                DB.SaveChanges();
                cheqID = DB.Cheques.OrderByDescending(x => x.ID).First().ID;
            }


            ////////////////////////////////////////////////////////////////
            SaveDocument(DB.Cheques.First(x=>x.ID == cheqID));
            /////////////////////////////////////////////////////////////////////////////
            FarsiMessage.Show("چک با موفقیت ثبت شد", "تمام");
            if (this.lstInvoiceForCheque.SelectedItems.Count == 0)
            {
                this.lstInvoiceForCheque.SelectedIndices.Add(this.lstInvoiceForCheque.FindItemWithText(this.txtInvoiceID.Text, true, 0, true).Index);
            }
            if (this.lstInvoiceForCheque.SelectedItems[0].SubItems[5].Text == "پ نشده" && 
                FarsiMessage.Show("آیا مایل هستید فاکتور پرداخت شده در نظر گرفته شود؟", "تمام", FarsiMessageBoxButtons.YesNo, FarsiMessageBoxIcons.Question) == DialogResult.Yes)
            {
                long id = long.Parse(this.txtInvoiceID.Text);
                Invoice invoice = this.DB.Invoices.First((Invoice x) => x.InvoiceID == id);
                invoice.Paid = true;
                DB.Invoices.ApplyCurrentValues(invoice);
                this.DB.SaveChanges();
            }
            if (this.edit)
            {
                base.Close();
                return;
            }
            this.InitializeForm();
        }
Ejemplo n.º 5
0
 /// <summary>
 /// Deprecated Method for adding a new object to the Cheques EntitySet. Consider using the .Add method of the associated ObjectSet&lt;T&gt; property instead.
 /// </summary>
 public void AddToCheques(Cheque cheque)
 {
     base.AddObject("Cheques", cheque);
 }