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 MonyTypeDrop_SelectedIndexChanged(object sender, EventArgs e) { Sub_Account = new SubAccount(); if (MonyTypeDrop.SelectedIndex == 1) { FinancialPos_td.Visible = false; SolarRowID.Visible = false; EditFlag = false; Bank_Moved = new BankMoved(); int MoveID = db.BankMoved.ToList().Where(b => b.state == false).Max(o => o.ID) + 1; OperationID.Text = MoveID.ToString(); //من FromSubAccountsID.DataSource = db.SubAccount.ToList().Where(s => s.MainAccount_id != 1121).ToList();// Sub_Account.GetAllSubNotIncomsCheq(); //.Select(c => c.name); FromSubAccountsID.DataValueField = "ID"; FromSubAccountsID.DataTextField = "name"; FromSubAccountsID.DataBind(); ChecqRow.Visible = true; //BankNameRow.Visible = true; SarfDateRow.Visible = true; FromKhaznaRow.Visible = true; FromKhaznaDrop.DataSource = db.SubAccount.ToList().Where(s => s.MainAccount_id == 1105);// Sub_Account.GetSubAccount_ByUpID(1105/*1121*/); FromKhaznaDrop.DataValueField = "ID"; FromKhaznaDrop.DataTextField = "name"; FromKhaznaDrop.DataBind(); //ملأ ال Drop down list للبحث Bank_Moved_List_static = db.BankMoved.ToList().Where(b => b.state == true).ToList();// Bank_Moved.GetBankID_state(0); if (Bank_Moved_List_static.Count > 0) { MonyInSearchBtn.Enabled = true; MonyInsForSerachDrop.DataSource = Bank_Moved_List_static.Select(KM => KM.ID); MonyInsForSerachDrop.DataBind(); } else { MonyInSearchBtn.Enabled = false; } } else { 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 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(); }