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) { }
}
protected void Button3_Click(object sender, EventArgs e)
{
Response.Clear();
Response.Buffer = true;
Response.AddHeader("content-disposition", "attachment;filename=قيد يومية.xls");
Response.Charset = "";
Response.ContentType = "application/vnd.ms-excel";
{
using (StringWriter sw = new StringWriter())
{
HtmlTextWriter hw = new HtmlTextWriter(sw);
DiaryGrd.RenderControl(hw);
string style = "<style> .textmode { } </style>";
Response.Write(style);
Response.Output.Write(sw.ToString());
Response.Flush();
Response.End();
}
}
}
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();
}
