private void IUD()
{
string sql = "exec [SMS].[IUDPaymentDetails]";
List <string> lst = new List <string>();
this.EntityID = SelectedExpense.StaticID.ToString();
this.EntityType = "Expense";
this.PaymentType = SelectedExpense.StaticName.ToString();
//SelectedFees.StaticID.ToString();
this.TransType = "D";
//this.PaymentExpenseDate = ExpenseDate;
ExpenseDateStr = ExpenseDate.ToString("yyyy-MM-dd");
lst.Add(ID);
lst.Add(EntityID);
lst.Add(EntityType);
lst.Add(PaymentType);
lst.Add(TransType);
lst.Add(Amount);
lst.Add(Comments);
lst.Add(IUDFlag);
lst.Add(Schoolid);
lst.Add(AcademicYear);
lst.Add(ModeofPayment);
lst.Add(ChequeNo);
lst.Add(BankBranchDetails);
lst.Add(ExpenseDateStr);
lst.Add(string.Empty);
DataTable dtResult = DAL.Select(sql, lst);
GetExpenseDetails();
//GeneratePaymentReciept();
}
//Adding Repayment,Expenses and Liabilities
internal void RepaymentExpensesLiabilities()
{
//To skip the highlighted option
SkipButton?.Click();
System.Threading.Thread.Sleep(5000);
// Populating the data from Excel
ExcelLib.PopulateInCollection(Base.ExcelPath, "AddNewProperty");
OwnersSelect.Click();
System.Threading.Thread.Sleep(5000);
PropertiesSelect.Click();
ClickingAddNewProperty.Click();
//Value set for property page details
PropertyName.SendKeys(ExcelLib.ReadData(2, "Value"));
SearchAddress.SendKeys(ExcelLib.ReadData(33, "Value"));
System.Threading.Thread.Sleep(5000);
//Value set using google api
var address = Global.Driver.driver.FindElements(By.ClassName("pac-item"))[0];
address.Click();
TargetRent.SendKeys(ExcelLib.ReadData(14, "Value"));
LandArea.SendKeys(ExcelLib.ReadData(10, "Value"));
BedRooms.SendKeys(ExcelLib.ReadData(11, "Value"));
CarParks.SendKeys(ExcelLib.ReadData(12, "Value"));
Description.SendKeys(ExcelLib.ReadData(13, "Value"));
FloorArea.SendKeys(ExcelLib.ReadData(15, "Value"));
BathRooms.SendKeys(ExcelLib.ReadData(16, "Value"));
YearBuilt.SendKeys(ExcelLib.ReadData(9, "Value"));
NextButton.Click();
//Value set for financial details page
System.Threading.Thread.Sleep(2000);
PurchasePrice.SendKeys(ExcelLib.ReadData(17, "Value"));
HomeValue.SendKeys(ExcelLib.ReadData(18, "Value"));
Mortgage.SendKeys(ExcelLib.ReadData(19, "Value"));
//Adding repayment option
AddRepayment.Click();
RepaymentAmount.SendKeys(ExcelLib.ReadData(2, "AddRepaymentfieldValue"));
RepaymentStartDate.SendKeys(ExcelLib.ReadData(3, "AddRepaymentfieldValue"));
//Adding expenses option
AddExpense.Click();
ExpenseAmount.SendKeys(ExcelLib.ReadData(2, "AddExpensefieldValue"));
var ExpenseDescription = Global.Driver.driver.FindElement(By.ClassName("seven")).FindElement(By.ClassName("width")).FindElement(By.Id("Text1"));
ExpenseDescription.SendKeys(ExcelLib.ReadData(3, "AddExpensefieldValue"));
ExpenseDate.SendKeys(ExcelLib.ReadData(4, "AddExpensefieldValue"));
NextButton2.Click();
//Value set for financial details page
TenantEmail.SendKeys(ExcelLib.ReadData(20, "Value"));
FirstName.SendKeys(ExcelLib.ReadData(21, "Value"));
LastName.SendKeys(ExcelLib.ReadData(22, "Value"));
StartDate.SendKeys(ExcelLib.ReadData(23, "Value"));
EndDate.SendKeys(ExcelLib.ReadData(24, "Value"));
RentAmount.SendKeys(ExcelLib.ReadData(25, "Value"));
PaymentStartDate.SendKeys(ExcelLib.ReadData(26, "Value"));
//Adding liability option
NewLiability.Click();
Amount.SendKeys(ExcelLib.ReadData(2, "NewLiabilityFieldValue"));
Save.Click();
}
public async Task Add(ExpenseDate expenseDate)
{
if (expenseDate.Register.Id != null && expenseDate.Register.Id != Guid.Empty)
{
_context.Entry(expenseDate.Register).State = EntityState.Modified;
}
await _context.ExpensesDate.AddAsync(expenseDate);
await _context.SaveChangesAsync();
}
public override int GetHashCode()
{
if (ExpenseVendor != null)
{
return(ExpenseVendor.GetHashCode() + Convert.ToInt32(ExpensePrice) + ExpenseDate.ToString().GetHashCode());
}
else
{
return(Convert.ToInt32(ExpensePrice) + ExpenseDate.ToString().GetHashCode());
}
}
//Methods
public override string ToString()
{
return($"{Category} {Amount:c} on {ExpenseDate.ToShortDateString()}");
}