private void Button1_Click(object sender, EventArgs e)
{
if (!chkVariz.Checked && !chkBardasht.Checked)
{
MessageBox.Show("لطفاً نوع واریز یا برداشت را مشخص کنید");
}
else
{
using (Repository.TransactionRepository transactionRepository = new Repository.TransactionRepository())
{
Models.Transaction transaction = new Models.Transaction();
transaction.DateTime = DateTime.Now;
transaction.Disc = txtDisc.Text;
transaction.Price = int.Parse(txtPrice.Text);
if (chkVariz.Checked)
{
transaction.TransactionType_Id = 1;
}
else
{
transaction.TransactionType_Id = 2;
}
transaction.UserBargain_Id = _user_id;
transactionRepository.Add(transaction);
DialogResult = DialogResult.Yes;
}
}
}
private void TabPage2_Enter(object sender, EventArgs e)
{
using (Repository.TransactionRepository transactionRepository = new Repository.TransactionRepository())
{
List <Models.Transaction> transactions_list = transactionRepository.GetAll(_user_id);
dgvTransaction.AutoGenerateColumns = false;
long SumVariz = transactions_list.Where(x => x.TransactionType_Id == 1).Sum(x => x.Price);
long SumBardasht = transactions_list.Where(x => x.TransactionType_Id == 2).Sum(x => x.Price);
lblSumVariz.Text = "جمع واریز ها : " + SumVariz.ToString("N0");
lblSumBardasht.Text = "جمع برداشت ها : " + SumBardasht.ToString("N0");
lblSumAllVariz.Text = "جمع کل : " + (SumVariz - SumBardasht).ToString("N0");
if (UserBargain != null)
{
lblSumGarantyPrice.Text = "وجه تضمین جاری : " + UserBargain.PriceGarranty.ToString("N0");
}
dgvTransaction.DataSource = transactions_list;
//int i = 0;
//foreach (DataGridViewRow item in dgvTransaction.Rows)
//{
// if(item.Cells[3].Value.ToString()=="1")
// {
// dgvTransaction[4, i].Value = "واریز";
// }
// else
// {
// dgvTransaction[4, i].Value = "برداشت";
// }
// i++;
//}
//dgvTransaction.Refresh();
}
}
private void Button1_Click(object sender, EventArgs e)
{
utility.UtilityRepository utility = new utility.UtilityRepository();
DateTime dateTime_Start_Org = utility.ShamsiTOMiladi(txtDateStart.Value.ToString("yyyy/MM/dd"));
DateTime dateTime_End_Org = utility.ShamsiTOMiladi(txtDateEnd.Value.ToString("yyyy/MM/dd"));
DateTime dStart = new DateTime(dateTime_Start_Org.Year, dateTime_Start_Org.Month, dateTime_Start_Org.Day, 0, 0, 0);
DateTime dEnd = new DateTime(dateTime_End_Org.Year, dateTime_End_Org.Month, dateTime_End_Org.Day, 23, 59, 59);
Repository.TransactionRepository transactionRepository = new Repository.TransactionRepository();
var tmp = transactionRepository.Search(dStart, dEnd).OrderByDescending(x => x.Id);
List <ViewModels.TransactionViewModel> TransactionViewModel_list = new List <ViewModels.TransactionViewModel>();
long _variz = 0, _bardasht = 0;
foreach (var item in tmp)
{
ViewModels.TransactionViewModel model_tr = new ViewModels.TransactionViewModel();
model_tr.DateTime = utility.Convert2Shamsi(item.DateTime);
model_tr.Disc = item.Disc;
model_tr.Price = item.Price;
model_tr.Name = item.UserBargain.Name + " " + item.UserBargain.Family;
if (item.TransactionType_Id == 1)
{
model_tr.TypeName = "واریز";
_variz += item.Price;
}
else
{
model_tr.TypeName = "برداشت";
_bardasht += item.Price;
}
TransactionViewModel_list.Add(model_tr);
}// end for
dataGridView1.AutoGenerateColumns = false;
dataGridView1.DataSource = TransactionViewModel_list;
lblVariz.Text = "جمع واریزی : " + _variz.ToString("N0");
lblBardasht.Text = "جمع برداشتی : " + _bardasht.ToString("N0");
lblTotal.Text = "جمع کل : " + (_variz - _bardasht).ToString("N0");
}
public TransactionModel()
{
tRepository = new Repository.TransactionRepository();
}
