protected void DiaryGrd_RowDeleting(object sender, GridViewDeleteEventArgs e) { Label rowindx = (Label)DiaryGrd.Rows[e.RowIndex].FindControl("RowNoLbl"); Diar_Grd_List.Remove(Diar_Grd_List.Where(o => o.RecordID == int.Parse(rowindx.Text)).ElementAtOrDefault(0)); DiaryGrd.DataSource = Diar_Grd_List; DiaryGrd.DataBind(); }
protected void addRowBtn_Click(object sender, EventArgs e) { if (AccountNameDrop.Items.Count > 0 && CreditTxt.Text != "" && Indebt_BalanceTxt.Text != "") { _entry = new Entry(); Diary_Entry_obj = new DiaryEntrGrd(); if (EditFalg == false) { Diary_Entry_obj.RecordID = IncrementalID; } else { int RecordID = (int)db.Entry.ToList().Where(o => o.EntryID == int.Parse(EntryNoTxt.Text)).ToList().Max(r => r.RecordID) + 1; //_entry.maxRecordID((int.Parse(EntryNoTxt.Text))); Diary_Entry_obj.RecordID = RecordID; } Diary_Entry_obj.AccountNO = int.Parse(AccountNameDrop.SelectedItem.Value); Diary_Entry_obj.AccountName = AccountNameDrop.SelectedItem.Text; Diary_Entry_obj.CreditBalance = float.Parse(CreditTxt.Text); Diary_Entry_obj.IndebtBalance = float.Parse(Indebt_BalanceTxt.Text); sum1credit += float.Parse(CreditTxt.Text); sumIndebt += float.Parse(Indebt_BalanceTxt.Text); Diary_Entry_obj.description = DesTxt.Text; try { Diar_Grd_List.Where(o => o.AccountNO == Diary_Entry_obj.AccountNO).ElementAt(0); } catch (Exception ex) { Diar_Grd_List.Add(Diary_Entry_obj); } DiaryGrd.DataSource = Diar_Grd_List; DiaryGrd.DataBind(); AccountNameDrop.SelectedIndex = 0; CreditTxt.Text = ""; Indebt_BalanceTxt.Text = ""; DesTxt.Text = ""; DescTxt.Text = ""; CreditTxt.Enabled = true; Indebt_BalanceTxt.Enabled = true; AccountNOTxt.Text = ""; IncrementalID++; DiaryGrd.FooterRow.Cells[4].Text = sum1credit.ToString(); DiaryGrd.FooterRow.Cells[3].Text = sumIndebt.ToString(); } else { AddError.Text = "من فضلك ادخل جميع القيم"; AddError.ForeColor = System.Drawing.Color.Red; } SaveBtn.Enabled = true; }
protected void AccountNameDrop_SelectedIndexChanged(object sender, EventArgs e) { AccountNOTxt.Text = AccountNameDrop.SelectedItem.Value; Indebt_BalanceTxt.Text = ""; Indebt_BalanceTxt.Enabled = true; CreditTxt.Text = ""; CreditTxt.Enabled = true; DiaryGrd.DataSource = Diar_Grd_List; DiaryGrd.DataBind(); }
protected void DiaryGrd_RowUpdating(object sender, GridViewUpdateEventArgs e) { GridViewRow row = (GridViewRow)DiaryGrd.Rows[e.RowIndex]; TextBox DescriptionText = DiaryGrd.Rows[e.RowIndex].FindControl("DescriptionTxt") as TextBox; //(TextBox)row.Cells[1].Controls[0]; TextBox CreditTxt = DiaryGrd.Rows[e.RowIndex].FindControl("CreditBalanceTxt") as TextBox; //(TextBox)row.Cells[2].Controls[0]; TextBox IndebtTxt = DiaryGrd.Rows[e.RowIndex].FindControl("IndebtBalanceTxt") as TextBox; // (TextBox)row.Cells[3].Controls[0]; Label RowNoLbl = DiaryGrd.Rows[e.RowIndex].FindControl("RowNoLbl") as Label; //(TextBox)row.Cells[4].Controls[0]; Diar_Grd_List.Where(o => o.RecordID == int.Parse(RowNoLbl.Text)).ElementAtOrDefault(0).CreditBalance = float.Parse(CreditTxt.Text); Diar_Grd_List.Where(o => o.RecordID == int.Parse(RowNoLbl.Text)).ElementAtOrDefault(0).IndebtBalance = float.Parse(IndebtTxt.Text); Diar_Grd_List.Where(o => o.RecordID == int.Parse(RowNoLbl.Text)).ElementAtOrDefault(0).description = DescriptionText.Text; DiaryGrd.DataSource = Diar_Grd_List; DiaryGrd.DataBind(); DiaryGrd_RowCancelingEdit(sender, null); }
//Search By Entry ID public void SearchFn(int Entry_ID) { try { EditFalg = true; SaveBtn.Enabled = false; DeleteBtn.Enabled = true; _entry = new Entry(); Entry_List = new List <Entry>(); Entry_List = db.Entry.ToList().Where(en => en.EntryID == Entry_ID).ToList();// _entry.GetAllEntryByID(Entry_ID); EntryNoTxt.Text = Entry_ID.ToString(); DateTxt.Text = Entry_List.ElementAtOrDefault(0).Date.ToString(); DescTxt.Text = Entry_List.ElementAtOrDefault(0).description; Diar_Grd_List = new List <DiaryEntrGrd>(); float SumMaden = 0, SumDaan = 0; foreach (var ent in Entry_List) { float CreditVal = ent.status == "دائن" ? float.Parse(ent.value.ToString()) : 0; float IndebtVal = ent.status == "مدين" ? float.Parse(ent.value.ToString()) : 0; Diar_Grd_List.Add(new DiaryEntrGrd() { AccountNO = int.Parse(ent.SubAccount_id.ToString()), CreditBalance = CreditVal, IndebtBalance = IndebtVal, description = ent.description, RecordID = (int)ent.RecordID, AccountName = AccountNameDrop.Items.FindByValue(ent.SubAccount_id.ToString()).Text }); SumDaan += CreditVal; SumMaden += IndebtVal; } // Diar_Grd_List.OrderByDescending(o => o.IndebtBalance); DiaryGrd.DataSource = Diar_Grd_List; DiaryGrd.DataBind(); DiaryGrd.FooterRow.Cells[4].Text = SumDaan.ToString("#.00"); DiaryGrd.FooterRow.Cells[3].Text = SumMaden.ToString("#.00"); sum1credit = SumDaan; sumIndebt = SumMaden; } catch (Exception ex) { } }
public void Initialize_Page() { sum1credit = 0; sumIndebt = 0; DiaryGrd.DataSource = null; DiaryGrd.DataBind(); DeleteBtn.Enabled = false; SaveBtn.Enabled = false; Sub_Account = new SubAccount(); _entry = new Entry(); DateTxt.Text = DateTime.Now.Year + "-" + DateTime.Now.Month + "-" + DateTime.Now.Day; //AccountNameDrop.DataSource = Sub_Account.GetAllSub().ToList(); //AccountNameDrop.DataTextField = "name"; //AccountNameDrop.DataValueField = "id"; //AccountNameDrop.DataBind(); Main_Account = new MainAccount(); Main_Account_List = new List <MainAccount>(); Sub_Account = new SubAccount(); Dictionary <int, string> AccountsDictionary = new Dictionary <int, string>(); foreach (var M in db.MainAccount.ToList()) { AccountsDictionary.Add(int.Parse(M.ID.ToString()), M.name); } foreach (var S in db.SubAccount.ToList()) { AccountsDictionary.Add(int.Parse(S.ID.ToString()), S.name); } AccountNameDrop.DataSource = AccountsDictionary; AccountNameDrop.DataTextField = "Value"; AccountNameDrop.DataValueField = "Key"; AccountNameDrop.DataBind(); Diar_Grd_List = new List <DiaryEntrGrd>(); IncrementalID = 1; //_entry.maxid(); int MoveID = (int)db.Entry.ToList().Max(o => o.EntryID) + 1; EntryNoTxt.Text = MoveID.ToString(); DiaryGrd.DataSource = null; DiaryGrd.DataBind(); try { List <Entry> SearchList = new List <Entry>(); SearchList = db.Entry.ToList();// _entry.GetAllEntryID().ToList(); EntryNoForSearch.Items.Insert(0, new ListItem("اختر رقم القيد للبحث", String.Empty)); foreach (var item in SearchList) { EntryNoForSearch.Items.Add(new ListItem(item.EntryID.ToString(), item.EntryID.ToString())); } //EntryNoForSearch.DataSource = SearchList; EntryNoForSearch.DataTextField = "EntryID"; EntryNoForSearch.DataValueField = "EntryID"; EntryNoForSearch.DataBind(); } catch (Exception ex) { } DateTxt.Text = DateTime.Now.Year + "-" + DateTime.Now.Month + "-" + DateTime.Now.Day; NextBtn.Enabled = false; PrevBtn.Enabled = false; FirstBtn.Enabled = true; LastBtn.Enabled = true; EditFalg = false; }
protected void DiaryGrd_RowCancelingEdit(object sender, GridViewCancelEditEventArgs e) { DiaryGrd.EditIndex = -1; DiaryGrd.DataSource = Diar_Grd_List; DiaryGrd.DataBind(); }
protected void DiaryGrd_RowEditing(object sender, GridViewEditEventArgs e) { DiaryGrd.EditIndex = e.NewEditIndex; DiaryGrd.DataSource = Diar_Grd_List; DiaryGrd.DataBind(); }