public void EditFirm(int id, string name) { FIRM slc_firm = db.FIRMS.Find(id); slc_firm.NAME = name; db.SaveChanges(); }
protected void Page_Load(object sender, EventArgs e) { if (!Page.IsPostBack) { if (IsValidQueryString("ID")) { Guid ID = Guid.Empty; if (Guid.TryParse(Request.QueryString["ID"], out ID)) { using (db = new novartz_stajyer1Entities()) { FillDrp(DrpDepartment, db.FIRMDEPARTMENT.Where(t => t.FIRMID == ID).ToList(), "ID", "NAME", "Seçiniz"); FIRM firm = db.FIRM.SingleOrDefault(t => t.ID == ID); RECID = firm.ID; lblNAME.Text = firm.NAME; TEMPRESERVATION.MEMBERID = CURRENTMEMBER.ID; TEMPRESERVATION.TYPERESERVATIONSTATUSID = (byte)1; // Yeni randevu } } } else { Response.Redirect("/Firm/FirmList.aspx"); } } }
public ActionResult DeleteConfirmed(int id) { FIRM fIRM = db.FIRMS.Find(id); db.FIRMS.Remove(fIRM); db.SaveChanges(); return(RedirectToAction("Index")); }
public ActionResult Edit([Bind(Include = "OBJECTID,NAME")] FIRM fIRM) { if (ModelState.IsValid) { db.Entry(fIRM).State = EntityState.Modified; db.SaveChanges(); return(RedirectToAction("Index")); } return(View(fIRM)); }
public void AddFirm(string name) { FIRM new_firm = new FIRM { NAME = name }; db.FIRMS.Add(new_firm); db.SaveChanges(); }
public ActionResult Create([Bind(Include = "OBJECTID,NAME")] FIRM fIRM) { if (ModelState.IsValid) { db.FIRMS.Add(fIRM); db.SaveChanges(); return(RedirectToAction("Index")); } return(View(fIRM)); }
// GET: AgroPark/FIRMs/Delete/5 public ActionResult Delete(int?id) { if (id == null) { return(new HttpStatusCodeResult(HttpStatusCode.BadRequest)); } FIRM fIRM = db.FIRMS.Find(id); if (fIRM == null) { return(HttpNotFound()); } return(View(fIRM)); }
protected void btnSave_Click(object sender, EventArgs e) { using (db = new novartz_stajyer1Entities()) { FIRM rec = db.FIRM.SingleOrDefault(t => t.ID == RECID); rec.NAME = txtFirmName.Text; rec.DESCRIPTION = txtFirmOwner.Text; rec.TYPESEKTORID = Convert.ToByte(drpFirmSector.SelectedValue); rec.ADRESS = txtFirmAddress.Text; rec.PHONE = txtFirmPhone.Text; rec.EMAIL = txtFirmEmail.Text; rec.CITYID = Convert.ToByte(drpFirmCity.SelectedValue); //byte gönderdiğin için onu byte çevirmesi lazım rec.CITYDISTRICTID = Convert.ToInt16(drpFirmCityDistrict.SelectedValue); // citydistrictid smallint olduğu için toınt16 ya çevirdik bytedan büyük7 //db.FIRM.Add(rec); bu fonksiyonu eklersen de yeni kayıt ekleme yapar db.SaveChanges(); } InitPage(false); }
public void FirmRegistion(string Firmname, string Firmowner, string sector, string city, string citydistrict, string address, string phone, string mail) { FIRM rec = null; using (db = new novartz_stajyer1Entities()) { rec = new FIRM { ID = Guid.NewGuid(), NAME = Firmname, DESCRIPTION = Firmowner, PHONE = phone, EMAIL = mail, TYPESEKTORID = Convert.ToByte(sector), CITYID = Convert.ToByte(city), CITYDISTRICTID = Convert.ToInt16(citydistrict), ADRESS = address }; db.FIRM.Add(rec); db.SaveChanges(); }; }