public void Initializ_Page() { //financial Position initial FinancialPos.Checked = false; FinancialPosTypeList.Enabled = false; AddRelatednumList.Enabled = false; // Khzna_Moved = new KhznaMoved(); Sub_Account = new SubAccount(); MonyTypeDrop.SelectedIndex = 0; //رقم الاذن int MoveID = db.KhznaMoved.ToList().Where(o => o.state == false).Max(k => k.ID) + 1;// Khzna_Moved.maxid(0); OperationID.Enabled = false; OperationID.Text = MoveID.ToString(); //القيمة Value.Text = ""; //من FromSubAccountsID.DataSource = db.SubAccount.ToList().Where(o => o.MainAccount_id != 1103).ToList();// Sub_Account.GetAllSubNotKhazna();//.Select(c=>c.name); FromSubAccountsID.DataValueField = "ID"; FromSubAccountsID.DataTextField = "name"; FromSubAccountsID.DataBind(); //الى ToKhaznaDropRow.Visible = true; ToKhaznaDrop.DataSource = db.SubAccount.ToList().Where(o => o.MainAccount_id == 1103).ToList();//Sub_Account.GetSubAccount_ByUpID(1103); ToKhaznaDrop.DataValueField = "ID"; ToKhaznaDrop.DataTextField = "name"; ToKhaznaDrop.DataBind(); //الملاحظات DescTxt.Text = ""; //التاريخ //ReceivedDate.Text = DateTime.Now.Year + "-" + DateTime.Now.Month + "-" + DateTime.Now.Day; ChecqRow.Visible = false; //BankNameRow.Visible = false; SarfDateTxt.Text = DateTime.Now.Year + "-" + DateTime.Now.Month + "-" + DateTime.Now.Day; SarfDateRow.Visible = false; Khzna_Moved_List_static = db.KhznaMoved.ToList().Where(k => k.state == false).ToList();// Khzna_Moved.GetKhznaMovedBystate(0); if (Khzna_Moved_List_static.Count > 0) { MonyInSearchBtn.Enabled = true; MonyInsForSerachDrop.DataSource = Khzna_Moved_List_static.Select(KM => KM.ID); MonyInsForSerachDrop.DataBind(); } else { MonyInSearchBtn.Enabled = false; } DeleteMonyInBtn.Enabled = false; ChequeNoTxt.Text = ""; //BankDropID.SelectedIndex = 0; EditFlag = false; //CheckForPrivilage(); }
protected void SaveBtn_Click(object sender, EventArgs e) { Entry_List = new List <Entry>(); entry = new Entry(); khazna_Moved = new KhznaMoved(); foreach (var Daan in EntryGrd_List) { Entry_List.Add(new Entry() { SubAccount_id = int.Parse(Daan.SubID.ToString()), Date = DateTime.Parse(ToDateTxt.Text, CultureInfo.CreateSpecificCulture("ar-EG")), description = Daan.Description, status = "مدين", value = decimal.Parse(Daan.Value.ToString()), EntryID = int.Parse(NewEntryTxtID.Text), RecordID = Daan.ID, EntryType = "قيد مدفوعات" }); } Entry_List.Add(new Entry() { EntryID = int.Parse(NewEntryTxtID.Text), SubAccount_id = int.Parse(AccountDropID.SelectedValue), Date = DateTime.Parse(ToDateTxt.Text, CultureInfo.CreateSpecificCulture("ar-EG")), description = "قيد جديد", status = "دائن", value = decimal.Parse(TotalText.Text), RecordID = 0, EntryType = "قيد مدفوعات" }); foreach (var k in Khazna_Moved_List) { k.EntryState = true; k.EntryID = int.Parse(NewEntryTxtID.Text); k.LoginID = ExtendedMethod.LoginedUser.Id; } db.Entry.AddRange(Entry_List); //entry.Operations("Add", Entry_List); foreach (var en in Khazna_Moved_List) { en.LoginID = ExtendedMethod.LoginedUser.Id; db.KhznaMoved.AddOrUpdate(en); } db.SaveChanges(); RsltTxt.Text = "تمت الحفظ بنجاح"; RsltTxt.ForeColor = System.Drawing.Color.Green; Initialize_Page(); }
protected void SaerchBtn_Click(object sender, EventArgs e) { RsltTxt.Text = ""; SaveBtn.Visible = true; TotalSum = 0; 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>(); ToDateTxt.Text = ReformateDateFromPicker(ToDateTxt.Text); Khazna_Moved_List = db.KhznaMoved.ToList().Where(o => o.AccountID == int.Parse(AccountDropID.SelectedValue) & o.state == false & o.Date <= ExtendedMethod.FormatDate(ToDateTxt.Text)).ToList(); // khazna_Moved.GetAllKhznaMovedByKhaznaIDAndStateAndDate(int.Parse(AccountDropID.SelectedValue), // 0, ToDateTxt.Text); 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(); EntryGrdV.DataSource = EntryGrd_List; EntryGrdV.DataBind(); }
public void Calc_Operation() { attemptValue = 0; Account = new SubAccount(); Khazna_Moved_List = new List <KhznaMoved>(); Bank_Moved_List = new List <BankMoved>(); Sales_Order_List = new List <SalesInvoice>(); Khazna_Moved = new KhznaMoved(); Bank_Moved = new BankMoved(); Sale_Order = new SalesInvoice(); // 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.FinancialPostitionType == "عربة").ToList(); // Khazna_Moved.GetKhznaMoved_ByAccountID(int.Parse(AccountDropID.SelectedValue)); Bank_Moved_List = db.BankMoved.ToList().Where(o => o.FinancialPostitionType == "عربة").ToList(); //Bank_Moved.GetBankMoved_ByAccountID(int.Parse(AccountDropID.SelectedValue)); Sales_Order_List = db.SalesInvoice.ToList().Where(c => c.CarId == int.Parse(AccountDropID.SelectedValue)).ToList(); //Sale_Order.GetOrdersByCustID(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 = 0;//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 Sale in Sales_Order_List) { Account_Mony_Operations_List.Add(new KhznaMoved { ID = int.Parse(Sale.Id), state = bool.Parse(Sale.PurchaseType.ToString()), Value = decimal.Parse(Sale.Total.ToString()), Description = bool.Parse(Sale.PurchaseType.ToString()) ? "اذن صرف" : "مرتجع بضاعة", AccountID = Sale.CarId, Date = DateTime.Parse(Sale.InvoiceDate.ToString(), CultureInfo.CreateSpecificCulture("ar-EG")) }); } // 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(); FinalGrd.Add(Account_Operations_List[0]); Account_Operations_List.RemoveAt(0); 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 = "دائن", OperationType = operation.OperationType }); } 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 = "مدين", OperationType = operation.OperationType }); } i++; } /////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////// // Account_Operations_List = Account_Operations_List.OrderBy(o => o.OperationDate).ToList(); string fromdate = FromDateTxt.Text; //DateTime.Parse(FromDateTxt.Text).Year + "-" + DateTime.Parse(FromDateTxt.Text).Month + "-" + DateTime.Parse(FromDateTxt.Text).Day; string Todate = 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(); }
protected void delete_Command(object sender, CommandEventArgs e) { PurchInvDelist = new List <PurchaseInvoiceDetail>(); string deleted_index = ""; int index = Convert.ToInt32(e.CommandArgument); if (SearchPurchaseInvoiceList.Count > 0) { deleted_index = SearchPurchaseInvoiceList[index].Id; } else { deleted_index = PurchaseInvoiceList[index].Id; } try { var deletedItem = db.PurchaseInvoice.Where(SS => SS.Id == deleted_index).FirstOrDefault(); // deleting inner Details if (deletedItem != null) { //remove its Details PurchInvDelist = db.PurchaseInvoiceDetail.Where(PID => PID.PurchaseInvoiceID == deletedItem.Id).ToList(); for (int i = 0; i < PurchInvDelist.Count; i++) { try { db.PurchaseInvoiceDetail.Remove(PurchInvDelist[i]); db.SaveChanges(); } catch (Exception excpt) { ShowMessage("Something Wrong Will Deleting inner Details"); } } //remove its Movement string descript = "أذن استلام بضاعه لفتوره رقم" + deletedItem.Id; KhznaMoved myKhznaMoved = new KhznaMoved(); myKhznaMoved = db.KhznaMoved.Where(khz => khz.Description == descript).FirstOrDefault(); try { db.KhznaMoved.Remove(myKhznaMoved); db.SaveChanges(); } catch (Exception excpt) { ShowMessage("Something Wrong Will Khazna Movement"); } } else { ShowMessage("Can not Find This Item ... "); } // deleting all item db.PurchaseInvoice.Remove(deletedItem); db.SaveChanges(); //Bind New List After Deleting PurchaseInvoiceList = db.PurchaseInvoice.ToList(); BindGridList(); } catch (Exception excpt) { ShowMessage("Something Wrong Will Deleting"); } }
protected void DeleteBtn_Click(object sender, EventArgs e) { if (EditFalg == true) { if (Diar_Grd_List.Count > 0) { try { _entry = new Entry(); _entry = db.Entry.Where(en => en.EntryID == int.Parse(EntryNoTxt.Text)).FirstOrDefault();// _entry.GetAllEntryByID(int.Parse(EntryNoTxt.Text)).ElementAtOrDefault(0); Entry_List = new List <Entry>(); Entry_List.Add(_entry); db.Entry.RemoveRange(Entry_List); // _entry.Operations("Delete", Entry_List); if (_entry.EntryType == "قيد حر") { } else if (_entry.EntryType == "قيد مقبوضات") { KhznaMoved Khzna_Moved = new KhznaMoved(); List <KhznaMoved> KhznaMoved_List = new List <KhznaMoved>(); KhznaMoved_List = db.KhznaMoved.ToList().Where(o => o.state == false & o.EntryID == _entry.EntryID).ToList(); // Khzna_Moved.GetAllKhznaMovedByEntryIDAndState(_entry.EntryID, 0); foreach (var k in KhznaMoved_List) { k.EntryID = 0; k.EntryState = false; k.LoginID = ExtendedMethod.LoginedUser.Id; db.KhznaMoved.AddOrUpdate(k); } //Khzna_Moved.Operations("Edit", KhznaMoved_List); } else if (_entry.EntryType == "قيد مدفوعات") { KhznaMoved Khzna_Moved = new KhznaMoved(); List <KhznaMoved> KhznaMoved_List = new List <KhznaMoved>(); KhznaMoved_List = db.KhznaMoved.ToList().Where(o => o.state == true & o.EntryID == _entry.EntryID).ToList(); foreach (var k in KhznaMoved_List) { k.EntryID = 0; k.EntryState = false; k.LoginID = ExtendedMethod.LoginedUser.Id; db.KhznaMoved.AddOrUpdate(k); } // Khzna_Moved.Operations("Edit", KhznaMoved_List); } else if (_entry.EntryType == "قيد مقبوضات شيك") { BankMoved Bank_Moved = new BankMoved(); List <BankMoved> BankMoved_List = new List <BankMoved>(); BankMoved_List = db.BankMoved.ToList().Where(o => o.state == false & o.EntryID == _entry.EntryID).ToList(); foreach (var k in BankMoved_List) { k.EntryID = 0; k.EntryState = false; k.LoginID = ExtendedMethod.LoginedUser.Id; db.BankMoved.AddOrUpdate(k); } // Bank_Moved.Operations("Edit", BankMoved_List); } else if (_entry.EntryType == "قيد مدفوعات شيك") { BankMoved Bank_Moved = new BankMoved(); List <BankMoved> BankMoved_List = new List <BankMoved>(); BankMoved_List = db.BankMoved.ToList().Where(o => o.state == true & o.EntryID == _entry.EntryID).ToList(); foreach (var k in BankMoved_List) { k.EntryID = 0; k.EntryState = false; k.LoginID = ExtendedMethod.LoginedUser.Id; db.BankMoved.AddOrUpdate(k); } //Bank_Moved.Operations("Edit", BankMoved_List); } db.SaveChanges(); AddError.Text = "تم المسح بنجاح "; AddError.ForeColor = System.Drawing.Color.Green; } catch (Exception ex) { AddError.Text = "حدث خطأ لا يمكن المسح "; AddError.ForeColor = System.Drawing.Color.Red; } Initialize_Page(); } } }
//Get Edit Item With its Details protected void GetEditInvoice(string Id) { myPurchaseInvoice = new PurchaseInvoice(); PurchaseInvoiceDetailList = new List <PurchaseInvoiceDetail>(); //get Details List and bind it PurchaseInvoiceDetailList = db.PurchaseInvoiceDetail.Where(PID => PID.PurchaseInvoiceID == Id).ToList(); BindGridList(); //get Item and bind Its Values myPurchaseInvoice = db.PurchaseInvoice.Where(PI => PI.Id == Id).FirstOrDefault(); if (myPurchaseInvoice.Id != null) { InvoiceNo.Text = myPurchaseInvoice.Id.ToString(); } if (myPurchaseInvoice.InvoiceDate != null) { InvoiceDate.Text = myPurchaseInvoice.InvoiceDate.ToString(); } if (myPurchaseInvoice.SubAccountId != 0) { vendorsListtxt.SelectedValue = myPurchaseInvoice.SubAccountId.ToString(); } if (myPurchaseInvoice.PurchaseType == true) { Purchase.Checked = true; Discarded.Checked = false; } else { Discarded.Checked = true; Purchase.Checked = false; } // if (myPurchaseInvoice.Total != 0) { Total.Text = myPurchaseInvoice.Total.ToString(); } // get its moveMent if have string descript = "أذن استلام بضاعه لفتوره رقم" + myPurchaseInvoice.Id; myKhznaMoved = new KhznaMoved(); myKhznaMoved = db.KhznaMoved.Where(khz => khz.Description == descript).FirstOrDefault(); if (myKhznaMoved != null) { //make check Box True paymentMethod.Checked = true; //make payment Filed and Treasury Visible PaymentValueId.Visible = true; TreasuryId.Visible = true; if (TreasuryListtxt.Items.Count > 0) { TreasuryListtxt.Items.Clear(); } TreasuryListtxt.DataSource = db.SubAccount.Where(sub => sub.UpAccount == "1103").ToList(); TreasuryListtxt.DataValueField = "ID"; TreasuryListtxt.DataTextField = "name"; TreasuryListtxt.DataBind(); //Select treasury Which in movement TreasuryListtxt.SelectedValue = myKhznaMoved.TreasuryID.ToString(); PaymentValue.Text = myKhznaMoved.Value.ToString(); } VisitedAtEdit = true; }
//Save all invoice Part protected void MakeKhaznaMovement(PurchaseInvoice myPurInvo, string state) { string descript = "أذن استلام بضاعه لفتوره رقم" + myPurInvo.Id; myKhznaMoved = new KhznaMoved(); myKhznaMoved = db.KhznaMoved.Where(khz => khz.Description == descript).FirstOrDefault(); // h3mlo add if it add or edit if (myKhznaMoved == null) { myKhznaMoved = new KhznaMoved(); var newID = db.KhznaMoved.Where(kh => kh.state == true).Select(khm => khm.ID).Max(); myKhznaMoved.ID = newID + 1; myKhznaMoved.state = true; myKhznaMoved.Value = Convert.ToDecimal(myPurInvo.PaymentValue); myKhznaMoved.AccountID = Convert.ToInt64(myPurInvo.SubAccountId); myKhznaMoved.Description = "أذن استلام بضاعه لفتوره رقم" + myPurInvo.Id; myKhznaMoved.Date = DateTime.Parse(myPurInvo.InvoiceDate.ToString(), CultureInfo.CreateSpecificCulture("ar-EG")); myKhznaMoved.EntryState = false; myKhznaMoved.EntryID = 0; myKhznaMoved.TreasuryID = Convert.ToInt64(TreasuryListtxt.SelectedValue); try { db.KhznaMoved.Add(myKhznaMoved); db.SaveChanges(); } catch (Exception except) { ShowMessage("Something Wrong Will Adding Khzna Movement"); } } else { // if there are a movement and its state add Refuse it if (state == "add") { ShowMessage("there are Khzna Movement with the Same Description"); } else // if there are a movement and its state Edit update it { KhznaMoved tempKhznaMoved = new KhznaMoved(); tempKhznaMoved.ID = myKhznaMoved.ID; tempKhznaMoved.state = myKhznaMoved.state; tempKhznaMoved.Value = Convert.ToDecimal(myPurInvo.PaymentValue); tempKhznaMoved.AccountID = Convert.ToInt64(myPurInvo.SubAccountId); tempKhznaMoved.Description = "أذن استلام بضاعه لفتوره رقم" + myPurInvo.Id; tempKhznaMoved.Date = DateTime.Parse(myPurInvo.InvoiceDate.ToString(), CultureInfo.CreateSpecificCulture("ar-EG")); tempKhznaMoved.TreasuryID = Convert.ToInt64(TreasuryListtxt.SelectedValue); //Entry Update if Its he had made it لازم تجيب القيد وتغيره اوتو ماتك تاني هنا بناء علي التعديلات الي تمت tempKhznaMoved.EntryID = 0; // hnrg3 n3del hna tany 3la al 2ed lma ydaf tempKhznaMoved.EntryState = false; try { db.KhznaMoved.AddOrUpdate(tempKhznaMoved); db.SaveChanges(); } catch (Exception except) { ShowMessage("Something Wrong Will Updating Khzna Movement"); } } } }
//مسح protected void DeleteMonyInBtn_Click(object sender, EventArgs e) { Khzna_Moved = new KhznaMoved(); Bank_Moved = new BankMoved(); Bank_Moved_List = new List <BankMoved>(); Khzna_Moved_List = new List <KhznaMoved>(); Entry entry = new Entry(); List <Entry> Entry_List = new List <Entry>(); if (MonyTypeDrop.SelectedIndex == 0) //نقدى { Khzna_Moved = db.KhznaMoved.ToList().Where(k => k.ID == int.Parse(OperationID.Text) & k.state == false).ToList().FirstOrDefault(); // Khzna_Moved.GetKhznaMoved_ByID(int.Parse(OperationID.Text), 0).ElementAt(0); Khzna_Moved_List = new List <KhznaMoved>(); Khzna_Moved_List.Add(Khzna_Moved); if (Khzna_Moved.EntryState == true) { entry = db.Entry.ToList().Where(k => k.SubAccount_id == int.Parse(FromSubAccountsID.SelectedValue) & k.RecordID == Khzna_Moved.ID & k.status == "دائن" & k.EntryID == Khzna_Moved.EntryID).ToList().FirstOrDefault(); //entry.GetAllEntryByRecIDAndStateAndAccountID(int.Parse(FromSubAccountsID.SelectedValue), // Khzna_Moved.ID, Khzna_Moved.EntryID, "دائن").ElementAtOrDefault(0); ////Entry_List.Add(entry); //لانه اذن استلام فالخزنة مدينة Khzna = db.Entry.ToList().Where(b => b.status == "مدين" & b.SubAccount_id == int.Parse(ToKhaznaDrop.SelectedValue) & b.EntryID == Khzna_Moved.EntryID & b.RecordID == Khzna_Moved.ID).ToList().FirstOrDefault(); // entry.GetAllEntryByRecIDAndStateAndAccountID(int.Parse(ToKhaznaDrop.SelectedValue), // Khzna_Moved.ID, Khzna_Moved.EntryID, "مدين").ElementAtOrDefault(0); Khzna.value -= entry.value;//Khzna_Moved_List.Where(k => k.state == false & k.ID == entry.RecordID).ElementAtOrDefault(0).Value; if (Khzna.value == 0) { KhznaL.Add(Khzna); db.Entry.Remove(Khzna); // entry.Operations("Delete", KhznaL); } else { KhznaL.Add(Khzna); Entry_List.Add(entry); db.Entry.AddOrUpdate(Khzna); db.Entry.Remove(entry); // entry.Operations("Edit", KhznaL); // entry.Operations("Delete", Entry_List); } // Khzna_Moved.Operations("Delete", Khzna_Moved_List); db.KhznaMoved.RemoveRange(Khzna_Moved_List); db.SaveChanges(); AddErrorTxt.Text = "تم المسح"; } else { db.KhznaMoved.RemoveRange(Khzna_Moved_List); db.SaveChanges(); // Khzna_Moved.Operations("Delete", Khzna_Moved_List); Initializ_Page(); AddErrorTxt.Text = "تم المسح"; } } else//شيك { Bank_Moved = db.BankMoved.ToList().Where(b => b.ID == int.Parse(OperationID.Text) & b.state == false).ToList().FirstOrDefault();// Bank_Moved.GetBankMoving_ByID(int.Parse(OperationID.Text), 0).ElementAt(0); Bank_Moved_List = new List <BankMoved>(); Bank_Moved_List.Add(Bank_Moved); if (Bank_Moved.EntryState == true) { entry = db.Entry.ToList().Where(o => o.EntryID == Bank_Moved.EntryID & o.SubAccount_id == int.Parse(Bank_Moved.AccountID.ToString()) & o.status == "دائن" & o.RecordID == Bank_Moved.ID).ToList().FirstOrDefault(); // entry = entry.GetAllEntryByRecIDAndStateAndAccountID(int.Parse(FromSubAccountsID.SelectedValue), // Bank_Moved.ID, Bank_Moved.EntryID, "دائن").ElementAtOrDefault(0); //Entry_List.Add(entry); //لانه اذن استلام فالخزنة مدينة Bank = db.Entry.ToList().Where(o => o.EntryID == Bank_Moved.EntryID & o.SubAccount_id == int.Parse(ToKhaznaDrop.SelectedValue) & o.status == "مدين" & o.RecordID == Bank_Moved.ID).ToList().FirstOrDefault(); // Bank = entry.GetAllEntryByRecIDAndStateAndAccountID(int.Parse(ToKhaznaDrop.SelectedValue), // Bank_Moved.ID, Bank_Moved.EntryID, "مدين").ElementAtOrDefault(0); Bank.value -= entry.value;//Khzna_Moved_List.Where(k => k.state == false & k.ID == entry.RecordID).ElementAtOrDefault(0).Value; if (Bank.value == 0) { BankL.Add(Bank); db.Entry.RemoveRange(BankL); //entry.Operations("Delete", BankL); } else { BankL.Add(Bank); Entry_List.Add(entry); db.Entry.AddOrUpdate(Bank); db.Entry.RemoveRange(Entry_List); // entry.Operations("Edit", BankL); // entry.Operations("Delete", Entry_List); } db.BankMoved.RemoveRange(Bank_Moved_List); db.SaveChanges(); // Bank_Moved.Operations("Delete", Bank_Moved_List); AddErrorTxt.Text = "تم المسح"; } Initializ_Page(); } }
void searchFn(int ID) { EditFlag = true; Khzna_Moved = new KhznaMoved(); Bank_Moved = new BankMoved(); Sub_Account = new SubAccount(); OldEntry = new Entry(); if (MonyTypeDrop.SelectedIndex == 0) //نقدى { Khzna_Moved = db.KhznaMoved.Where(k => k.ID == ID & k.state == false).ToList().FirstOrDefault(); // Khzna_Moved.GetKhznaMoved_ByID(ID, 0).ElementAt(0); OperationID.Text = Khzna_Moved.ID.ToString(); Value.Text = String.Format("{0:0.00}", Khzna_Moved.Value); FromSubAccountsID.Items.Clear(); FromSubAccountsID.DataBind(); FromSubAccountsID.DataSource = db.SubAccount.ToList().Where(s => s.ID == int.Parse(Khzna_Moved.AccountID.ToString()));// Sub_Account.GetSubAccount_ByID(int.Parse(Khzna_Moved.AccountID.ToString())); FromSubAccountsID.DataValueField = "ID"; FromSubAccountsID.DataTextField = "name"; FromSubAccountsID.DataBind(); string khaznaNaname = ToKhaznaDrop.SelectedValue; //Sub_Account.GetSubAccount_ByID(int.Parse(Khzna_Moved.TreasuryID.ToString())).ElementAtOrDefault(0).name; ToKhaznaDrop.SelectedValue = khaznaNaname; DescTxt.Text = Khzna_Moved.Description; ReceivedDate.Text = ExtendedMethod.ParseDateToString((DateTime)Khzna_Moved.Date); if (Khzna_Moved.FinancialPostitionId != 0 && Khzna_Moved.FinancialPostitionType != "") { add_Edit_financialPosInfo((int)Khzna_Moved.FinancialPostitionId, Khzna_Moved.FinancialPostitionType); } DeleteMonyInBtn.Enabled = true; DeleteMonyInBtn.Enabled = true; OldKhznaID = int.Parse(ToKhaznaDrop.SelectedValue); OldEntry.Date = DateTime.Parse(ReceivedDate.Text, CultureInfo.CreateSpecificCulture("ar-EG")); OldEntry.description = DescTxt.Text; OldEntry.SubAccount_id = int.Parse(FromSubAccountsID.SelectedValue); OldValue = float.Parse(Value.Text); OldDescription = DescTxt.Text; } else//شيك { Bank_Moved = db.BankMoved.Where(b => b.ID == ID & b.state == false).ToList().FirstOrDefault();// Bank_Moved.GetBankMoving_ByID(ID, 0).ElementAt(0); if (Bank_Moved.FinancialPostitionId != 0 && Bank_Moved.FinancialPostitionType != "") { add_Edit_financialPosInfo((int)Bank_Moved.FinancialPostitionId, Bank_Moved.FinancialPostitionType); } OperationID.Text = Bank_Moved.ID.ToString(); Value.Text = String.Format("{0:0.00}", Bank_Moved.Value); //FromSubAccountsID.Items.Clear(); //FromSubAccountsID.DataBind(); //FromSubAccountsID.Items.Add(Sub_Account.GetSubAccount_ByID(int.Parse(Bank_Moved.AccountID.ToString())).ElementAt(0).name.ToString()); FromSubAccountsID.SelectedItem.Text = db.SubAccount.ToList().Where(s => s.ID == int.Parse(Bank_Moved.AccountID.ToString())).ToList().FirstOrDefault().name;// Sub_Account.GetSubAccount_ByID(int.Parse(Bank_Moved.AccountID.ToString())).ElementAt(0).name; DescTxt.Text = Bank_Moved.Description; ReceivedDate.Text = ExtendedMethod.ParseDateToString((DateTime)Khzna_Moved.Date); SarfDateTxt.Text = Bank_Moved.SarfDate.ToString(); DeleteMonyInBtn.Enabled = true; ChecqRow.Visible = true; //BankNameRow.Visible = true; ToKhaznaDrop.SelectedItem.Value = Bank_Moved.DocID.ToString(); ChequeNoTxt.Text = Bank_Moved.ChequeNo; //BankDropID.SelectedValue = Bank_Moved.BankName; DeleteMonyInBtn.Enabled = true; // OldDate = SarfDateTxt.Text; OldEntry.Date = DateTime.Parse(SarfDateTxt.Text, CultureInfo.CreateSpecificCulture("ar-EG")); OldCheq = ChequeNoTxt.Text; //OldBankName = BankDropID.SelectedValue; OldBankID = int.Parse(ToKhaznaDrop.SelectedValue); OldEntry.SubAccount_id = int.Parse(FromSubAccountsID.SelectedItem.Value); OldValue = float.Parse(Value.Text); OldDescription = DescTxt.Text; } }
public void AddMony() { ReceivedDate.Text = ReceivedDate.Text; Khzna_Moved = new KhznaMoved(); Sub_Account = new SubAccount(); Khzna_Moved_List = new List <KhznaMoved>(); Entry entry = new Entry(); List <Entry> Entry_List = new List <Entry>(); if (EditFlag == false) { Khzna_Moved.ID = int.Parse(OperationID.Text); Khzna_Moved.AccountID = int.Parse(FromSubAccountsID.SelectedValue); Khzna_Moved.Value = decimal.Parse(Value.Text); // Khzna_Moved.Date = DateTime.Parse(ReceivedDate.Text, CultureInfo.CreateSpecificCulture("ar-EG"));///////////DateTime.Parse(ReceivedDate.Text, CultureInfo.CreateSpecificCulture("ar-EG")); // Khzna_Moved.Description = DescTxt.Text; Khzna_Moved.TreasuryID = int.Parse(ToKhaznaDrop.SelectedValue); Khzna_Moved.state = false; if (FinancialPos.Checked == true) { Khzna_Moved.FinancialPostitionType = FinancialPosTypeList.SelectedValue; Khzna_Moved.FinancialPostitionId = int.Parse(AddRelatednumList.SelectedValue); } Khzna_Moved_List.Add(Khzna_Moved); db.KhznaMoved.Add(Khzna_Moved); db.SaveChanges(); // Khzna_Moved.Operations("Add", Khzna_Moved_List); AddErrorTxt.ForeColor = System.Drawing.Color.Green; AddErrorTxt.Text = "تمت الاضافة بنجاح"; } else { Khzna_Moved = db.KhznaMoved.ToList().Where(k => k.ID == int.Parse(OperationID.Text) & k.state == false).ToList().FirstOrDefault();// Khzna_Moved.GetKhznaMoved_ByID(int.Parse(OperationID.Text), 0).ElementAtOrDefault(0); if (Khzna_Moved.EntryState == true) { entry = db.Entry.ToList().Where(e => e.EntryID == Khzna_Moved.EntryID & e.SubAccount_id == int.Parse(FromSubAccountsID.SelectedValue) & e.status == "دائن" & e.RecordID == Khzna_Moved.ID).ToList().FirstOrDefault(); // entry.GetAllEntryByRecIDAndStateAndAccountID(int.Parse(FromSubAccountsID.SelectedValue), // Khzna_Moved.ID, Khzna_Moved.EntryID, "دائن").ElementAtOrDefault(0); ////Entry_List.Add(entry); //لانه اذن استلام فالخزنة مدينة Khzna = db.Entry.ToList().Where(e => e.EntryID == Khzna_Moved.EntryID & e.SubAccount_id == int.Parse(ToKhaznaDrop.SelectedValue) & e.status == "مدين" & e.RecordID == Khzna_Moved.ID).ToList().FirstOrDefault(); //entry.GetAllEntryByRecIDAndStateAndAccountID(int.Parse(ToKhaznaDrop.SelectedValue), // Khzna_Moved.ID, Khzna_Moved.EntryID, "مدين").ElementAtOrDefault(0); ////فى الحالة(تغير التاريخ او الخزنة) دى هنحذفه من القيود //وتغير حالة القيد فى الخزنة //ونقلل اجمالى القيد if (OldEntry.Date != DateTime.Parse(ReceivedDate.Text) || OldKhznaID != Khzna_Moved.TreasuryID || OldEntry.SubAccount_id != int.Parse(FromSubAccountsID.SelectedValue)) { Khzna_Moved_List.Add(Khzna_Moved); Khzna_Moved_List.Where(k => k.state == false & k.ID == entry.RecordID).ElementAtOrDefault(0).EntryState = false; Khzna_Moved_List.Where(k => k.state == false & k.ID == entry.RecordID).ElementAtOrDefault(0).EntryID = 0; Khzna.value -= entry.value;//Khzna_Moved_List.Where(k => k.state == false & k.ID == entry.RecordID).ElementAtOrDefault(0).Value; KhznaL.Add(Khzna); Entry_List.Add(entry); if (Khzna.value == 0) { KhznaL.Add(Khzna); db.Entry.Remove(Khzna); // entry.Operations("Delete", KhznaL); } else { //if (EditFlagPrev) //{ db.Entry.AddOrUpdate(Khzna); db.Entry.Remove(entry); db.SaveChanges(); // entry.Operations("Edit", KhznaL); // entry.Operations("Delete", Entry_List); //} } } else//غير كدا (اللى هو تغير القيمة اوالبيان او الحساب الدائن)هانعمل مجرد تعديل على القيد { entry.value = decimal.Parse(Value.Text);// Khzna_Moved.Value; entry.description = DescTxt.Text; Khzna.value -= decimal.Parse(OldValue.ToString()); Khzna.value += entry.value; // Khzna.value += Khzna_Moved_List.Where(k => k.state == false & k.ID == entry.RecordID).ElementAtOrDefault(0).Value; Entry_List.Add(Khzna); Entry_List.Add(entry); //if (EditFlagPrev) entry.LoginID = ExtendedMethod.LoginedUser.Id; db.Entry.AddOrUpdate(entry); db.SaveChanges(); // entry.Operations("Edit", Entry_List); } } Khzna_Moved.ID = int.Parse(OperationID.Text); Khzna_Moved.AccountID = int.Parse(FromSubAccountsID.SelectedValue); Khzna_Moved.Value = decimal.Parse(Value.Text); Khzna_Moved.Date = DateTime.Parse(ReceivedDate.Text, CultureInfo.CreateSpecificCulture("ar-EG"));/////////// Khzna_Moved.Description = DescTxt.Text; Khzna_Moved.TreasuryID = int.Parse(ToKhaznaDrop.SelectedValue); if (FinancialPos.Checked == true) { Khzna_Moved.FinancialPostitionType = FinancialPosTypeList.SelectedValue; Khzna_Moved.FinancialPostitionId = int.Parse(AddRelatednumList.SelectedValue); } Khzna_Moved.LoginID = ExtendedMethod.LoginedUser.Id; db.KhznaMoved.AddOrUpdate(Khzna_Moved); Khzna_Moved_List.Add(Khzna_Moved); db.SaveChanges(); //if (EditFlagPrev) //{ // Khzna_Moved.Operations("Edit", Khzna_Moved_List); AddErrorTxt.ForeColor = System.Drawing.Color.Green; AddErrorTxt.Text = "تمت التعديل بنجاح"; //} } }
public void AddMony() { // الي ليه استات ترو في الجدول بتاع ال خزنه هو الاستلام الصرف بياخد فلس ReceivedDate.Text = ReformateDateFromPicker(ReceivedDate.Text); Khzna_Moved = new KhznaMoved(); Sub_Account = new SubAccount(); Khzna_Moved_List = new List <KhznaMoved>(); Entry entry = new Entry(); List <Entry> Entry_List = new List <Entry>(); if (EditFlag == false) { var response = ""; Khzna_Moved.state = true; Khzna_Moved.ID = int.Parse(OperationID.Text); Khzna_Moved.Value = decimal.Parse(Value.Text); Khzna_Moved.AccountID = int.Parse(FromSubAccountsID.SelectedValue); Khzna_Moved.TreasuryID = int.Parse(FromKhaznaDrop.SelectedValue); Khzna_Moved.Description = DescTxt.Text; Khzna_Moved.Date = DateTime.Parse(ReceivedDate.Text, CultureInfo.CreateSpecificCulture("ar-EG")); /////////// if (FinancialPos.Checked == true) { Khzna_Moved.FinancialPostitionType = "سيارة"; Khzna_Moved.FinancialPostitionId = int.Parse(CarsListTxt.SelectedValue); response = AddSolarObject(Khzna_Moved.ID); if (!String.IsNullOrEmpty(response)) { try { Khzna_Moved_List.Add(Khzna_Moved); db.KhznaMoved.Add(Khzna_Moved); db.SaveChanges(); AddErrorTxt.ForeColor = System.Drawing.Color.Green; AddErrorTxt.Text = "تمت الاضافة بنجاح"; } catch (Exception e) { AddErrorTxt.ForeColor = System.Drawing.Color.Red; AddErrorTxt.Text = "حدث خطاء اثناء الاضافة لحركة الخزنه"; } } else { AddErrorTxt.ForeColor = System.Drawing.Color.Red; AddErrorTxt.Text = "Something Wrong will Adding Solar"; } } } else { Khzna_Moved = db.KhznaMoved.ToList().Where(k => k.ID == int.Parse(OperationID.Text) & k.state == true).FirstOrDefault();// Khzna_Moved.GetKhznaMoved_ByID(int.Parse(OperationID.Text), 1).ElementAtOrDefault(0); // هنا بيجدد القيود او بيعدلها if (Khzna_Moved.EntryState == true) { entry = db.Entry.ToList().Where(e => e.EntryID == Khzna_Moved.EntryID & e.SubAccount_id == int.Parse(FromSubAccountsID.SelectedValue) & e.status == "مدين" & e.RecordID == Khzna_Moved.ID).FirstOrDefault(); // entry = entry.GetAllEntryByRecIDAndStateAndAccountID(int.Parse(FromSubAccountsID.SelectedValue), // Khzna_Moved.ID, Khzna_Moved.EntryID, "مدين").ElementAtOrDefault(0); //Entry_List.Add(entry); //لانه اذن استلام فالخزنة مدينة Khzna = db.Entry.ToList().Where(e => e.EntryID == Khzna_Moved.EntryID & e.SubAccount_id == int.Parse(FromKhaznaDrop.SelectedValue) & e.status == "دائن" & e.RecordID == Khzna_Moved.ID).FirstOrDefault(); // Khzna = entry.GetAllEntryByRecIDAndStateAndAccountID(int.Parse(FromKhaznaDrop.SelectedValue), // Khzna_Moved.ID, Khzna_Moved.EntryID, "دائن").ElementAtOrDefault(0); //فى الحالة(تغير التاريخ او الخزنة) دى هنحذفه من القيود //وتغير حالة القيد فى الخزنة //ونقلل اجمالى القيد if (OldEntry.Date != DateTime.Parse(ReceivedDate.Text) || OldKhznaID != Khzna_Moved.TreasuryID || OldEntry.SubAccount_id != int.Parse(FromSubAccountsID.SelectedValue)) { Khzna_Moved_List.Add(Khzna_Moved); Khzna_Moved_List.Where(k => k.state == true & k.ID == entry.RecordID).ElementAtOrDefault(0).EntryState = false; Khzna_Moved_List.Where(k => k.state == true & k.ID == entry.RecordID).ElementAtOrDefault(0).EntryID = 0; Khzna.value -= entry.value;//Khzna_Moved_List.Where(k => k.state == false & k.ID == entry.RecordID).ElementAtOrDefault(0).Value; KhznaL.Add(Khzna); Entry_List.Add(entry); if (Khzna.value == 0) { KhznaL.Add(Khzna); db.Entry.Remove(Khzna); } else { //if (EditFlagPrev) //{ db.Entry.AddOrUpdate(Khzna); db.Entry.Remove(entry); db.SaveChanges(); //} } } else//غير كدا (اللى هو تغير القيمة اوالبيان او الحساب الدائن)هانعمل مجرد تعديل على القيد { entry.value = decimal.Parse(Value.Text);// Khzna_Moved.Value; entry.description = DescTxt.Text; Khzna.value -= decimal.Parse(OldValue.ToString()); Khzna.value += entry.value; // Khzna.value += Khzna_Moved_List.Where(k => k.state == false & k.ID == entry.RecordID).ElementAtOrDefault(0).Value; Entry_List.Add(Khzna); Entry_List.Add(entry); //if (EditFlagPrev) entry.LoginID = ExtendedMethod.LoginedUser.Id; db.Entry.AddOrUpdate(entry); db.SaveChanges(); } } // هنا بيتعمل مع الحركه بتاعت الخزنه والسولر Khzna_Moved.ID = int.Parse(OperationID.Text); Khzna_Moved.AccountID = int.Parse(FromSubAccountsID.SelectedValue); Khzna_Moved.Value = decimal.Parse(Value.Text); Khzna_Moved.Date = DateTime.Parse(ReceivedDate.Text, CultureInfo.CreateSpecificCulture("ar-EG"));/////////// Khzna_Moved.Description = DescTxt.Text; Khzna_Moved.TreasuryID = int.Parse(FromKhaznaDrop.SelectedValue); var response = ""; if (FinancialPos.Checked == true) { Khzna_Moved.FinancialPostitionType = "سيارة"; Khzna_Moved.FinancialPostitionId = int.Parse(CarsListTxt.SelectedValue); response = AddSolarObject(Khzna_Moved.ID); } if (!String.IsNullOrEmpty(response)) { try { Khzna_Moved.LoginID = ExtendedMethod.LoginedUser.Id; db.KhznaMoved.AddOrUpdate(Khzna_Moved); Khzna_Moved_List.Add(Khzna_Moved); db.SaveChanges(); AddErrorTxt.ForeColor = System.Drawing.Color.Green; AddErrorTxt.Text = "تمت التعديل بنجاح"; } catch (Exception e) { AddErrorTxt.ForeColor = System.Drawing.Color.Red; AddErrorTxt.Text = "حدث خطاء اثناء تعديل لحركة الخزنه"; } } else { AddErrorTxt.ForeColor = System.Drawing.Color.Red; AddErrorTxt.Text = "Something Wrong will Editing Solar"; } //Khzna_Moved_List.Add(Khzna_Moved); //if (EditFlagPrev) //{ //} } }
public void Initializ_Page() { // بخفي ال شيك بومكس بتاع مركز التكلفه خالص في الشيك FinancialPos_td.Visible = true; SolarRowID.Visible = true; // ReceivedDate.Text = DateTime.Now.Year + "-" + DateTime.Now.Month + "-" + DateTime.Now.Day; // CarsList = db.Cars.ToList(); CarsListTxt.DataSource = CarsList; CarsListTxt.DataValueField = "Id"; CarsListTxt.DataTextField = "CarNo"; CarsListTxt.DataBind(); // DriverList = db.Driver.ToList(); DriverListTxt.DataSource = DriverList; DriverListTxt.DataValueField = "Id"; DriverListTxt.DataTextField = "Name"; DriverListTxt.DataBind(); //financial Position initial FinancialPos.Checked = false; ClearSolarDiv(); Khzna_Moved = new KhznaMoved(); Sub_Account = new SubAccount(); MonyTypeDrop.SelectedIndex = 0; //رقم الاذن int MoveID = db.KhznaMoved.ToList().Where(o => o.state == true).Max(k => k.ID) + 1;// Khzna_Moved.maxid(0); //OperationID.Enabled = false; OperationID.Text = MoveID.ToString(); //القيمة Value.Text = ""; //من FromSubAccountsID.DataSource = db.SubAccount.ToList().Where(o => o.MainAccount_id != 1103).ToList();// Sub_Account.GetAllSubNotKhazna();//.Select(c=>c.name); FromSubAccountsID.DataValueField = "ID"; FromSubAccountsID.DataTextField = "name"; FromSubAccountsID.DataBind(); //الى FromKhaznaRow.Visible = true; FromKhaznaDrop.DataSource = db.SubAccount.ToList().Where(o => o.MainAccount_id == 1103).ToList();//Sub_Account.GetSubAccount_ByUpID(1103); FromKhaznaDrop.DataValueField = "ID"; FromKhaznaDrop.DataTextField = "name"; FromKhaznaDrop.DataBind(); //الملاحظات DescTxt.Text = ""; //التاريخ ReceivedDate.Text = ""; /*DateTime.Now.Year + "-" + DateTime.Now.Month + "-" + DateTime.Now.Day;*/ ChecqRow.Visible = false; // BankNameRow.Visible = false; SarfDateTxt.Text = DateTime.Now.Year + "-" + DateTime.Now.Month + "-" + DateTime.Now.Day; SarfDateRow.Visible = false; Khzna_Moved_List_static = db.KhznaMoved.ToList().Where(k => k.state == true).ToList();// Khzna_Moved.GetKhznaMovedBystate(0); if (Khzna_Moved_List_static.Count > 0) { MonyInSearchBtn.Enabled = true; MonyInsForSerachDrop.DataSource = Khzna_Moved_List_static.Select(KM => KM.ID); MonyInsForSerachDrop.DataBind(); } else { MonyInSearchBtn.Enabled = false; } DeleteMonyInBtn.Enabled = false; ChequeNoTxt.Text = ""; FromKhaznaDrop.SelectedIndex = 0; EditFlag = false; //CheckForPrivilage(); }
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; }