private void SetAddingProperties()
{
TheWage = new LivingWageMin();
TheMonth = new TimePeriod();
WageStackPanelVis = true;
UpdateWageVis = false;
}
public WageMinimumViewModel()
{
_db = new SalDbContext();
_wagelogic = new WageLogic();
TheWage = new LivingWageMin();
TheMonth = new TimePeriod();
PeriodCollection = new ObservableCollection <TimePeriod>(_wagelogic.GetPC());
WageCollection = new ObservableCollection <LivingWageMin>(_wagelogic.Get());
}
private bool CheckValidation(LivingWageMin wage)
{
string MessageError = null;
if (string.IsNullOrWhiteSpace(wage.WageYear.ToString()) &&
!Regex.IsMatch(wage.WageYear.ToString(), @"\A[0-9]{4}\z"))
{
MessageError += "рік має бути введеним чслом";
}
if (string.IsNullOrEmpty(MessageError))
{
return(true);
}
else
{
MessageBox.Show("Mistake {0}", MessageError.ToString());
return(false);
}
}
internal void Delete(LivingWageMin wage)
{
if (MessageBox.Show("Ви впевнені, що бажаєте виділити даний прожитковий мінімум?",
"Підтвердіть рішення.", MessageBoxButton.YesNo) == MessageBoxResult.Yes)
{
using (SalDbContext _db = new SalDbContext())
{
try
{
_db.LivingWageMins.Remove(wage);
_db.SaveChanges();
}
catch (Exception ex)
{
MessageBox.Show(ex.ToString(), "Error");
}
} MessageBox.Show("Успішно");
}
}
internal void Add(LivingWageMin wage)
{
using (SalDbContext _db = new SalDbContext())
{
if (CheckValidation(wage) == true)
{
try
{
_db.LivingWageMins.Add(wage);
_db.SaveChanges();
}
catch (DbUpdateException ex)
{
MessageBox.Show(ex.ToString(), "Помилка");
}
MessageBox.Show("Успішно");
}
}
}
internal void Update(LivingWageMin wage)
{
using (SalDbContext _db = new SalDbContext())
{
var checkedwage = _db.LivingWageMins.FirstOrDefault(p => p.LivingWageMinID == wage.LivingWageMinID);
checkedwage.WageValue = wage.WageValue;
checkedwage.WageYear = wage.WageYear;
checkedwage.PeriodId = checkedwage.PeriodId;
try
{
_db.SaveChanges();
}
catch (Exception ex)
{
MessageBox.Show("Exception: {0}", ex.ToString());
}
MessageBox.Show("Успішно");
}
}
static void Main(string[] args)
{
using (SalDbContext db = new SalDbContext())
{
db.Database.CreateIfNotExists();
Person per1 = new Person
{
Surname = "Petrov",
FirstName = "Max",
MidleName = "Petrovich",
IndentificalCode = "7895231456",
PasportCode = "AT54782",
BirthDay = new DateTime(1987, 02, 05),
gender = Person.Gender.Male,
// PersonID = 1
};
Position pos1 = new Position()
{
PositionName = "Director",
//PositionId = 1
};
Position pos2 = new Position()
{
PositionName = "Acountant",
// PositionId = 2
};
Employee emp1 = new Employee
{
EmployeeID = per1.PersonID,
StartDate = new DateTime(2008, 05, 02),
EndDate = new DateTime(2018, 05, 02),
position = pos1
};
Tax tax1 = new Tax
{
// TaxID = 1,
TaxName = "Військовий збір",
TaxPresentage = 18
};
DayType daytype1 = new DayType
{
// DayTypeID = 1,
NameDayType = "Каледнарні дні"
};
TimePeriod tp1 = new TimePeriod
{
PeriodID = 1,
PeriodName = "Січень"
};
SpecialDay specday1 = new SpecialDay
{
// SpecialDayID = 1,
daytype = daytype1,
SpecialDayYear = 2017,
DayValue = 20,
PeriodId = tp1.PeriodID,
DayTypeId = daytype1.DayTypeID,
timeperiod = tp1
};
LivingWageMin wagemin1 = new LivingWageMin()
{
// WageID = 1,
WageYear = 2017,
WageValue = 1600,
PeriodId = tp1.PeriodID,
timeperiod = tp1
};
Company comp1 = new Company
{
// CompanyID = 1,
CompanyName = "ІП Симоненко",
ErdpoyCode = "8745632179985",
CompanyAdress = "Леніна 24",
InformationCode = "АП 87512",
RegistrationDate = "5/07/2014",
RegistrationAdress = "Вінницьке Рувд "
};
SalaryCalculation salcal1 = new SalaryCalculation
{
SalaryCalculationID = 1,
Advance = 234.5m,
EmployeeID = emp1.EmployeeID,
TimePeriodID = tp1.PeriodID,
timeperiod = tp1,
};
db.Companys.Add(comp1);
db.LivingWageMins.Add(wagemin1);
db.DayTypes.Add(daytype1);
db.SpecialDays.Add(specday1);
db.Taxes.Add(tax1);
//db.SaveChanges();
db.Employees.Add(emp1);
db.Positions.Add(pos1);
db.Positions.Add(pos2);
db.TimePeriods.Add(tp1);
db.Persons.Add(per1);
db.SalaryCalculations.Add(salcal1);
try
{
//db.SaveChanges();
}
catch (DbUpdateException e)
{
Console.WriteLine("\n\n*** {0}\n\n", e.InnerException);
}
Console.WriteLine("Success");
}
Console.ReadKey(true);
}
