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();
};
}
