protected void edit_Command(object sender, CommandEventArgs e)
{
Driver temDriver = new Driver();
int index = Convert.ToInt32(e.CommandArgument);
if (SearchDriverList.Count > 0)
{
temDriver = SearchDriverList[index];
}
else
{
temDriver = DriverList[index];
}
try
{
IdHid.Value = temDriver.Id.ToString();
NameTxt.Text = temDriver.Name;
AddressTxt.Text = temDriver.Address;
PhoneTxt.Text = temDriver.phone;
licenseTxt.Text = temDriver.license;
LicenceDateTxt.Text = ExtendedMethod.ParseDateToString(DateTime.Parse(temDriver.LicenceDate.ToString()));
LicencePeriodTxt.Text = temDriver.LicencePeriod.ToString();
AlertPeriodTxt.Text = temDriver.AlertPeriod.ToString();
AddTrafDepListhtml.SelectedValue = temDriver.TrafficDepID.ToString();
}
catch (Exception Exec)
{
}
SearchDriverList = new List <Driver>();
UpdatePanel3.Update();
}
protected void edit_Command(object sender, CommandEventArgs e)
{
Cars temCar = new Cars();
int index = Convert.ToInt32(e.CommandArgument);
if (SearchCarsList.Count > 0)
{
temCar = SearchCarsList[index];
}
else
{
temCar = CarsList[index];
}
try
{
CarsIdHid.Value = temCar.id.ToString();
CarNoTxt.Text = temCar.CarNo;
LicenceNOTxt.Text = temCar.LicenceNO;
LicenceDateTxt.Text = ExtendedMethod.ParseDateToString(DateTime.Parse(temCar.LicenceDate.ToString()));
LicencePeriodTxt.Text = temCar.LicencePeriod.ToString();
AlertPeriodTxt.Text = temCar.AlertPeriod.ToString();
AddColorListhtml.SelectedValue = temCar.ColorId.ToString();
AddCityListhtml.SelectedValue = temCar.CityId.ToString();
AddCarTypeListhtml.SelectedValue = temCar.CarTypeId.ToString();
AddTrafDepListhtml.SelectedValue = temCar.TrafficDepID.ToString();
AddSupplierListhtml.SelectedValue = temCar.SubAccId.ToString();
}
catch (Exception Exec)
{
}
SearchCarsList = new List <Cars>();
UpdatePanel3.Update();
}
public void SearchFn(int AccountID)
{
EditFlag = true;
AddErrorTxt.Text = "";
Sub_Account = new SubAccount();
Sub_Account_List = new List <SubAccount>();
int level = 4;
Sub_Account = db.SubAccount.ToList().Where(s => s.ID == AccountID).FirstOrDefault(); // Sub_Account.GetSubAccount_ByID(AccountID).ElementAtOrDefault(0);
level = (int)Sub_Account.Level;
SubAccount Sub_Account1 = db.SubAccount.ToList().Where(s => s.ID == AccountID).FirstOrDefault(); // Sub_Account.GetSubAccount_ByID(AccountID).ElementAtOrDefault(0);
if (Sub_Account1 != null)
{
AccountNoForSearchDrop.SelectedValue = Sub_Account1.ID.ToString();
}
AccountIDTxt.Text = Sub_Account1.ID.ToString();
SubAccountManulID = int.Parse(AccountIDTxt.Text);
AccountNameTxt.Text = Sub_Account1.name;
DateTxt.Text = ExtendedMethod.ParseDateToString((DateTime)Sub_Account1.RegisterDate);
AccountStateDrop.SelectedValue = Sub_Account1.BType;
BalanceTxt.Text = Sub_Account1.ABalance.ToString();
Indx PersonalIndx = new Indx();
try
{
PersonalIndx = db.Indx.ToList().Where(i => i.Sub_ID == Int64.Parse(AccountIDTxt.Text)).FirstOrDefault();// PersonalIndx.GetIndx_BySubID(Int64.Parse(AccountIDTxt.Text)).FirstOrDefault();
if (PersonalIndx.ClientCategory != "")
{
ClientCategoryList.SelectedItem.Text = PersonalIndx.ClientCategory;
}
if (PersonalIndx.ClientType != "")
{
ClentTypelist.SelectedItem.Text = PersonalIndx.ClientType;
}
if (PersonalIndx.SalesUesrId.ToString() != "")
{
SalesUesrId.SelectedValue = PersonalIndx.SalesUesrId.ToString();
}
ResponsiblePersonName.Text = PersonalIndx.ResponsiblePersonName;
ResponsiblePersonPhone.Text = PersonalIndx.ResponsiblePersonPhone;
AnotherResponsiblePersonPhone.Text = PersonalIndx.AnotherResponsiblePersonPhone;
EmailTxt.Text = PersonalIndx.Email;;
Addess.Text = PersonalIndx.Address;
Sgl_TaxNO.Text = PersonalIndx.Sgl_TaxNO;
CommercialDocument.Text = PersonalIndx.CommercialDocument;
TaxDocument.Text = PersonalIndx.TaxDocument;
PersonalIndx.Sub_ID = Int64.Parse(AccountIDTxt.Text);
}
catch (Exception ex)
{
}
OldSubAccountManul = SubAccountManulID;
}
protected void edit_Command(object sender, CommandEventArgs e)
{
EditFlage = true;
//enable After Part Untill edit
After.Enabled = true;
DateAfter.Enabled = true;
AtHourAfter.Enabled = true;
//Disable Before Part Untill edit
Before.Enabled = false;
DateBefore.Enabled = false;
AtHourBefore.Enabled = false;
CarChangeRateOnDis temCarChangeRateOndis = new CarChangeRateOnDis();
int index = Convert.ToInt32(e.CommandArgument);
if (SearchCarChangeRateOnDisList.Count > 0)
{
temCarChangeRateOndis = SearchCarChangeRateOnDisList[index];
}
else
{
temCarChangeRateOndis = CarChangeRateOnDisList[index];
}
try
{
IdHid.Value = temCarChangeRateOndis.Id.ToString();
Description.Text = temCarChangeRateOndis.Description;
AddCarsListhtml.SelectedValue = temCarChangeRateOndis.CarId.ToString();
AddServicesListhtml.SelectedValue = temCarChangeRateOndis.ServiceId.ToString();
Before.Text = temCarChangeRateOndis.Before.ToString();
DateBefore.Text = ExtendedMethod.ParseDateToString(DateTime.Parse(temCarChangeRateOndis.DateBefore.ToString()));
AtHourBefore.Text = temCarChangeRateOndis.AtHourBefore;
After.Text = temCarChangeRateOndis.After.ToString();
DateAfter.Text = ExtendedMethod.ParseDateToString(DateTime.Parse(temCarChangeRateOndis.DateAfter.ToString()));
AtHourAfter.Text = temCarChangeRateOndis.AtHourAfter;
}
catch (Exception Exec)
{
}
SearchCarChangeRateOnDisList = new List <CarChangeRateOnDis>();
UpdatePanel3.Update();
}
public void SearchFn(int AccountID)
{
EditFlag = true;
AddErrorTxt.Text = "";
Sub_Account = new SubAccount();
Sub_Account_List = new List <SubAccount>();
int level = 4;
Sub_Account = db.SubAccount.ToList().Where(s => s.ID == AccountID).FirstOrDefault(); // Sub_Account.GetSubAccount_ByID(AccountID).ElementAtOrDefault(0);
level = (int)Sub_Account.Level;
SubAccount Sub_Account1 = db.SubAccount.ToList().Where(s => s.ID == AccountID).FirstOrDefault(); // Sub_Account.GetSubAccount_ByID(AccountID).ElementAtOrDefault(0);
if (Sub_Account1 != null)
{
AccountNoForSearchDrop.SelectedValue = Sub_Account1.ID.ToString();
}
AccountIDTxt.Text = Sub_Account1.ID.ToString();
SubAccountManulID = int.Parse(AccountIDTxt.Text);
AccountNameTxt.Text = Sub_Account1.name;
DateTxt.Text = ExtendedMethod.ParseDateToString((DateTime)Sub_Account1.RegisterDate);
AccountStateDrop.SelectedValue = Sub_Account1.BType;
BalanceTxt.Text = Sub_Account1.ABalance.ToString();
Indx PersonalIndx = new Indx();
try
{
PersonalIndx = db.Indx.ToList().Where(i => i.Sub_ID == Int64.Parse(AccountIDTxt.Text)).FirstOrDefault();// PersonalIndx.GetIndx_BySubID(Int64.Parse(AccountIDTxt.Text)).FirstOrDefault();
PersonalID.Text = PersonalIndx.PersonalID;
MobileNoTxt.Text = PersonalIndx.MobileNo;
EmailTxt.Text = PersonalIndx.Email;
Sgl_TaxNO.Text = PersonalIndx.Sgl_TaxNO;
TaxDocument.Text = PersonalIndx.TaxDocument;
maamoriaTxt.Text = PersonalIndx.Maamria;
Addess.Text = PersonalIndx.Address;
}
catch (Exception ex)
{
}
OldSubAccountManul = SubAccountManulID;
}
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 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;
}