public static List <Liquidation_types> SelectLiquidationTypes()
{
using (SuuxEntities ent = new SuuxEntities())
{
return(ent.Liquidation_types.ToList());
}
}
public static List <ART> SelectART()
{
using (SuuxEntities ent = new SuuxEntities())
{
return(ent.ART.ToList());
}
}
public static void InsertFixedSchedule(Fixed_schedules fixedSchedule)
{
using (SuuxEntities ent = new SuuxEntities())
{
ent.Fixed_schedules.Add(fixedSchedule);
ent.SaveChanges();
}
}
public static void DeleteConcept(int conceptId)
{
using (SuuxEntities ent = new SuuxEntities())
{
ent.Concepts.Remove(ent.Concepts.Find(conceptId));
ent.SaveChanges();
}
}
public static void DeleteCalendars(List <int> calendarsId)
{
using (SuuxEntities ent = new SuuxEntities())
{
calendarsId.ForEach(cid => ent.Calendars.Remove(ent.Calendars.Single(c => c.calendar_id == cid)));
ent.SaveChanges();
}
}
public static void InsertLiquidationFixedData(Liquidation_fixed_datas liquidationFixedData)
{
using (SuuxEntities ent = new SuuxEntities())
{
ent.Liquidation_fixed_datas.Add(liquidationFixedData);
ent.SaveChanges();
}
}
public static void DeleteHoliday(DateTime month, int day)
{
using (SuuxEntities ent = new SuuxEntities())
{
ent.Holidays.Remove(ent.Holidays.Where(h => h.month == month && h.day == day).First());
ent.SaveChanges();
}
}
public static void InsertART(ART art)
{
using (SuuxEntities ent = new SuuxEntities())
{
ent.ART.Add(art);
ent.SaveChanges();
}
}
public static void InsertSocialWork(Social_works socialWork)
{
using (SuuxEntities ent = new SuuxEntities())
{
ent.Social_works.Add(socialWork);
ent.SaveChanges();
}
}
public static void InsertLaborUnion(Labor_unions laborUnion)
{
using (SuuxEntities ent = new SuuxEntities())
{
ent.Labor_unions.Add(laborUnion);
ent.SaveChanges();
}
}
public static void InsertBank(Banks bank)
{
using (SuuxEntities ent = new SuuxEntities())
{
ent.Banks.Add(bank);
ent.SaveChanges();
}
}
public static void InsertCategory(Categorys category)
{
using (SuuxEntities ent = new SuuxEntities())
{
ent.Categorys.Add(category);
ent.SaveChanges();
}
}
public static void InsertFormula(Formulas formula)
{
using (SuuxEntities ent = new SuuxEntities())
{
ent.Formulas.Add(formula);
ent.SaveChanges();
}
}
public static void InsertTurn(Turns turn)
{
using (SuuxEntities ent = new SuuxEntities())
{
ent.Turns.Add(turn);
ent.SaveChanges();
}
}
public static void InsertHoliday(Holidays holiday)
{
using (SuuxEntities ent = new SuuxEntities())
{
ent.Holidays.Add(holiday);
ent.SaveChanges();
}
}
public static void DeleteTurn(int turnId)
{
using (SuuxEntities ent = new SuuxEntities())
{
ent.Turns.Remove(ent.Turns.Find(turnId));
ent.SaveChanges();
}
}
public static void DeleteLiquidationFixedData(int liquidationFixedDataId)
{
using (SuuxEntities ent = new SuuxEntities())
{
ent.Liquidation_fixed_datas.Remove(ent.Liquidation_fixed_datas.Find(liquidationFixedDataId));
ent.SaveChanges();
}
}
public static List <Holidays> SelectHolidays(DateTime month)
{
using (SuuxEntities ent = new SuuxEntities())
{
return(ent.Holidays
.Where(h => h.month == month)
.ToList());
}
}
public static void UpdateLaborUnion(Labor_unions laborUnion)
{
using (SuuxEntities ent = new SuuxEntities())
{
ent.Labor_unions.Attach(laborUnion);
ent.Entry(laborUnion).State = System.Data.Entity.EntityState.Modified;
ent.SaveChanges();
}
}
public static void UpdateBank(Banks bank)
{
using (SuuxEntities ent = new SuuxEntities())
{
ent.Banks.Attach(bank);
ent.Entry(bank).State = System.Data.Entity.EntityState.Modified;
ent.SaveChanges();
}
}
public static void UpdateCategory(Categorys category)
{
using (SuuxEntities ent = new SuuxEntities())
{
ent.Categorys.Attach(category);
ent.Entry(category).State = System.Data.Entity.EntityState.Modified;
ent.SaveChanges();
}
}
public static void UpdateSocialWork(Social_works socialWork)
{
using (SuuxEntities ent = new SuuxEntities())
{
ent.Social_works.Attach(socialWork);
ent.Entry(socialWork).State = System.Data.Entity.EntityState.Modified;
ent.SaveChanges();
}
}
public static void UpdateEmployee(Employees employee)
{
using (SuuxEntities ent = new SuuxEntities())
{
ent.Employees.Attach(employee);
ent.Entry(employee).State = EntityState.Modified;
ent.SaveChanges();
}
}
public static void InsertEmployee(Employees employee)
{
using (SuuxEntities ent = new SuuxEntities())
{
employee.Concepts = new ObservableCollection <Concepts>(ent.Concepts.Where(c => c.common));
ent.Employees.Add(employee);
ent.SaveChanges();
}
}
public static void UpdateLiquidationFixedData(Liquidation_fixed_datas liquidationFixedData)
{
using (SuuxEntities ent = new SuuxEntities())
{
ent.Liquidation_fixed_datas.Attach(liquidationFixedData);
ent.Entry(liquidationFixedData).State = EntityState.Modified;
ent.SaveChanges();
}
}
public static void UpdateART(ART art)
{
using (SuuxEntities ent = new SuuxEntities())
{
ent.ART.Attach(art);
ent.Entry(art).State = System.Data.Entity.EntityState.Modified;
ent.SaveChanges();
}
}
public static void UpdateTurn(Turns turn)
{
using (SuuxEntities ent = new SuuxEntities())
{
ent.Turns.Attach(turn);
ent.Entry(turn).State = System.Data.Entity.EntityState.Modified;
ent.SaveChanges();
}
}
public static List <Concepts> SelectConceptsRAndNRIncludeAll()
{
using (SuuxEntities ent = new SuuxEntities())
{
return(ent.Concepts.Where(c => !c.common)
.Include(c => c.Concept_types)
.Include(c => c.Formulas)
.ToList());
}
}
public static List <Employees> SelectEmployeesIncludeConcepts()
{
using (SuuxEntities ent = new SuuxEntities())
{
return(ent.Employees
.Where(e => e.state)
.Include(e => e.Concepts)
.ToList());
}
}
public static int SelectVacationsDays(int fileN, DateTime month)
{
using (SuuxEntities ent = new SuuxEntities())
{
return(ent.Calendars
.Where(c => c.file_n == fileN && c.month == month)
.Select(c => c.Schedules.Where(s => s.nwork_day == "V").Count())
.FirstOrDefault());
}
}
