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 символов"); } }