private void BtnSearch_Click(object sender, EventArgs e) { BargainSuccessRepository bargainSuccessRepository = new BargainSuccessRepository(); List <BargainSuccessViewModel> successViewModels = bargainSuccessRepository.GetAllOnSaleReport(); lblSum.Text = $"جمع مبالغ معاملات حراج باز : {(successViewModels.Sum(x => x.Price) * 1000).ToString("N0")} تومان"; label1.Text = "تعداد : " + successViewModels.Count; dgv.AutoGenerateColumns = false; dgv.DataSource = successViewModels; }
private void BtnSearch_Click(object sender, EventArgs e) { BargainSuccessRepository bargainSuccessRepository = new BargainSuccessRepository(); 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); List <BargainSuccessViewModel> successViewModels = bargainSuccessRepository.GetAllOpenSellBuy(dStart, dEnd); lblSum.Text = $"جمع مبالغ معاملات باز : {(successViewModels.Sum(x => x.Price) * 1000).ToString("N0")} تومان"; dgv.AutoGenerateColumns = false; dgv.DataSource = successViewModels; }
private async void حذفToolStripMenuItem_Click(object sender, EventArgs e) { if (MessageBox.Show($"آیا برای حذف معامله با سند {dgv.CurrentRow.Cells["Id1"].Value.ToString()} موافق هستید ؟ ", "", MessageBoxButtons.YesNo, MessageBoxIcon.Question, MessageBoxDefaultButton.Button1) == DialogResult.Yes) { if (MessageBox.Show($"حذف انجام شود ؟ ", "", MessageBoxButtons.YesNo, MessageBoxIcon.Question, MessageBoxDefaultButton.Button1) == DialogResult.Yes) { BargainSuccessRepository bargainSuccessRepository = new BargainSuccessRepository(); if (await bargainSuccessRepository.Delete(long.Parse(dgv.CurrentRow.Cells["Id1"].Value.ToString()))) { MessageBox.Show("حذف معامله مورد نظر با موفقیت انجام شد"); BtnSearch_Click(null, null); } else { MessageBox.Show("متاسفانه امکان حذف معامله وجودندارد"); } } } }
private void BtnSearch_Click(object sender, EventArgs e) { BargainSuccessRepository bargainSuccessRepository = new BargainSuccessRepository(); 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); List <BargainSuccessViewModel> successViewModels = bargainSuccessRepository.GetAllCloseBag(dStart, dEnd); long _myCommision = successViewModels.Sum(x => x.Comision); long _mySood = successViewModels.Where(x => x.Sod >= 0).Sum(x => x.Sod); long _myzarar = successViewModels.Where(x => x.Sod < 0).Sum(x => x.Sod); lblSumOpen.Text = $"جمع مبالغ باز شدن : {(successViewModels.Sum(x => x.Price) * 1000).ToString("N0")} تومان"; lblSumClose.Text = $"جمع مبالغ بسته شدن : {(successViewModels.Sum(x => x.Price2) * 1000).ToString("N0")} تومان"; lblSumSood.Text = $"جمع مبالغ سود با احتساب کارمزد : {(_mySood).ToString("N0")} تومان"; lblSumZarar.Text = $"جمع مبالغ ضرر با احتساب کارمزد : {(_myzarar).ToString("N0")} تومان"; lblSumSoodOutCommision.Text = $"جمع مبالغ سود بدون احتساب کارمزد : {(_mySood-_myCommision).ToString("N0")} تومان"; lblSumZararOutCommision.Text = $"جمع مبالغ ضرر بدون احتساب کارمزد : {(_myCommision+_myzarar).ToString("N0")} تومان"; lblCountBuy.Text = $"تعداد خرید : {(successViewModels.Where(x=>x.TypeID==2).Count()).ToString("N0")}"; lblCountSell.Text = $"تعداد فروش : {(successViewModels.Where(x=>x.TypeID==1).Count()).ToString("N0")}"; lblCountAll.Text = $"تعداد کل : {(successViewModels.Count()).ToString("N0")}"; lblSumCommision.Text = $"جمع کارمزدها : {_myCommision.ToString("N0")} تومان"; dgv.AutoGenerateColumns = false; dgv.DataSource = successViewModels; }