public ActionResult DeleteConfirmed(int id)
{
SVN sVN = db.SVNs.Find(id);
db.SVNs.Remove(sVN);
db.SaveChanges();
return(RedirectToAction("Index"));
}
public ActionResult Edit([Bind(Include = "Id,AdresId,Agent,ServiceId,Fact,Plan,Maket")] SVN sVN)
{
if (ModelState.IsValid)
{
db.Entry(sVN).State = EntityState.Modified;
db.SaveChanges();
return(RedirectToAction("Index"));
}
ViewBag.AdresId = new SelectList(db.Adres, "Id", "Adress", sVN.AdresId);
ViewBag.ServiceId = new SelectList(db.TableServices, "Id", "Type", sVN.ServiceId);
return(View(sVN));
}
private bool doubles()
{
List <PurchaserData> purchaser = bl.SelectAllPurchaser();
foreach (PurchaserData pur in purchaser)
{
if (pur.Purchaser.SVN != 0 && pur.Purchaser.SVN.Equals(SVN.getContent()) || pur.Purchaser.FirstName.Equals(FirstName.getContent()) && pur.Purchaser.LastName.Equals(LastName.getContent()))
{
return(true);
}
}
return(false);
}
// GET: SVNs/Details/5
public ActionResult Details(int?id)
{
if (id == null)
{
return(new HttpStatusCodeResult(HttpStatusCode.BadRequest));
}
SVN sVN = db.SVNs.Find(id);
if (sVN == null)
{
return(HttpNotFound());
}
return(View(sVN));
}
// GET: SVNs/Edit/5
public ActionResult Edit(int?id)
{
if (id == null)
{
return(new HttpStatusCodeResult(HttpStatusCode.BadRequest));
}
SVN sVN = db.SVNs.Find(id);
if (sVN == null)
{
return(HttpNotFound());
}
ViewBag.AdresId = new SelectList(db.Adres, "Id", "Adress", sVN.AdresId);
ViewBag.ServiceId = new SelectList(db.TableServices, "Id", "Type", sVN.ServiceId);
return(View(sVN));
}
public static void SVN_Cleanup()
{
try
{
EditorUtility.DisplayProgressBar("SVN", "Cleanup", 0.5f);
var output = SVN.Execute("cleanup --include-externals ./", Path.GetDirectoryName(Application.dataPath));
Debug.Log(output);
AssetDatabase.Refresh();
}
catch (Exception e)
{
Debug.LogException(e);
}
finally
{
EditorUtility.ClearProgressBar();
}
}
public static void SVN_Update()
{
try
{
EditorUtility.DisplayProgressBar("SVN", "Update", 0.5f);
var output = SVN.Execute("update --force ./", Path.GetDirectoryName(Application.dataPath));
Debug.Log(output);
AssetDatabase.Refresh();
}
catch (Exception e)
{
Debug.LogException(e);
}
finally
{
EditorUtility.ClearProgressBar();
}
}
public static void SVN_Reset()
{
try
{
if (EditorUtility.DisplayDialog(
"重置工程", "老铁！需要重置工程吗？将会删除【所有】未提交文件，回退【所有】本地修改，注意防止丢失工作内容。", "搞起", "取消"))
{
EditorUtility.DisplayProgressBar("SVN", "Reset", 0.5f);
foreach (var info in SVN.ResetWorkingCopy(Path.GetDirectoryName(Application.dataPath)))
{
EditorUtility.DisplayProgressBar(info.title, info.message, 0.5f);
}
AssetDatabase.Refresh();
}
}
catch (Exception e)
{
Debug.LogException(e);
}
finally
{
EditorUtility.ClearProgressBar();
}
}
private void Speichern_Click(object sender, RoutedEventArgs e)
{
InputEvaluator ie = new InputEvaluator();
if (ie.Evaluate(this))
{
PersonalAssistant paU = new PersonalAssistant();
var a = App.Current as App;
paU.Id = a.PAIndex;
paU.HomeAdress = new Adress();
paU.HomeAdress.AdressId = pa.HomeAdress.AdressId;
paU.HomeAdress.Street = Street.getContent();
paU.HomeAdress.HouseNumber = parseInt(HNr.getContent());
paU.HomeAdress.Etage = parseInt(Etage.getContent());
paU.HomeAdress.StairNumber = parseInt(StairNr.getContent());
paU.HomeAdress.DoorNumber = parseInt(DoorNr.getContent());
paU.HomeAdress.City = City.getContent();
paU.HomeAdress.ZipCode = parseInt(ZIP.getContent());
paU.HomeAdress.Country = Country.getContent();
paU.nationality = nationality.getContent();
paU.FirstName = FirstName.getContent();
paU.LastName = LastName.getContent();
paU.EMail = Email.getContent();
paU.PhoneNumber = PhoneNr.getContent();
paU.MobilePhone = MobileNr.getContent();
paU.SVN = parseLong(SVN.getContent());
paU.ClosingDateDocuments = DateTime.ParseExact(documentDate.getContent(), "dd.mm.yyyy", CultureInfo.InvariantCulture);
paU.IBAN = IBAN.getContent();
paU.BIC = BIC.getContent();
paU.AccountHolder = kontoinhaber.getContent();
//paU.EmploymentTimes.Clear();
paU.SV = ((bool)SV.IsChecked) ? (true) : false;
paU.Dienstvertrag = ((bool)Dienstvertrag.IsChecked) ? (true) : false;
paU.BestBH = ((bool)BestätigungBH.IsChecked) ? (true) : false;
paU.Grundkurs = ((bool)Grundkurs.IsChecked) ? (true) : false;
paU.Active = ((bool)activeRadioBtn.IsChecked) ? (true) : false;
//Weiterbildungen
paU.consumedHours = Convert.ToDecimal(tbHours.getContent());
paU.deadLineHours = Convert.ToDateTime(tbDeadline.getContent());
paU.InfoField = pa.InfoField;
bl.UpdatePa(paU);
//check if add and delete are in conflict
PAtoPurchaserBL PBL = new PAtoPurchaserBL();
foreach (Purchaser p in addedAGs)
{
foreach (Purchaser pd in deletedAGs)
{
if (p.Id == pd.Id)
{
addedAGs.Remove(p);
deletedAGs.Remove(pd);
}
}
}
//add PA connection
foreach (Purchaser p in addedAGs)
{
PBL.add(paU, p);
}
//delete PA connection
foreach (Purchaser p in deletedAGs)
{
PBL.delete(paU, p);
}
//add Employments
foreach (Employment emp in addedEmps)
{
_bl.insertEmployment(emp);
}
//delete Employments
foreach (Employment emp in deletedEmps)
{
_bl.deleteEmployment(emp);
}
foreach (Window window in Application.Current.Windows)
{
if (window.GetType() == typeof(Main))
{
(window as Main).FrameÜbersicht.Source = new Uri("../Personenverwaltung/PA/PAÜbersicht.xaml", UriKind.Relative);
}
}
}
}
public ActionResult Upload(HttpPostedFileBase upload, DateTime Date)
{
int progress = 0;
double pro100 = 0;
int procount = 0;
if (upload != null)
{
HttpCookie cookie = new HttpCookie("My localhost cookie");
//найдем старые данные за этот месяц и заменим их не щадя
List <SVN> dbSVN = db.SVNs.Where(x => x.Date.Year == Date.Year && x.Date.Month == Date.Month).ToList();
pro100 = dbSVN.Count;
foreach (SVN S in dbSVN)
{
try
{
db.SVNs.Remove(S);
db.SaveChanges();
procount++;
progress = Convert.ToInt16(procount / pro100 * 100);
if (procount > pro100)
{
procount = Convert.ToInt32(pro100);
}
ProgressHub.SendMessage("Удаляем старые данные...", progress);
}
catch (Exception e)
{
Console.WriteLine(e.Message);
}
}
// Установить значения в нем
cookie["Download"] = "0";
// Добавить куки в ответ
Response.Cookies.Add(cookie);
//call this method inside your working action
ProgressHub.SendMessage("Инициализация и подготовка...", 0);
// получаем имя файла
string fileName = System.IO.Path.GetFileName(upload.FileName);
// сохраняем файл в папку Files в проекте
if (Directory.Exists(Server.MapPath("~/Files/")) == false)
{
Directory.CreateDirectory(Server.MapPath("~/Files/"));
}
upload.SaveAs(Server.MapPath("~/Files/" + fileName));
//обрабатываем файл после загрузки
string[] Names = new string[] { "STREET_HOUSE", "SERVICE", "DELIVER", "CHARGE_PLAN", "CHARGE_FACT", "MAKET" };
string Error = "";
List <List <string> > excel = ExcelSVNUpload.IMPORT(Server.MapPath("~/Files/" + fileName), Names, out Error);
if (excel.Count < 1)
{
//если нифига не загрузилось то
ViewBag.Error = Error;
ViewBag.Names = Names;
Console.WriteLine("Пустой массив значит файл не загрузился!(он уже удалился)");
return(View("NotUpload"));
}
else
{
pro100 = excel.Count;
SVN SVNKA = new SVN();
List <Adres> Adresa = db.Adres.ToList();// грузим все адреса из БД
List <TableService> TSdb = db.TableServices.ToList();
List <List <string> > Services = new List <List <string> >();
//один раз преобразуем таблицу сервисов для сравнения чтоб в цикле не вызывать
int ser = 0;
foreach (TableService T in TSdb)
{
T.Type = T.Type.Replace(" ", "").ToUpper();
Services.Add(new List <string>());
Services[ser].Add(T.Type);//для проверки сохраняем
ser++;
}
//для каждой строки в экселе
foreach (List <string> L in excel)
{
string Service = L[1].Replace(" ", "").ToUpper();
bool EstService = false;
if (Service.Contains("ОБЩ.ИМУЩ."))
{
}
foreach (TableService TS in TSdb)
{
if (TS.Type.Equals(Service))
{
EstService = true;
SVNKA.ServiceId = TS.Id;
ser = TS.Id - 1;//номер сервиса по порядку с 0
break;
}
}
//если сервис не найден в списке то и адрес не проверяем идем дальше
if (EstService)
{
bool EstName = false;
string Name = L[0].Replace(" ", "");
foreach (Adres A in Adresa)
{
string AName = A.Adress.Replace(" ", "");
if (AName.Equals(Name))
{
//если в массиве адресов есть адрес из строчки то сохраняем айдишник
EstName = true;
SVNKA.AdresId = A.Id;
if (ser < 4)
{
Services[ser].Add(Name);
}
// Adresa.Remove(A);//уменьшаем массив для дальнейшего ускорения поиска
break;
}
}
//если имени нет в списке то и сохранять не будем
if (EstName)
{
try
{
SVNKA.Plan = Convert.ToDecimal(L[3]);
SVNKA.Fact = Convert.ToDecimal(L[4]);
SVNKA.Maket = Convert.ToDecimal(L[5]);
SVNKA.Agent = L[2];
SVNKA.Date = Date;
}
catch (Exception e)
{
Console.WriteLine("Не преобразуется в децимал " + SVNKA.AdresId + " " + e.Message);
}
try
{
db.SVNs.Add(SVNKA);
db.SaveChanges();
}
catch (Exception e)
{
Console.WriteLine("Ошибка записи в базу данных " + e.Message);
}
}
}
procount++;
progress = Convert.ToInt16(50 + procount / pro100 * 50);
ProgressHub.SendMessage("Обрабатываем файл СВН...", progress);
if (procount > pro100)
{
procount = Convert.ToInt32(pro100);
}
}
List <string> Adr = Adresa.Select(x => x.Adress).ToList();
for (int a = 0; a < Adr.Count; a++)
{
Adr[a] = Adr[a].Replace(" ", "").ToUpper();
}
ViewBag.VsegoServices = TSdb.Count;
ViewBag.Services = Services;
ViewBag.date = Date;
ViewBag.file = fileName;
return(View("UploadComplete"));
}
}
return(RedirectToAction("Index"));
}
public Engine(SVN svn, TFS tfs)
{
_svn = svn;
_tfs = tfs;
}
private void Button_Click(object sender, RoutedEventArgs e)
{
if (purData == null)
{
purData = new PurchaserData();
}
if (purData.Purchaser == null)
{
purData.Purchaser = new Purchaser();
}
Purchaser pur = purData.Purchaser;
//purData = new PurchaserData();
pur.HomeAdress = new Adress();
InputEvaluator ie = new InputEvaluator();
bool save = true;
if (doubles())
{
SystemSounds.Asterisk.Play();
switch (MessageBox.Show("Es existiert bereits ein Auftraggeber mit diesem Namen. Soll er wirklich hinzugefügt werden?",
"Achtung!",
MessageBoxButton.YesNo, MessageBoxImage.Question))
{
case MessageBoxResult.No:
save = false;
break;
case MessageBoxResult.Yes:
break;
}
}
if (save)
{
if (ie.Evaluate(this))
{
pur.FirstName = FirstName.getContent();
pur.LastName = LastName.getmustContent();
pur.EMail = Email.getContent();
if (PhoneNr.getContent() != null)
{
pur.PhoneNumber = PhoneNr.getContent();
}
if (MobileNr.getContent() != null)
{
pur.MobilePhone = MobileNr.getContent();
}
pur.HomeAdress.Street = Street.getContent();
pur.HomeAdress.StairNumber = parseInt(StairNr.getContent());
pur.HomeAdress.HouseNumber = parseInt(HNr.getContent());
pur.HomeAdress.Etage = parseInt(Etage.getContent());
pur.HomeAdress.DoorNumber = parseInt(DoorNr.getContent());
pur.HomeAdress.City = City.getContent();
pur.HomeAdress.Country = Country.getContent();
pur.HomeAdress.ZipCode = parseInt(ZIP.getContent());
pur.BIC = BIC.getContent();
pur.IBAN = IBAN.getContent();
pur.SVN = parseLong(SVN.getContent());
pur.AccountHolder = kontoinhaber.getContent();
pur.EntryDate = EntryDate.SelectedDate;
pur.ApprovalBegin = ApprovelFrom.SelectedDate;
pur.ApprovalEnd = ApprovelTo.SelectedDate;
pur.nationality = nationality.getContent();
purData.HourlyRate = parseDecimal(PayperHour.getContent());
purData.TravellingAllowanceKM = parseDecimal(KmPay.getContent());
purData.HourlyRatePayoff = parseDecimal(billablePayperHour.getContent());
purData.Income = parseDecimal(Income.getContent());
purData.AssistenceDemand = parseInt(Needof.getContent());
purData.InputIncome = parseDecimal(IncomeBetrag.getContent());
purData.CareAllowance = parseInt((string)CareAllowence.SelectedValue);
pur.DistrictCommision = districtcommission.getContent();
if ((bool)activeRadioBtn.IsChecked)
{
pur.Active = true;
}
if ((bool)einfuehrungskurs.IsChecked)
{
pur.hasContract = true;
}
if ((bool)contract.IsChecked)
{
pur.hasIntroCourse = true;
}
//switch to Übersicht
foreach (Window window in Application.Current.Windows)
{
if (window.GetType() == typeof(Main))
{
(window as Main).FrameÜbersicht.Source = new Uri("../Personenverwaltung/AG/AGÜbersicht.xaml", UriKind.Relative);
}
}
purData.Purchaser = pur;
if (pur.FirstName != null && pur.LastName != null)
{
_bl.CreatePurchaser(purData);
}
//add PA connection
PAtoPurchaserBL PBL = new PAtoPurchaserBL();
foreach (PersonalAssistant pa in addedPAs)
{
foreach (PersonalAssistant pad in deletedPAs)
{
if (pa.Id == pad.Id)
{
addedPAs.Remove(pa);
deletedPAs.Remove(pad);
}
}
}
foreach (PersonalAssistant pa in addedPAs)
{
PBL.add(pa, pur);
}
//delete PA connection
foreach (PersonalAssistant pa in deletedPAs)
{
PBL.delete(pa, pur);
}
}
}
}
private void save_Click(object sender, RoutedEventArgs e)
{
Purchaser purU = new Purchaser();
if (purData.Purchaser.ContactPerson != null)
{
purU.ContactPerson = new Person();
purU.ContactPerson = purData.Purchaser.ContactPerson;
}
PurchaserData purDataU = new PurchaserData();
purU.HomeAdress = new Adress();
InputEvaluator ie = new InputEvaluator();
if (ie.Evaluate(this))
{
purU.Id = AGidx;
purU.FirstName = FirstName.getContent();
purU.LastName = LastName.getmustContent();
purU.EMail = Email.getContent();
if (PhoneNr.getContent() != null)
{
purU.PhoneNumber = PhoneNr.getContent();
}
if (MobileNr.getContent() != null)
{
purU.MobilePhone = MobileNr.getContent();
}
purU.HomeAdress.AdressId = purData.Purchaser.HomeAdress.AdressId;
purU.HomeAdress.Street = Street.getContent();
purU.HomeAdress.StairNumber = parseInt(StairNr.getContent());
purU.HomeAdress.HouseNumber = parseInt(HNr.getContent());
purU.HomeAdress.Etage = parseInt(Etage.getContent());
purU.HomeAdress.DoorNumber = parseInt(DoorNr.getContent());
purU.HomeAdress.City = City.getContent();
purU.HomeAdress.Country = Country.getContent();
purU.HomeAdress.ZipCode = parseInt(ZIP.getContent());
purU.EntryDate = EntryDate.DisplayDate;
purU.ApprovalBegin = ApprovelFrom.DisplayDate;
purU.ApprovalEnd = ApprovelTo.DisplayDate;
purU.DistrictCommision = districtcommission.getContent();
purU.nationality = nationality.getContent();
purU.SVN = parseLong(SVN.getContent());
purDataU.HourlyRate = parseDecimal(PayperHour.getContent());
purDataU.TravellingAllowanceKM = parseDecimal(KmPay.getContent());
purDataU.HourlyRatePayoff = parseDecimal(billablePayperHour.getContent());
purDataU.Income = parseDecimal(Income.getContent());
purDataU.AssistenceDemand = parseInt(Needof.getContent());
purDataU.InputIncome = parseDecimal(IncomeBetrag.getContent());
purDataU.CareAllowance = parseInt((string)CareAllowence.SelectedValue);
purDataU.Purchaser.InfoField = purData.Purchaser.InfoField;
purDataU.Year = purData.Year;
purDataU.Month = purData.Month;
purU.IBAN = IBAN.getContent();
purU.BIC = BIC.getContent();
purU.AccountHolder = kontoinhaber.getContent();
if ((bool)activeRadioBtn.IsChecked)
{
purU.Active = true;
}
else if ((bool)inactiveRadioBtn.IsChecked)
{
purU.Active = false;
}
if ((bool)einfuehrungskurs.IsChecked)
{
purU.hasContract = true;
}
if ((bool)contract.IsChecked)
{
purU.hasIntroCourse = true;
}
if (purDataU.Purchaser.Employees != null)
{
foreach (EmploymentStatus emp in purData.Purchaser.Employees)
{
bool found = false;
foreach (PersonalAssistant pa in employedPA)
{
if (pa.Id.Equals(emp.Assistant.Id))
{
found = true;
}
}
if (found)
{
purU.Employees.Add(emp);
}
}
}
//add PA connection
PAtoPurchaserBL PBL = new PAtoPurchaserBL();
foreach (PersonalAssistant pa in addedPAs)
{
foreach (PersonalAssistant pad in deletedPAs)
{
if (pa.Id == pad.Id)
{
addedPAs.Remove(pa);
deletedPAs.Remove(pad);
}
}
}
foreach (PersonalAssistant pa in addedPAs)
{
PBL.add(pa, purU);
}
//delete PA connection
foreach (PersonalAssistant pa in deletedPAs)
{
PBL.delete(pa, purU);
}
//delete PA connection
//AKTIV RADIO BOXEN NAMEN
//switch to Übersicht
foreach (Window window in Application.Current.Windows)
{
if (window.GetType() == typeof(Main))
{
(window as Main).FrameÜbersicht.Source = new Uri("../Personenverwaltung/AG/AGÜbersicht.xaml", UriKind.Relative);
}
}
}
purU.InfoField = purData.Purchaser.InfoField;
purDataU.Purchaser = purU;
if (purU.FirstName != null && purU.LastName != null)
{
bl.UpdatePurchaser(purDataU);
}
}
private void Button_Click(object sender, RoutedEventArgs e)
{
InputEvaluator ie = new InputEvaluator();
_bl = new PersonalAssistentBl();
bool save = true;
if (doubles())
{
SystemSounds.Asterisk.Play();
switch (MessageBox.Show("Es existiert bereits ein Persönlicher Assistent mit diesem Namen. Soll er wirklich hinzugefügt werden?",
"Achtung!",
MessageBoxButton.YesNo, MessageBoxImage.Question))
{
case MessageBoxResult.No:
save = false;
break;
case MessageBoxResult.Yes:
break;
}
}
if (save)
{
if (ie.Evaluate(this))
{
//PersonalAssistant pa = new PersonalAssistant();
pa.HomeAdress = new Adress();
pa.HomeAdress.Street = Street.getContent();
pa.HomeAdress.HouseNumber = parseInt(HNr.getContent());
pa.HomeAdress.Etage = parseInt(Etage.getContent());
pa.HomeAdress.StairNumber = parseInt(StairNr.getContent());
pa.HomeAdress.DoorNumber = parseInt(DoorNr.getContent());
pa.HomeAdress.City = City.getContent();
pa.HomeAdress.ZipCode = parseInt(ZIP.getContent());
pa.HomeAdress.Country = Country.getContent();
pa.nationality = nationality.getContent();
pa.FirstName = FirstName.getContent();
pa.LastName = LastName.getContent();
pa.EMail = Email.getContent();
pa.PhoneNumber = PhoneNr.getContent();
pa.MobilePhone = MobileNr.getContent();
pa.SVN = parseLong(SVN.getContent());
// TODO add document date
pa.IBAN = IBAN.getContent();
pa.BIC = BIC.getContent();
pa.AccountHolder = kontoinhaber.getContent();
pa.SV = ((bool)SV.IsChecked) ? (true) : false;
pa.Dienstvertrag = ((bool)Dienstvertrag.IsChecked) ? (true) : false;
pa.BestBH = ((bool)BestätigungBH.IsChecked) ? (true) : false;
pa.Grundkurs = ((bool)Grundkurs.IsChecked) ? (true) : false;
pa.Purchasers = new List <Purchaser>();
pa.EmploymentTimes = this.employmentList;
pa.consumedHours = Convert.ToDecimal(tbHours.getContent());
//Deadline für die Weiterbildungen ermitteln
if (pa.EmploymentTimes != null && pa.EmploymentTimes.Count != 0 && pa.EmploymentTimes.Last().EmplBegin.Year == 1)
{
pa.deadLineHours = pa.EmploymentTimes.Last().EmplBegin.AddYears(2);
}
else
{
pa.deadLineHours = DateTime.Now.AddYears(2);
}
if ((bool)activeRadioButton.IsChecked)
{
pa.Active = true;
}
foreach (Purchaser pur in employedPurchasers)
{
//pa.Purchasers.Add(pur);
}
_bl.CreatePa(pa);
PAtoPurchaserBL PBL = new PAtoPurchaserBL();
foreach (Purchaser p in addedAGs)
{
foreach (Purchaser pd in deletedAGs)
{
if (p.Id == pd.Id)
{
addedAGs.Remove(p);
deletedAGs.Remove(pd);
}
}
}
//insert PA Connection
foreach (Purchaser p in addedAGs)
{
PBL.add(pa, p);
}
//delete PA connection
foreach (Purchaser p in deletedAGs)
{
PBL.delete(pa, p);
}
//add Employments
foreach (Employment emp in addedEmps)
{
emp.EmplId = pa.Id;
_bl.insertEmployment(emp);
}
//delete Employments
foreach (Employment emp in deletedEmps)
{
emp.EmplId = pa.Id;
_bl.deleteEmployment(emp);
}
//switch to Übersicht
foreach (Window window in Application.Current.Windows)
{
if (window.GetType() == typeof(Main))
{
(window as Main).FrameÜbersicht.Source = new Uri("../Personenverwaltung/PA/PAÜbersicht.xaml", UriKind.Relative);
}
}
}
}
}
