public ActionResult AddPredpriyatie1(string name,string FIORuk,string DolzhnostRuk,string FIOKLica,string DolzhnostKLica,
string Telefon, string faks, string email, int Sfera, int Shtat, int FormaSob)
{
Predpriyatie res =new Predpriyatie()
{
Name = name,
FIORuk = FIORuk,
DolznostRuk = DolzhnostRuk,
KontaktLico = FIOKLica,
DolznostKLico = DolzhnostKLica,
Telefon = Telefon,
Faks = faks,
Email = email,
IDFormaSob = FormaSob,
IDSfera = Sfera,
IDShtat = Shtat
};
ugtu_db.Predpriyatie.InsertOnSubmit(res);
ugtu_db.SubmitChanges();
return RedirectToAction("Predpriyatie");//
}
private void detach_Predpriyatie(Predpriyatie entity)
{
this.SendPropertyChanging();
entity.FormaSob = null;
}
private void attach_Predpriyatie(Predpriyatie entity)
{
this.SendPropertyChanging();
entity.Shtat = this;
}
private void detach_Predpriyatie(Predpriyatie entity)
{
this.SendPropertyChanging();
entity.Address = null;
}
partial void DeletePredpriyatie(Predpriyatie instance);
partial void UpdatePredpriyatie(Predpriyatie instance);
partial void InsertPredpriyatie(Predpriyatie instance);
public ActionResult AddPredpriyatieSave(PredpriyatieModel Pred)
{
try
{
int? idAdres = null;
if (ModelState.IsValid)
{
if (Pred.IDGorod != 0)
{
AddressCZS adress = new AddressCZS()
{
id_gorod = (int)Pred.IDGorod,
//dom=Pred.Addres_dom,
//korpus=Pred.Addres_korp,
addressName = Pred.Addres_ul,
index = Pred.index
//kv=Pred.Addres_kv
};
ugtu_db.AddressCZS.InsertOnSubmit(adress);
ugtu_db.SubmitChanges();
idAdres = (int)ugtu_db.AddressCZS.Select(m => m.id_address).Max();
}
Predpriyatie res = new Predpriyatie()
{
Name = Pred.NamePred,
//FIORuk = Pred.FIORuk,
//IDDolznostRuk = Pred.IDDolznostRuk,
//KontaktLico = Pred.KontactLico,
//IDDolznostKLico = Pred.IDDolznostKLico,
//Telefon = Pred.Telefon,
//Faks = Pred.Faks,
//Email = Pred.Email,
//KontaktTelefon = Pred.TelefonKL,
//KontaktFaks = Pred.FaksKL,
//KontaktEmail = Pred.EmailKL,
//IDFormaSob = Pred.IDFormaSob,
IDSfera = Pred.IDNameSfera,
IDShtat = Pred.IDShtat,
IDAddress = idAdres,
//IDDolznostKLicoTr = Pred.IDDolznostKLicoTr,
//KontaktLicoTr = Pred.FIOKLTr,
//KontaktEmailTr = Pred.EmailKLTr,
//KontaktFaksTr = Pred.FaksKLTr,
//KontaktTelefonTr = Pred.TelefonKLTr,
WebSite=Pred.site
};
ugtu_db.Predpriyatie.InsertOnSubmit(res);
ugtu_db.SubmitChanges();
return RedirectToAction("PredpriyatieInfo", new { id = res.IDPredpriyatie });
}
else
{
return RedirectToAction("AddPredpriyatie");
}
}catch(Exception){
return View("Error");
}
}
private void detach_Predpriyatie2(Predpriyatie entity)
{
this.SendPropertyChanging();
entity.Dolznost2 = null;
}
private void attach_Predpriyatie1(Predpriyatie entity)
{
this.SendPropertyChanging();
entity.Dolznost1 = this;
}
private void attach_Predpriyatie(Predpriyatie entity)
{
this.SendPropertyChanging();
entity.AddressCZS = this;
}
public string AddPred(PredpriyatieModel Pred)
{
int? idAdres = null;
if (ModelState.IsValid)
{
try
{
if (Pred.IDGorod != 0)
{
AddressCZS adress = new AddressCZS()
{
id_gorod = (int)Pred.IDGorod,
//dom = Pred.Addres_dom,
//korpus = Pred.Addres_korp,
addressName = Pred.Addres_ul,
index = Pred.index
//kv = Pred.Addres_kv
};
ugtu_db.AddressCZS.InsertOnSubmit(adress);
ugtu_db.SubmitChanges();
idAdres = (int)ugtu_db.AddressCZS.Select(m => m.id_address).Max();
}
Predpriyatie res = new Predpriyatie()
{
Name = Pred.NamePred,
//FIORuk = Pred.FIORuk,
//IDDolznostRuk = Pred.IDDolznostRuk,
//KontaktLico = Pred.KontactLico,
//IDDolznostKLico = Pred.IDDolznostKLico,
//Telefon = Pred.Telefon,
//Faks = Pred.Faks,
//Email = Pred.Email,
//KontaktTelefon = Pred.TelefonKL,
//KontaktFaks = Pred.FaksKL,
//KontaktEmail = Pred.EmailKL,
IDSfera = Pred.IDNameSfera,
IDShtat = Pred.IDShtat,
IDAddress = idAdres,
WebSite=Pred.site,
//KontaktLicoTr = Pred.FIOKLTr,
//IDDolznostKLicoTr = Pred.IDDolznostKLicoTr,
//KontaktTelefonTr = Pred.TelefonKLTr,
//KontaktFaksTr = Pred.FaksKLTr,
//KontaktEmailTr = Pred.EmailKLTr
};
ugtu_db.Predpriyatie.InsertOnSubmit(res);
ugtu_db.SubmitChanges();
return ugtu_db.Predpriyatie.Where(m => m.Name == Pred.NamePred).Select(m => m.IDPredpriyatie).Single().ToString();
}
catch (Exception)
{
return ("Данное предприятие уже существует");
}
}
else
{
return ("Ошибка. Длина поля больше 100 символов");
}
}
public string AddPred(PredpriyatieModel Pred)
{
int? idAdres = null;
if (ModelState.IsValid)
{
try
{
if (Pred.IDGorod != 0)
{
AddressCZS adress = new AddressCZS()
{
id_gorod = (int)Pred.IDGorod,
addressName = Pred.Addres_ul
};
ugtu_db.AddressCZS.InsertOnSubmit(adress);
ugtu_db.SubmitChanges();
idAdres = (int)ugtu_db.AddressCZS.Select(m => m.id_address).Max();
}
Predpriyatie res = new Predpriyatie()
{
Name = Pred.NamePred,
FIORuk = Pred.FIORuk,
IDDolznostRuk = Pred.IDDolznostRuk,
KontaktLico = Pred.KontactLico,
DolznostKLico = Pred.DolznostKLico,
Telefon = Pred.Telefon,
Faks = Pred.Faks,
Email = Pred.Email,
KontaktTelefon = Pred.TelefonKL,
KontaktFaks = Pred.FaksKL,
KontaktEmail = Pred.EmailKL,
//IDFormaSob = Pred.IDFormaSob,
IDSfera = Pred.IDNameSfera,
IDShtat = Pred.IDShtat,
IDAddress = idAdres
};
ugtu_db.Predpriyatie.InsertOnSubmit(res);
ugtu_db.SubmitChanges();
return ugtu_db.Predpriyatie.Where(m => m.Name == Pred.NamePred).Select(m => m.IDPredpriyatie).First().ToString();
}
catch (Exception)
{
return ("Данное предприятие уже существует");
}
}
else
{
return ("Ошибка. Длина поля больше 100 символов");
}
}
