protected Driver DriverModel() { Driver driver = new Driver(); if (IdHid.Value != "0") { driver.Id = Convert.ToInt32(IdHid.Value); } if (NameTxt.Text != "") { driver.Name = NameTxt.Text; } if (AddressTxt.Text != "") { driver.Address = AddressTxt.Text; } if (PhoneTxt.Text != "") { driver.phone = PhoneTxt.Text; } if (licenseTxt.Text != "") { driver.license = licenseTxt.Text; } if (LicenceDateTxt.Text != "") { driver.LicenceDate = ExtendedMethod.FormatDate(LicenceDateTxt.Text); } if (LicencePeriodTxt.Text != "") { driver.LicencePeriod = int.Parse(LicencePeriodTxt.Text); } //Auto Calculate var date = DateTime.Parse(driver.LicenceDate.ToString()).Year + "-" + DateTime.Parse(driver.LicenceDate.ToString()).Month + "-" + DateTime.Parse(driver.LicenceDate.ToString()).Day; DateTime newyears = /*Convert.ToInt32(date[0])*/ DateTime.Parse(driver.LicenceDate.ToString()).AddYears(int.Parse(driver.LicencePeriod.ToString())); driver.LicenseEndDate = DateTime.Parse(newyears.Year + "-" + DateTime.Parse(driver.LicenceDate.ToString()).Month + "-" + DateTime.Parse(driver.LicenceDate.ToString()).Day, CultureInfo.CreateSpecificCulture("ar-EG")); if (AlertPeriodTxt.Text != "") { driver.AlertPeriod = Convert.ToInt32(AlertPeriodTxt.Text); } if (SelectedTrafDepId != "") { driver.TrafficDepID = Convert.ToInt32(SelectedTrafDepId); } driver.LoginID = ExtendedMethod.LoginedUser.Id; return(driver); }
protected CarChangeRateOnDis CarChangeRateOnDisModel() { CarChangeRateOnDis carChangeRateOnDis = new CarChangeRateOnDis(); if (IdHid.Value != "0") { carChangeRateOnDis.Id = Convert.ToInt32(IdHid.Value); } if (Description.Text != "") { carChangeRateOnDis.Description = Description.Text; } if (SelectedCarId != "") { carChangeRateOnDis.CarId = Convert.ToInt32(SelectedCarId); } if (SelectedServiceId != "") { carChangeRateOnDis.ServiceId = Convert.ToInt32(SelectedServiceId); } //Before if (Before.Text != "") { carChangeRateOnDis.Before = Convert.ToDouble(Before.Text); } if (DateBefore.Text != "") { carChangeRateOnDis.DateBefore = ExtendedMethod.FormatDate(DateBefore.Text); } if (AtHourBefore.Text != "") { carChangeRateOnDis.AtHourBefore = AtHourBefore.Text; } //After if (After.Text != "") { carChangeRateOnDis.After = Convert.ToDouble(After.Text); } if (DateAfter.Text != "") { carChangeRateOnDis.DateAfter = ExtendedMethod.FormatDate(DateAfter.Text); } if (AtHourAfter.Text != "") { carChangeRateOnDis.AtHourAfter = AtHourAfter.Text; } carChangeRateOnDis.LoginID = ExtendedMethod.LoginedUser.Id; return(carChangeRateOnDis); }
protected PurchaseInvoice PurchaseInvoiceModel() { myPurchaseInvoice = new PurchaseInvoice(); if (InvoiceNo.Text != "") { myPurchaseInvoice.Id = InvoiceNo.Text; } // if (InvoiceDate.Text != "") { myPurchaseInvoice.InvoiceDate = ExtendedMethod.FormatDate(InvoiceDate.Text); } // if (Purchase.Checked) { myPurchaseInvoice.PurchaseType = Convert.ToBoolean(true); } else if (Discarded.Checked) { myPurchaseInvoice.PurchaseType = Convert.ToBoolean(false); } // if (vendorsListtxt.SelectedValue != "") { myPurchaseInvoice.SubAccountId = Convert.ToInt32(vendorsListtxt.SelectedValue); } // if (PaymentValue.Text != "") { myPurchaseInvoice.PaymentValue = Convert.ToDouble(PaymentValue.Text); } // if (Total.Text != "") { myPurchaseInvoice.Total = Convert.ToDouble(Total.Text); } // myPurchaseInvoice.PaymentMethod = PaymentMethod(myPurchaseInvoice.Total, myPurchaseInvoice.PaymentValue); // myPurchaseInvoice.UserID = 1; return(myPurchaseInvoice); }
protected SalesInvoice SalesInvoiceModel() { mySalesInvoice = new SalesInvoice(); if (InvoiceNo.Text != "") { mySalesInvoice.Id = InvoiceNo.Text; } // if (InvoiceDate.Text != "") { mySalesInvoice.InvoiceDate = ExtendedMethod.FormatDate(InvoiceDate.Text); } // if (Sale.Checked) { mySalesInvoice.PurchaseType = Convert.ToBoolean(true); } else if (Discarded.Checked) { mySalesInvoice.PurchaseType = Convert.ToBoolean(false); } // if (CarsListtxt.SelectedValue != "") { mySalesInvoice.CarId = Convert.ToInt32(CarsListtxt.SelectedValue); } // if (ServicesListtxt.SelectedValue != "") { mySalesInvoice.ServiceId = Convert.ToInt32(ServicesListtxt.SelectedValue); } // if (Total.Text != "") { mySalesInvoice.Total = Convert.ToDouble(Total.Text); } // mySalesInvoice.UserID = 1; return(mySalesInvoice); }
protected PurchaseInvoice SearchModel() { PurchaseInvoice purchaseInvoice = new PurchaseInvoice(); purchaseInvoice.SubAccountId = Convert.ToInt32(vendorsListtxt.SelectedValue); purchaseInvoice.Id = InvoiceNo.Text; purchaseInvoice.InvoiceDate = ExtendedMethod.FormatDate(InvoiceDate.Text); if (Purchase.Checked) { purchaseInvoice.PurchaseType = Convert.ToBoolean(true); } else if (Discarded.Checked) { purchaseInvoice.PurchaseType = Convert.ToBoolean(false); } return(purchaseInvoice); }
protected SalesInvoice SearchModel() { SalesInvoice salesInvoice = new SalesInvoice(); salesInvoice.CarId = Convert.ToInt32(CarsListtxt.SelectedValue); salesInvoice.Id = InvoiceNo.Text; salesInvoice.InvoiceDate = ExtendedMethod.FormatDate(InvoiceDate.Text); if (Sale.Checked) { salesInvoice.PurchaseType = Convert.ToBoolean(true); } else if (Discarded.Checked) { salesInvoice.PurchaseType = Convert.ToBoolean(false); } return(salesInvoice); }
public void ConcatenationLists(List <Entry> Account_Mony_Operations_List, List <AccountOperationsGrd> Account_Operations_List, float Account_Sum) { // int i = 0; // float sum = 0; foreach (var operation in Account_Mony_Operations_List) { string date = DateTime.Parse(operation.Date.ToString()).Year + "-" + DateTime.Parse(operation.Date.ToString()).Month + "-" + DateTime.Parse(operation.Date.ToString()).Day; // sum = Account_Sum > float.Parse(operation.Value.ToString()) ? Account_Sum - float.Parse(operation.Value.ToString()) : float.Parse(operation.Value.ToString()) - Account_Sum; // Account_Sum if (operation.status == "دائن")//مستلم العميل دائن { Account_Operations_List.Add(new AccountOperationsGrd() { OperationID = operation.ID, OperationDate = ExtendedMethod.FormatDate(date), Description = operation.description, CreditBalance = 0, IndebtBalance = 0, Credit_Movement = float.Parse(operation.value.ToString()), InDebt_Movement = 0, }); } else//مصروف العميل مدين { Account_Operations_List.Add(new AccountOperationsGrd() { OperationID = operation.ID, OperationDate = ExtendedMethod.FormatDate(date), Description = operation.description, CreditBalance = 0, IndebtBalance = 0, Credit_Movement = 0, InDebt_Movement = float.Parse(operation.value.ToString()), }); } } Account_Operations_List = Account_Operations_List.OrderBy(o => o.OperationDate).ToList(); }
protected void SaerchBtn_Click(object sender, EventArgs e) { FromDateTxt.Text = ReformateDateFromPicker(FromDateTxt.Text); FalseCounter = 0; TaxFlag = false; OldKeadID = 0; entry = new Entry(); Entry_List = new List <Entry>(); Result_lst.Clear(); LSales = db.PurchaseInvoice.ToList().Where(o => o.InvoiceDate <= ExtendedMethod.FormatDate(FromDateTxt.Text) & o.PurchaseType == bool.Parse(BillTypeDrop.SelectedValue) ).ToList(); // Sale.GetAllPurchaseInvoiceInDate(DateTime.Parse(FromDateTxt.Text, // CultureInfo.CreateSpecificCulture("ar-EG")).ToString(), // bool.Parse(BillTypeDrop.SelectedValue));//Sale.GetAllPurchaseInvoice(FromDateTxt.Text, FromDateTxt .Text,BillTypeDrop.SelectedValue); foreach (var tt in LSales) { if (tt.KeadNo == 0) { FalseCounter++; } if (tt.PurchaseType == true) { if (tt.KeadNo != 0) { TaxFlag = true; OldKeadID = (int)tt.KeadNo; entry = db.Entry.FirstOrDefault(o => o.EntryID == int.Parse(OldKeadID.ToString())); //entry = entry.GetAllEntryByID(int.Parse(OldKeadID.ToString())).FirstOrDefault(); Entry_List.Add(entry); db.Entry.RemoveRange(Entry_List); // entry.Operations("Delete", Entry_List); db.SaveChanges(); } Result_lst.Add(new SalesResults { moveID = tt.Id, SValue = decimal.Parse(tt.Total.ToString()), KeadNo = (int)tt.KeadNo, subAccountID = int.Parse(tt.SubAccountId.ToString()) }); } else { if (tt.KeadNo != 0) { TaxFlag = true; OldKeadID = (int)tt.KeadNo; entry = db.Entry.FirstOrDefault(o => o.EntryID == int.Parse(OldKeadID.ToString()));// entry.GetAllEntryByID(int.Parse(OldKeadID.ToString())).FirstOrDefault(); Entry_List.Add(entry); //entry.Operations("Delete", Entry_List); db.Entry.RemoveRange(Entry_List); db.SaveChanges(); } // SNet = tt.Value_LE+tt.Tax_Added-tt.CommercialTax, SValue =tt.Value_LE Result_lst.Add(new SalesResults { moveID = tt.Id, SValue = (decimal)tt.Total, KeadNo = (int)tt.KeadNo, subAccountID = int.Parse(tt.SubAccountId.ToString()) }); } } AccountGrd.DataSource = Result_lst; AccountGrd.DataBind(); if (Result_lst.Count > 0) { AccountGrd.FooterRow.Cells[0].Text = "اجماليات"; AccountGrd.FooterRow.Cells[1].Text = Result_lst.Sum(c => c.SValue).ToString("#.00"); } else { ClientScript.RegisterStartupScript(this.GetType(), "تنبيه", "alert('لا يوجد نتائج');", true); } }
public void Calc_Operation() { Account = new SubAccount(); Khazna_Moved_List = new List <Entry>(); Khazna_Moved = new Entry(); Khazna_Moved_List = db.Entry.ToList().Where(o => o.SubAccount_id == int.Parse(AccountDropID.SelectedValue) & o.Date <= ExtendedMethod.FormatDate(ToDateTxt.Text)).ToList(); //Khazna_Moved.GetEntry_ByAccountIDByDate(int.Parse(AccountDropID.SelectedValue), ToDateTxt.Text); SubAccount sub_Account = new SubAccount(); sub_Account = db.SubAccount.ToList().FirstOrDefault(o => o.ID == int.Parse(AccountDropID.SelectedValue)); // sub_Account.GetSubAccount_ByID(int.Parse(AccountDropID.SelectedValue)).ElementAtOrDefault(0); float Account_Sum = float.Parse(sub_Account.ABalance.ToString()); Account_Operations = new AccountOperationsGrd(); AccountOperations_List = new List <AccountOperationsGrd>(); Account_Mony_Operations_List = new List <Entry>(); Account_Operations_List = new List <AccountOperationsGrd>(); List <AccountOperationsGrd> FinalGrd = new List <AccountOperationsGrd>(); // DateTime.Parse(operation.Date.ToString()).Year //DateTime RD= DateTime.ParseExact(sub_Account.RegisterDate.ToString(), "yyyy-MM-dd", null); if (sub_Account.BType == "مدين") { FinalGrd.Add(new AccountOperationsGrd() { OperationID = 0, OperationDate = (DateTime)sub_Account.RegisterDate, CreditBalance = 0, Credit_Movement = 0, IndebtBalance = float.Parse(sub_Account.ABalance.ToString()), //InDebt_Movement = float.Parse(sub_Account.ABalance.ToString()), Description = "رصيد افتتاحى", }); } else { FinalGrd.Add(new AccountOperationsGrd() { OperationID = 0, OperationDate = (DateTime)sub_Account.RegisterDate, CreditBalance = 0, Credit_Movement = 0, IndebtBalance = -float.Parse(sub_Account.ABalance.ToString()), //InDebt_Movement = float.Parse(sub_Account.ABalance.ToString()), Description = "رصيد افتتاحى", }); } //كل العمليات مع الخزنة الخاصة بaccount foreach (var Khazna in Khazna_Moved_List) { Account_Mony_Operations_List.Add(new Entry { ID = (int)Khazna.EntryID, status = Khazna.status, value = Khazna.value, description = Khazna.description, SubAccount_id = Khazna.SubAccount_id, Date = Khazna.Date }); } Account_Mony_Operations_List.OrderByDescending(a => a.Date); //Concatination foreach (var operation in Account_Mony_Operations_List) { string date = DateTime.Parse(operation.Date.ToString()).Year + "-" + DateTime.Parse(operation.Date.ToString()).Month + "-" + DateTime.Parse(operation.Date.ToString()).Day; float sum = Account_Sum > float.Parse(operation.value.ToString()) ? Account_Sum - float.Parse(operation.value.ToString()) : float.Parse(operation.value.ToString()) - Account_Sum; // Account_Sum if (operation.status == "دائن")//مستلم { Account_Operations_List.Add(new AccountOperationsGrd() { OperationID = operation.ID, OperationDate = ExtendedMethod.FormatDate(date), Description = operation.description, CreditBalance = sum, IndebtBalance = 0, Credit_Movement = float.Parse(operation.value.ToString()), InDebt_Movement = 0, state = false, ABalance = float.Parse(sub_Account.ABalance.ToString()) }); } else//مصروف { Account_Operations_List.Add(new AccountOperationsGrd() { OperationID = operation.ID, OperationDate = ExtendedMethod.FormatDate(date), Description = operation.description, CreditBalance = 0, IndebtBalance = sum, Credit_Movement = 0, InDebt_Movement = float.Parse(operation.value.ToString()), state = true, ABalance = float.Parse(sub_Account.ABalance.ToString()) }); } } Account_Operations_List = Account_Operations_List.OrderBy(o => o.OperationDate).ToList(); string Todate = ReformateDateFromPicker(ToDateTxt.Text); //DateTime.Parse(ToDateTxt.Text).Year + "-" + DateTime.Parse(ToDateTxt.Text).Month + "-" + DateTime.Parse(ToDateTxt.Text).Day; FinalGrd.AddRange(Account_Operations_List.Where(o => o.OperationDate <= ExtendedMethod.FormatDate(Todate))); ////FinalGrd.AddRange(Account_Operations_List.Where(o => o.OperationDate >= DateTime.Parse(fromdate) & o.OperationDate <= DateTime.Parse(Todate))); //FinalGrd.Add(new AccountOperationsGrd() //{ // CreditBalance = FinalGrd.Sum(g => g.CreditBalance), // Credit_Movement = FinalGrd.Sum(g => g.Credit_Movement), // IndebtBalance = FinalGrd.Sum(g => g.IndebtBalance), // InDebt_Movement = FinalGrd.Sum(g => g.InDebt_Movement), // OperationID = 0, // Description = "", // OperationDate = FinalGrd.LastOrDefault().OperationDate //}); float lastBalance = FinalGrd.FirstOrDefault().state == true ? (FinalGrd.FirstOrDefault().CreditBalance) + (FinalGrd.Sum(c => c.Credit_Movement)) - (FinalGrd.Sum(c => c.InDebt_Movement)) : (FinalGrd.FirstOrDefault().IndebtBalance) + (FinalGrd.Sum(c => c.InDebt_Movement)) - (FinalGrd.Sum(c => c.Credit_Movement)); if (sub_Account.BType == "مدين") { Account_Operations = new AccountOperationsGrd() { CreditBalance = FinalGrd.Sum(g => g.CreditBalance), Credit_Movement = FinalGrd.Sum(g => g.Credit_Movement), IndebtBalance = FinalGrd.Sum(g => g.IndebtBalance), InDebt_Movement = FinalGrd.Sum(g => g.InDebt_Movement), OperationID = 0, Description = AccountDropID.SelectedItem.Text, OperationDate = FinalGrd.LastOrDefault().OperationDate, ABalance = float.Parse(sub_Account.ABalance.ToString()), LastBalance = lastBalance }; } else { Account_Operations = new AccountOperationsGrd() { CreditBalance = FinalGrd.Sum(g => g.CreditBalance), Credit_Movement = FinalGrd.Sum(g => g.Credit_Movement), IndebtBalance = FinalGrd.Sum(g => g.IndebtBalance), InDebt_Movement = FinalGrd.Sum(g => g.InDebt_Movement), OperationID = 0, Description = AccountDropID.SelectedItem.Text, OperationDate = FinalGrd.LastOrDefault().OperationDate, ABalance = -float.Parse(sub_Account.ABalance.ToString()), LastBalance = lastBalance }; } FinalGrd.Clear(); FinalGrd.Add(Account_Operations); FinalGrd1.Add(Account_Operations); AccountGrd.DataSource = FinalGrd1; //Account_Operations_List.Where(o=>o.OperationDate >= DateTime.Parse(FromDateTxt.Text) & o.OperationDate <= DateTime.Parse(ToDateTxt.Text)); AccountGrd.DataBind(); }
protected void SaerchBtn_Click(object sender, EventArgs e) { RsltTxt.Text = ""; SaveBtn.Visible = true; khazna_Moved = new KhznaMoved(); entry = new Entry(); EntryGrd_List = new List <EntryGrd>(); //entry.maxid(); int maxid = (int)db.Entry.ToList().Max(o => o.EntryID) + 1; //entry.MoveID; Khazna_Moved_List = new List <KhznaMoved>(); //Khazna_Moved_List = khazna_Moved.GetAllKhznaMovedByKhaznaIDAndStateAndDate( // int.Parse(AccountDropID.SelectedValue), // 1, ToDateTxt.Text); Khazna_Moved_List = db.KhznaMoved.ToList().Where(o => o.AccountID == int.Parse(AccountDropID.SelectedValue) & o.state == true & o.Date <= ExtendedMethod.FormatDate(ToDateTxt.Text)).ToList(); int i = 0; foreach (var move in Khazna_Moved_List) { if (i == 0) { if (move.EntryState == false) { SaveBtn.Enabled = true; i++; } else { SaveBtn.Enabled = false; } } EntryGrd_List.Add(new EntryGrd() { EntryID = (int)move.EntryID, EntryState = (bool)move.EntryState, Description = move.Description, ID = move.ID, Value = float.Parse(move.Value.ToString()), SubID = int.Parse(move.AccountID.ToString()), }); } NewEntryTxtID.Text = maxid.ToString();//entry.MoveID.ToString(); EntryGrdV.DataSource = EntryGrd_List; EntryGrdV.DataBind(); }
public void Calc_Operation() { attemptValue = 0; Account = new SubAccount(); Khazna_Moved_List = new List <Entry>(); Khazna_Moved = new Entry(); Khazna_Moved_List = db.Entry.ToList().Where(o => o.SubAccount_id == int.Parse(AccountDropID.SelectedValue) & ( o.Date >= ExtendedMethod.FormatDate(FromDateTxt.Text) & o.Date <= ExtendedMethod.FormatDate(ToDateTxt.Text))).ToList();// Khazna_Moved.GetEntry_ByAccountIDByDate( // int.Parse(AccountDropID.SelectedValue), FromDateTxt.Text, ToDateTxt.Text); SubAccount sub_Account = new SubAccount(); sub_Account = db.SubAccount.ToList().FirstOrDefault(o => o.ID == int.Parse(AccountDropID.SelectedValue)); // sub_Account.GetSubAccount_ByID(int.Parse(AccountDropID.SelectedValue)).ElementAtOrDefault(0); float Account_Sum = float.Parse(sub_Account.ABalance.ToString()); Account_Operations = new AccountOperationsGrd(); AccountOperations_List = new List <AccountOperationsGrd>(); Account_Mony_Operations_List = new List <Entry>(); Account_Operations_List = new List <AccountOperationsGrd>(); List <AccountOperationsGrd> FinalGrd = new List <AccountOperationsGrd>(); List <AccountOperationsGrd> LastGrd = new List <AccountOperationsGrd>(); // DateTime.Parse(operation.Date.ToString()).Year //DateTime RD= DateTime.ParseExact(sub_Account.RegisterDate.ToString(), "yyyy-MM-dd", null); if (sub_Account.BType == "دائن") { FinalGrd.Add(new AccountOperationsGrd() { OperationID = 0, OperationDate = (DateTime)sub_Account.RegisterDate, CreditBalance = float.Parse(sub_Account.ABalance.ToString()), Credit_Movement = 0, IndebtBalance = 0, InDebt_Movement = 0, Description = "رصيد افتتاحى", State = sub_Account.BType }); } else { FinalGrd.Add(new AccountOperationsGrd() { OperationID = 0, OperationDate = (DateTime)sub_Account.RegisterDate, CreditBalance = 0, Credit_Movement = 0, IndebtBalance = float.Parse(sub_Account.ABalance.ToString()), InDebt_Movement = 0, Description = "رصيد افتتاحى", State = sub_Account.BType }); } // LastGrd.Add(FinalGrd[0]); //كل العمليات مع الخزنة الخاصة بaccount foreach (var Khazna in Khazna_Moved_List) { Account_Mony_Operations_List.Add(new Entry { ID = (int)Khazna.EntryID, status = Khazna.status, value = Khazna.value, description = Khazna.description, SubAccount_id = Khazna.SubAccount_id, Date = Khazna.Date }); } // Account_Mony_Operations_List.OrderBy(a => a.Date); //Concatination////////////////////////////////////////////////////////////////////////////////////////////////////////// ConcatenationLists(Account_Mony_Operations_List, Account_Operations_List, Account_Sum); //الشغل على Account_Operations_List int i = 1; Account_Operations_List = Account_Operations_List.OrderBy(o => o.OperationDate).ToList(); attemptValue = FinalGrd[0].State == "دائن" ? FinalGrd[0].CreditBalance : FinalGrd[0].IndebtBalance; string CurrentState = ""; foreach (var operation in Account_Operations_List) { //CurrentState = FinalGrd[i - 1].State == "مدين" ? Math.Sign(attemptValue + operation.InDebt_Movement - operation.Credit_Movement) >= 0 ? "مدين" : "دائن" : // Math.Sign(attemptValue + operation.Credit_Movement- operation.InDebt_Movement) >= 0 ? "دائن" : "مدين"; if (FinalGrd[i - 1].State == "مدين") { if (operation.InDebt_Movement > 0) { attemptValue = Math.Abs(attemptValue + operation.InDebt_Movement - operation.Credit_Movement); if (attemptValue > 0) { CurrentState = "مدين"; } else { CurrentState = "دائن"; } } else { attemptValue = (attemptValue - operation.Credit_Movement + operation.InDebt_Movement); if (attemptValue > 0) { CurrentState = "مدين"; } else { CurrentState = "دائن"; attemptValue = -attemptValue; } } } else { if (operation.Credit_Movement > 0) { attemptValue = Math.Abs(attemptValue + operation.Credit_Movement - operation.InDebt_Movement); if (attemptValue > 0) { CurrentState = "دائن"; } else { CurrentState = "مدين"; } } else { attemptValue = (attemptValue - operation.InDebt_Movement + operation.Credit_Movement); if (attemptValue > 0) { CurrentState = "دائن"; } else { CurrentState = "مدين"; attemptValue = -attemptValue; } } } if (CurrentState == "دائن") { FinalGrd.Add(new AccountOperationsGrd() { CreditBalance = attemptValue, Credit_Movement = operation.Credit_Movement, IndebtBalance = operation.IndebtBalance, InDebt_Movement = operation.InDebt_Movement, Description = operation.Description, OperationDate = operation.OperationDate, OperationID = operation.OperationID, State = "دائن" }); } else { //if (operation.InDebt_Movement > 0) //{ // attemptValue = Math.Abs(attemptValue + operation.InDebt_Movement - operation.Credit_Movement); //} //else //{ // attemptValue = Math.Abs(attemptValue + operation.Credit_Movement - operation.InDebt_Movement); //} FinalGrd.Add(new AccountOperationsGrd() { CreditBalance = operation.CreditBalance, Credit_Movement = operation.Credit_Movement, IndebtBalance = attemptValue,// operation.IndebtBalance, InDebt_Movement = operation.InDebt_Movement, Description = operation.Description, OperationDate = operation.OperationDate, OperationID = operation.OperationID, State = "مدين" }); } i++; } /////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////// // Account_Operations_List = Account_Operations_List.OrderBy(o => o.OperationDate).ToList(); string fromdate = ReformateDateFromPicker(FromDateTxt.Text); //DateTime.Parse(FromDateTxt.Text).Year + "-" + DateTime.Parse(FromDateTxt.Text).Month + "-" + DateTime.Parse(FromDateTxt.Text).Day; string Todate = ReformateDateFromPicker(ToDateTxt.Text); //DateTime.Parse(ToDateTxt.Text).Year + "-" + DateTime.Parse(ToDateTxt.Text).Month + "-" + DateTime.Parse(ToDateTxt.Text).Day; LastGrd.Add(FinalGrd.Where(o => o.OperationDate < ExtendedMethod.FormatDate(fromdate)).LastOrDefault()); if (LastGrd.Last() == null) { LastGrd.Remove(LastGrd.Last()); } LastGrd.AddRange(FinalGrd.Where(o => o.OperationDate >= ExtendedMethod.FormatDate(fromdate) & o.OperationDate <= ExtendedMethod.FormatDate(Todate))); AccountGrd.DataSource = LastGrd;// FinalGrd.Where(o => o.OperationDate < DateTime.Parse(fromdate)).LastOrDefault() && o.OperationDate >= DateTime.Parse(fromdate) & o.OperationDate <= DateTime.Parse(Todate) ); //Account_Operations_List.Where(o=>o.OperationDate >= DateTime.Parse(FromDateTxt.Text) & o.OperationDate <= DateTime.Parse(ToDateTxt.Text)); AccountGrd.DataBind(); }
public void Calc_Operation() { attemptValue = 0; Account = new SubAccount(); Khazna_Moved_List = new List <KhznaMoved>(); Bank_Moved_List = new List <BankMoved>(); Purchase_Invoice_List = new List <PurchaseInvoice>(); Khazna_Moved = new KhznaMoved(); Bank_Moved = new BankMoved(); Purchase_Invoice = new PurchaseInvoice(); // Khazna_Moved_List = Khazna_Moved.GetKhznaMoved_ByAccountIDByDate(int.Parse(AccountDropID.SelectedValue),FromDateTxt.Text,ToDateTxt.Text); // Bank_Moved_List = Bank_Moved.BankMoved_Between_Date_ForAccount(FromDateTxt.Text,ToDateTxt.Text, int.Parse(AccountDropID.SelectedValue)); Khazna_Moved_List = db.KhznaMoved.ToList().Where(o => o.AccountID == int.Parse(AccountDropID.SelectedValue)).ToList(); // Khazna_Moved_List = Khazna_Moved.GetKhznaMoved_ByAccountID(int.Parse(AccountDropID.SelectedValue)); Bank_Moved_List = db.BankMoved.ToList().Where(o => o.AccountID == int.Parse(AccountDropID.SelectedValue)).ToList(); Purchase_Invoice_List = db.PurchaseInvoice.ToList().Where(p => p.SubAccountId == int.Parse(AccountDropID.SelectedValue)).ToList(); //Purchase_Invoice.GetPurchaseInvoiceBySubID(int.Parse(AccountDropID.SelectedValue)); SubAccount sub_Account = new SubAccount(); sub_Account = db.SubAccount.ToList().FirstOrDefault(s => s.ID == int.Parse(AccountDropID.SelectedValue));// sub_Account.GetSubAccount_ByID(int.Parse(AccountDropID.SelectedValue)).ElementAtOrDefault(0); float Account_Sum = float.Parse(sub_Account.ABalance.ToString()); Account_Operations = new AccountOperationsGrd(); AccountOperations_List = new List <AccountOperationsGrd>(); Account_Mony_Operations_List = new List <KhznaMoved>(); Account_Operations_List = new List <AccountOperationsGrd>(); List <AccountOperationsGrd> FinalGrd = new List <AccountOperationsGrd>(); List <AccountOperationsGrd> LastGrd = new List <AccountOperationsGrd>(); // DateTime.Parse(operation.Date.ToString()).Year //DateTime RD= DateTime.ParseExact(sub_Account.RegisterDate.ToString(), "yyyy-MM-dd", null); if (sub_Account.BType == "دائن") { FinalGrd.Add(new AccountOperationsGrd() { OperationID = 0, OperationDate = (DateTime)sub_Account.RegisterDate, CreditBalance = float.Parse(sub_Account.ABalance.ToString()), Credit_Movement = 0, IndebtBalance = 0, InDebt_Movement = 0, Description = "رصيد افتتاحى", State = sub_Account.BType }); } else { FinalGrd.Add(new AccountOperationsGrd() { OperationID = 0, OperationDate = (DateTime)sub_Account.RegisterDate, CreditBalance = 0, Credit_Movement = 0, IndebtBalance = float.Parse(sub_Account.ABalance.ToString()), InDebt_Movement = 0, Description = "رصيد افتتاحى", State = sub_Account.BType }); } // LastGrd.Add(FinalGrd[0]); //كل العمليات مع الخزنة الخاصة بaccount foreach (var Khazna in Khazna_Moved_List) { Account_Mony_Operations_List.Add(new KhznaMoved { ID = Khazna.ID, state = Khazna.state == true ? false : true, Value = Khazna.Value, Description = Khazna.Description, AccountID = Khazna.AccountID, Date = Khazna.Date }); } //كل العمليات الواقعة على التعاملات البنكية foreach (var bank in Bank_Moved_List) { Account_Mony_Operations_List.Add(new KhznaMoved { ID = bank.ID, state = bank.state == true ? false : true, Value = bank.Value, Description = bank.Description, AccountID = bank.AccountID, Date = bank.Date }); } //فواتير الشراء foreach (var Pur in Purchase_Invoice_List) { Account_Mony_Operations_List.Add(new KhznaMoved { ID = int.Parse(Pur.Id), state = (bool)Pur.PurchaseType, Value = decimal.Parse(Pur.Total.ToString()), Description = Pur.PurchaseType == true?"شراء":"مرتجع شراء", AccountID = Pur.SubAccountId, Date = DateTime.Parse(Pur.InvoiceDate.ToString(), CultureInfo.CreateSpecificCulture("ar-EG")) }); } List <TransportCommand> TransportComandList = new List <TransportCommand>(); TransportComandList = db.TransportCommand.ToList(); //اوامر النقل foreach (var Pur in TransportComandList) { Account_Mony_Operations_List.Add(new KhznaMoved { ID = Pur.Id, state = true, Value = decimal.Parse(Pur.TotalTransportPrice.ToString()), Description = "امر نقل", AccountID = Pur.SubAccVendorId, Date = ExtendedMethod.FormatDate(ExtendedMethod.ParseDateToString(DateTime.Parse(Pur.TransportCommandTime.ToString()))) }); } // Account_Mony_Operations_List.OrderBy(a => a.Date); //Concatination////////////////////////////////////////////////////////////////////////////////////////////////////////// ConcatenationLists(Account_Mony_Operations_List, Account_Operations_List, Account_Sum); //الشغل على Account_Operations_List int i = 1; Account_Operations_List = Account_Operations_List.OrderBy(o => o.OperationDate).ToList(); attemptValue = FinalGrd[0].State == "دائن" ? FinalGrd[0].CreditBalance : FinalGrd[0].IndebtBalance; string CurrentState = ""; foreach (var operation in Account_Operations_List) { //CurrentState = FinalGrd[i - 1].State == "مدين" ? Math.Sign(attemptValue + operation.InDebt_Movement - operation.Credit_Movement) >= 0 ? "مدين" : "دائن" : // Math.Sign(attemptValue + operation.Credit_Movement- operation.InDebt_Movement) >= 0 ? "دائن" : "مدين"; if (FinalGrd[i - 1].State == "مدين") { if (operation.InDebt_Movement > 0) { attemptValue = Math.Abs(attemptValue + operation.InDebt_Movement - operation.Credit_Movement); if (attemptValue > 0) { CurrentState = "مدين"; } else { CurrentState = "دائن"; } } else { attemptValue = (attemptValue - operation.Credit_Movement + operation.InDebt_Movement); if (attemptValue > 0) { CurrentState = "مدين"; } else { CurrentState = "دائن"; attemptValue = -attemptValue; } } } else { if (operation.Credit_Movement > 0) { attemptValue = Math.Abs(attemptValue + operation.Credit_Movement - operation.InDebt_Movement); if (attemptValue > 0) { CurrentState = "دائن"; } else { CurrentState = "مدين"; } } else { attemptValue = (attemptValue - operation.InDebt_Movement + operation.Credit_Movement); if (attemptValue > 0) { CurrentState = "دائن"; } else { CurrentState = "مدين"; attemptValue = -attemptValue; } } } if (CurrentState == "دائن") { FinalGrd.Add(new AccountOperationsGrd() { CreditBalance = attemptValue, Credit_Movement = operation.Credit_Movement, IndebtBalance = operation.IndebtBalance, InDebt_Movement = operation.InDebt_Movement, Description = operation.Description, OperationDate = operation.OperationDate, OperationID = operation.OperationID, State = "دائن" }); } else { //if (operation.InDebt_Movement > 0) //{ // attemptValue = Math.Abs(attemptValue + operation.InDebt_Movement - operation.Credit_Movement); //} //else //{ // attemptValue = Math.Abs(attemptValue + operation.Credit_Movement - operation.InDebt_Movement); //} FinalGrd.Add(new AccountOperationsGrd() { CreditBalance = operation.CreditBalance, Credit_Movement = operation.Credit_Movement, IndebtBalance = attemptValue,// operation.IndebtBalance, InDebt_Movement = operation.InDebt_Movement, Description = operation.Description, OperationDate = operation.OperationDate, OperationID = operation.OperationID, State = "مدين" }); } i++; } /////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////// string fromdate = ReformateDateFromPicker(FromDateTxt.Text); // DateTime.Parse(FromDateTxt.Text).Year + "-" + DateTime.Parse(FromDateTxt.Text).Month + "-" + DateTime.Parse(FromDateTxt.Text).Day; string Todate = ReformateDateFromPicker(ToDateTxt.Text); //DateTime.Parse(ToDateTxt.Text).Year + "-" + DateTime.Parse(ToDateTxt.Text).Month + "-" + DateTime.Parse(ToDateTxt.Text).Day; var mydate = DateTime.Parse(fromdate, CultureInfo.CreateSpecificCulture("ar-EG")); var mydateTo = DateTime.Parse(Todate, CultureInfo.CreateSpecificCulture("ar-EG")); LastGrd.Add(FinalGrd.Where(o => o.OperationDate < mydate).LastOrDefault()); if (LastGrd.Last() == null) { LastGrd.Remove(LastGrd.Last()); } LastGrd.AddRange(FinalGrd.Where(o => o.OperationDate >= mydate & o.OperationDate <= mydateTo)); AccountGrd.DataSource = LastGrd;// FinalGrd.Where(o => o.OperationDate < DateTime.Parse(fromdate)).LastOrDefault() && o.OperationDate >= DateTime.Parse(fromdate) & o.OperationDate <= DateTime.Parse(Todate) ); //Account_Operations_List.Where(o=>o.OperationDate >= DateTime.Parse(FromDateTxt.Text) & o.OperationDate <= DateTime.Parse(ToDateTxt.Text)); AccountGrd.DataBind(); GridView1.DataSource = LastGrd; GridView1.DataBind(); Textbox1.Text = FromDateTxt.Text; Textbox2.Text = ToDateTxt.Text; Dropdownlist1.Text = AccountDropID.SelectedItem.Text; }