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();
}
