[Abu Ehab]

نصمم فورم لجـــــــدول Accounts


الكود :

PHP كود :

using System;
using System.Collections.Generic;
using System.ComponentModel;
using System.Data;
using System.Drawing;
using System.Linq;
using System.Text;
using System.Windows.Forms;

namespace AccountsBox_Manager
{
    public partial class FrmAccounts : Form
    {
        public FrmAccounts()
        {
            InitializeComponent();
        }
        DataLayer cmd = new DataLayer();
        private void FrmAccounts_Load(object sender, EventArgs e)
        {
            xid = 0;
            CmbNames.Text = ""; NewAccountBox.Text = ""; TotalBox.Text = "";
            CmbNames.Items.Clear();
            CmbNames .Items .AddRange (( from c in cmd .GetAllCustomers()
                                         select c .CustomerName ).ToArray ());
        }
        int xid = 0;
        private void CmbNames_SelectedIndexChanged(object sender, EventArgs e)
        {
            if (CmbNames.Text != "")
            {

                cmd = new DataLayer();
                      xid = (from i in cmd.GetAllCustomers() 
                           where i.CustomerName == CmbNames.Text select i.ID).Single();
                    TotalBox.Text = (from a in cmd.GetAllAccounts()
                                     where a.CustomerID == xid
                                     select a.TotalAccount.ToString()).Single();
                 
                             
            }
        }

        private void BackBtn_Click(object sender, EventArgs e)
        {
            Form frm = new FrmAddCustomer();
            frm.Show();
            this.Hide();
        }
  
        private void DepositBtn_Click(object sender, EventArgs e)
        {
            // إضـــافة مبــــــــلغ
            cmd = new DataLayer();
         
              if (xid != 0)
                {
                    var Cust = from  Db.AccountsRow Rw in  cmd.AcctData.Accounts.Rows 
                              where Rw.ID == xid
                              select Rw ;
                    foreach (var r in Cust)
                    {
                        r.TotalAccount += Convert.ToDouble (NewAccountBox.Text);
                        r.ProcessDate = DateTime.Today;

                    }
                    
                    cmd.WriteNewChanges();
                    //===========================================================
                    cmd = new DataLayer();

                    // ^^ History
                    Db.HistoryRow HRw = cmd.AcctData.History.NewHistoryRow();
                    HRw.CustomerName = CmbNames.Text;
                    HRw.PType = "إضافة مبلغ";
                    HRw.xSum = NewAccountBox.Text;
                    HRw.xDate = DateTime.Today;
                    cmd.AcctData.History.AddHistoryRow(HRw);
                    cmd.WriteNewChanges();
                    //===========================================================

                    FrmAccounts_Load(sender, e);

                    MessageBox.Show("Done");
                }
          
       
        }

        private void WithdrawalBtn_Click(object sender, EventArgs e)
        {
            try
            {
               // سحب مبلغ
            if (xid != 0)
            {
                var Cust = from Db.AccountsRow Rw in cmd.AcctData.Accounts.Rows
                           where Rw.ID == xid
                           select Rw;
               
                foreach (var r in Cust)
                {
                    if (r.TotalAccount < Convert.ToDouble(NewAccountBox.Text))
                    {
                        MessageBox.Show("الرصـــيد غيـــــر كافي");
                        NewAccountBox.Text = ""; NewAccountBox.Focus();
                        return;
                    }
                    r.TotalAccount -= Convert.ToDouble(NewAccountBox.Text);
                    r.ProcessDate = DateTime.Today;

                }

                cmd.WriteNewChanges();
                //===========================================================
                // ^^ History
                cmd = new DataLayer();
                Db.HistoryRow HRw = cmd.AcctData.History.NewHistoryRow();
                HRw.CustomerName = CmbNames.Text;
                HRw.PType = "سحب مبلغ";
                HRw.xSum = NewAccountBox.Text;
                HRw.xDate = DateTime.Today;
                cmd.AcctData.History.AddHistoryRow(HRw);
                cmd.WriteNewChanges();
                //===========================================================
                FrmAccounts_Load(sender, e);

                MessageBox.Show("Done");
            }
        }

            
            catch (Exception)
            {
                   FrmAccounts_Load(sender, e);
               
            }

        }

        private void NewAccountBox_KeyPress(object sender, KeyPressEventArgs e)
        {
            if (char.IsNumber(e.KeyChar) || e.KeyChar == '.' || e.KeyChar == '£')
            {
            }
            else
            {
                e.Handled = e.KeyChar != (char)Keys.Back;
            }
        }

    }
}