private static int Execute(CommandLineApplication config, IBudgetFilesFactory budgetFilesFactory, ILog log)
{
var yearOption = YearOption.Create(config);
var monthOption = MonthOption.Create(config);
var currencyOption = CurrencyOption.Create(config);
if (yearOption.NotExists || monthOption.NotExists || currencyOption.NotExists)
{
config.ShowHelp();
return(ErrorCode.Value);
}
var(plannedBudgetFile, realBudgetFile) = budgetFilesFactory.Create(yearOption, monthOption, currencyOption);
if (plannedBudgetFile.NotExists || realBudgetFile.NotExists)
{
plannedBudgetFile.Save();
realBudgetFile.Save();
log.Write($"Budget {plannedBudgetFile.Budget} has been created.");
return(OkCode.Value);
}
log.Write($"Budget {plannedBudgetFile.Budget} already exists.");
return(ErrorCode.Value);
}
public AddCommandBuilder(CommandLineApplication application)
{
_application = application;
_yearOption = YearOption.Create(application);
_monthOption = MonthOption.Create(application);
_currencyOption = CurrencyOption.Create(application);
_amountOption = AmountOption.Create(application);
_categoryOption = CategoryOption.Create(application);
_descriptionOption = DescriptionOption.Create(application);
}
private static string QueryBuilder(int monthIndex)
{
string finalQuery = string.Empty;
string wages = "WAGE" + monthIndex;
string pf = "PF" + monthIndex;
//converting index value to string for some column to get month in spell
MonthOption month = (MonthOption)monthIndex;
string monthValue = month.ToString();
string eePercent = monthValue.Substring(0, 3) + "EE";
string erPercent = monthValue.Substring(0, 3) + "ER";
return(finalQuery = "SELECT EMP_UAN, EMP_NAME, " + wages + "," + wages + "," + wages + "," + wages + "," + eePercent + "," + pf + "," + erPercent + ", PF13 as NCPdays, PF13 as Totaldays");
}
public void FillRegistrationForm(RegistrationUser user)
{
Type(FirstName, user.FirstName);
Type(LastName, user.LastName);
FillManyOptionElements(MatrialStatus, user.MatrialStatus);
FillManyOptionElements(Hobbies, user.Hobbies);
CountryOption.SelectByText(user.Country);
MonthOption.SelectByValue(user.Month);
DayOption.SelectByText(user.Day);
YearOption.SelectByValue(user.Year);
Type(Phone, user.Phone);
Type(UserName, user.UserName);
Type(Email, user.Email);
UploadPicButton.Click();
_driver.SwitchTo().ActiveElement().SendKeys(user.PicturePath);
Type(Description, user.Description);
Type(Password, user.Password);
Type(ConfirmPassword, user.ConfirmPassword);
SubmitButton.Click();
}
public void FillRegistrationForm()
{
Type(FirstName, "Ventsislav");
Type(LastName, "Ivanov");
this.MatrialStatus.Click();
this.Hobbies[0].Click();
this.Hobbies[1].Click();
CountryOption.SelectByText("Bulgaria");
MonthOption.SelectByValue("3");
DayOption.SelectByText("3");
YearOption.SelectByValue("1989");
Type(Phone, "359999999999");
Type(UserName, "BatmanForever");
Type(Email, "*****@*****.**");
UploadPicButton.Click();
Driver.SwitchTo().ActiveElement().SendKeys(Path.GetFullPath(@"..\..\..\logo.jpg"));
Type(Description, "I think I'm Ready with this test!");
Type(Password, "123456789");
Type(ConfirmPassword, "123456789");
SubmitButton.Click();
}
public void FillForm(User user)
{
FirstName.SendKeys(user.FirstName);
LastName.SendKeys(user.LastName);
Password.SendKeys(user.Password);
Days.Click();
DayOption.Click();
Months.Click();
MonthOption.Click();
Years.Click();
YearOption.Click();
Address.SendKeys(user.Address);
City.SendKeys(user.City);
State.Click();
StateOption.Click();
Zip.SendKeys(user.ZipCode);
HomePhone.SendKeys(user.HomePhone);
Mobile.SendKeys(user.MobilePhone);
AddressAlias.Clear();
AddressAlias.SendKeys(user.AddressAlias);
RegisterButton.Click();
}
public static DataTable ReadDBFfile(string filePath, int monthIndex)
{
var dbf = new Dbf();
dbf.Read(filePath);
var dt = new DataTable();
//return dt;
// Cols
for (int i = 0; i < dbf.Fields.Count; i++)
{
dt.Columns.Add(dbf.Fields[i].Name, dbf.Fields[i].GetType().GetProperties()[0].PropertyType);
}
// Rows
foreach (DbfRecord record in dbf.Records)
{
var row = dt.NewRow();
for (int i = 0; i < dt.Columns.Count; i++)
{
row[i] = record.Data[i];
}
dt.Rows.Add(row);
}
// Clean
dbf = null;
//var dt2 = new DataTable();
//converting index value to string for some column to get month in spell
MonthOption month = (MonthOption)monthIndex;
string pf = "PF" + monthIndex;
string monthValue = month.ToString();
string eePercent = monthValue.Substring(0, 3) + "EE";
string erPercent = monthValue.Substring(0, 3) + "ER";
//SHOULD I make a concrete class for this
var res = from myRow in dt.AsEnumerable()
where myRow.Field <string>("WAGE" + monthIndex.ToString()) != null
select new Anon
{
EMP_UAN = myRow.Field <string>("EMP_UAN"),
EMP_NAME = myRow.Field <string>("EMP_NAME"),
EMP_WAGE = Convert.ToInt32(myRow.Field <string>("WAGE" + monthIndex.ToString())),
EMP_WAGE2 = Convert.ToInt32(myRow.Field <string>("WAGE" + monthIndex.ToString())),
EMP_WAGE3 = Convert.ToInt32(myRow.Field <string>("WAGE" + monthIndex.ToString())),
EMP_WAGE4 = Convert.ToInt32(myRow.Field <string>("WAGE" + monthIndex.ToString())),
EE_Percent = Convert.ToInt32(myRow.Field <string>(eePercent)),
PF = Convert.ToInt32(myRow.Field <string>(pf)),
ER_Percent = Convert.ToInt32(myRow.Field <string>(erPercent))
};
dt = new DataTable();
dt.Columns.Add("EMP_UAN");
dt.Columns.Add("EMP_NAME");
dt.Columns.Add("WAGE" + monthIndex.ToString());
dt.Columns.Add("WAGE" + monthIndex.ToString() + 1);
dt.Columns.Add("WAGE" + monthIndex.ToString() + 2);
dt.Columns.Add("WAGE" + monthIndex.ToString() + 3);
dt.Columns.Add("EEPer" + monthIndex.ToString());
dt.Columns.Add(pf);
dt.Columns.Add("ERPer" + monthIndex.ToString());
dt.Columns.Add("NCPDays");
dt.Columns.Add("Totaldays");
foreach (var item in res)
{
DataRow row = dt.NewRow();
foreach (var col in dt.Columns)
{
row[columnName : "EMP_UAN"] = item.EMP_UAN;
row[columnName : "EMP_NAME"] = item.EMP_NAME;
row[columnName : "WAGE" + monthIndex.ToString()] = item.EMP_WAGE;
row[columnName : "WAGE" + monthIndex.ToString() + 1] = item.EMP_WAGE2;
row[columnName : "WAGE" + monthIndex.ToString() + 2] = item.EMP_WAGE3;
row[columnName : "WAGE" + monthIndex.ToString() + 3] = item.EMP_WAGE4;
row[columnName : "EEPer" + monthIndex.ToString()] = item.EE_Percent;
row[columnName : pf] = item.PF;
row[columnName : "ERPer" + monthIndex.ToString()] = item.ER_Percent;
row[columnName : "NCPdays"] = 0;
row[columnName : "Totaldays"] = 0;
}
dt.Rows.Add(row);
}
return(dt);
}
