public ActionResult DeleteConfirmed(int id)
{
PersoneleKayitliEnvanter personeleKayitliEnvanter = db.PersoneleKayitliEnvanter.Find(id);
db.PersoneleKayitliEnvanter.Remove(personeleKayitliEnvanter);
db.SaveChanges();
return(RedirectToAction("Index"));
}
public ActionResult Edit([Bind(Include = "ID,PersonelAdi,PersonelSoyAdi,Envanter1,Envanter2,Envanter3,Envanter4,Envanter5,Envanter6,Envanter7")] PersoneleKayitliEnvanter personeleKayitliEnvanter)
{
if (ModelState.IsValid)
{
db.Entry(personeleKayitliEnvanter).State = EntityState.Modified;
db.SaveChanges();
return(RedirectToAction("Index"));
}
return(View(personeleKayitliEnvanter));
}
public ActionResult Create([Bind(Include = "ID,PersonelAdi,PersonelSoyAdi,Envanter1,Envanter2,Envanter3,Envanter4,Envanter5,Envanter6,Envanter7")] PersoneleKayitliEnvanter personeleKayitliEnvanter)
{
if (ModelState.IsValid)
{
db.PersoneleKayitliEnvanter.Add(personeleKayitliEnvanter);
db.SaveChanges();
return(RedirectToAction("Index"));
}
return(View(personeleKayitliEnvanter));
}
// GET: PersoneleKayitliEnvanter/Details/5
public ActionResult Details(int?id)
{
if (id == null)
{
return(new HttpStatusCodeResult(HttpStatusCode.BadRequest));
}
PersoneleKayitliEnvanter personeleKayitliEnvanter = db.PersoneleKayitliEnvanter.Find(id);
if (personeleKayitliEnvanter == null)
{
return(HttpNotFound());
}
return(View(personeleKayitliEnvanter));
}
// GET: Sayac
public ActionResult Index()
{
int klavyeSayac = 0;
int mouseSayac = 0;
int kasaSayac = 0;
int laptopSayac = 0;
int monitorSayac = 0;
int yaziciSayac = 0;
string cs = ConfigurationManager.ConnectionStrings["OtokarContext"].ConnectionString;
using (SqlConnection con = new SqlConnection(cs))
{
SqlCommand cmd = new SqlCommand("Select * from PersoneleKayitliEnvanter", con);
con.Open();
SqlDataReader rdr = cmd.ExecuteReader();
while (rdr.Read())
{
PersoneleKayitliEnvanter d1 = new PersoneleKayitliEnvanter();
if (rdr["Envanter1"].ToString() == "Klavye")
{
klavyeSayac++;
}
if (rdr["Envanter2"].ToString() == "Klavye")
{
klavyeSayac++;
}
if (rdr["Envanter3"].ToString() == "Klavye")
{
klavyeSayac++;
}
if (rdr["Envanter4"].ToString() == "Klavye")
{
klavyeSayac++;
}
if (rdr["Envanter5"].ToString() == "Klavye")
{
klavyeSayac++;
}
if (rdr["Envanter6"].ToString() == "Klavye")
{
klavyeSayac++;
}
if (rdr["Envanter7"].ToString() == "Klavye")
{
klavyeSayac++;
}
if (rdr["Envanter1"].ToString() == "Mouse")
{
mouseSayac++;
}
if (rdr["Envanter2"].ToString() == "Mouse")
{
mouseSayac++;
}
if (rdr["Envanter3"].ToString() == "Mouse")
{
mouseSayac++;
}
if (rdr["Envanter4"].ToString() == "Mouse")
{
mouseSayac++;
}
if (rdr["Envanter5"].ToString() == "Mouse")
{
mouseSayac++;
}
if (rdr["Envanter6"].ToString() == "Mouse")
{
mouseSayac++;
}
if (rdr["Envanter7"].ToString() == "Mouse")
{
mouseSayac++;
}
if (rdr["Envanter1"].ToString() == "Kasa")
{
kasaSayac++;
}
if (rdr["Envanter2"].ToString() == "Kasa")
{
kasaSayac++;
}
if (rdr["Envanter3"].ToString() == "Kasa")
{
kasaSayac++;
}
if (rdr["Envanter4"].ToString() == "Kasa")
{
kasaSayac++;
}
if (rdr["Envanter5"].ToString() == "Kasa")
{
kasaSayac++;
}
if (rdr["Envanter6"].ToString() == "Kasa")
{
kasaSayac++;
}
if (rdr["Envanter7"].ToString() == "Kasa")
{
kasaSayac++;
}
if (rdr["Envanter1"].ToString() == "Laptop")
{
laptopSayac++;
}
if (rdr["Envanter2"].ToString() == "Laptop")
{
laptopSayac++;
}
if (rdr["Envanter3"].ToString() == "Laptop")
{
laptopSayac++;
}
if (rdr["Envanter4"].ToString() == "Laptop")
{
laptopSayac++;
}
if (rdr["Envanter5"].ToString() == "Laptop")
{
laptopSayac++;
}
if (rdr["Envanter6"].ToString() == "Laptop")
{
laptopSayac++;
}
if (rdr["Envanter7"].ToString() == "Laptop")
{
laptopSayac++;
}
if (rdr["Envanter1"].ToString() == "Monitör")
{
monitorSayac++;
}
if (rdr["Envanter2"].ToString() == "Monitör")
{
monitorSayac++;
}
if (rdr["Envanter3"].ToString() == "Monitör")
{
monitorSayac++;
}
if (rdr["Envanter4"].ToString() == "Monitör")
{
monitorSayac++;
}
if (rdr["Envanter5"].ToString() == "Monitör")
{
monitorSayac++;
}
if (rdr["Envanter6"].ToString() == "Monitör")
{
monitorSayac++;
}
if (rdr["Envanter7"].ToString() == "Monitör")
{
monitorSayac++;
}
if (rdr["Envanter1"].ToString() == "Yazıcı")
{
yaziciSayac++;
}
if (rdr["Envanter2"].ToString() == "Yazıcı")
{
yaziciSayac++;
}
if (rdr["Envanter3"].ToString() == "Yazıcı")
{
yaziciSayac++;
}
if (rdr["Envanter4"].ToString() == "Yazıcı")
{
yaziciSayac++;
}
if (rdr["Envanter5"].ToString() == "Yazıcı")
{
yaziciSayac++;
}
if (rdr["Envanter6"].ToString() == "Yazıcı")
{
yaziciSayac++;
}
if (rdr["Envanter7"].ToString() == "Yazıcı")
{
yaziciSayac++;
}
}
con.Close();
}
ViewBag.klavyeSay = klavyeSayac;
ViewBag.mouseSay = mouseSayac;
return(View());
}
// GET: StoktakiEnvanterSayisi
public ActionResult Index(string currentFilter, string searchString, int?page)
{
if (searchString != null)
{
page = 1;
}
else
{
searchString = currentFilter;
}
ViewBag.CurrentFilter = searchString;
var stoktakiEnvanters = from c in db.StoktakiEnvanterSayisi
select c;
if (!string.IsNullOrEmpty(searchString))
{
stoktakiEnvanters = stoktakiEnvanters.Where(c => c.EnvanterAdi.Contains(searchString));
}
stoktakiEnvanters = stoktakiEnvanters.OrderBy(c => c.ID);
int pageSize = 8;
int pageNumber = (page ?? 1);
int klavyeSayac = 0;
int mouseSayac = 0;
int kasaSayac = 0;
int laptopSayac = 0;
int monitorSayac = 0;
int yaziciSayac = 0;
string cs = ConfigurationManager.ConnectionStrings["OtokarContext"].ConnectionString;
using (SqlConnection con = new SqlConnection(cs))
{
SqlCommand cmd = new SqlCommand("Select * from PersoneleKayitliEnvanter", con);
con.Open();
SqlDataReader rdr = cmd.ExecuteReader();
while (rdr.Read())
{
PersoneleKayitliEnvanter d1 = new PersoneleKayitliEnvanter();
if (rdr["Envanter1"].ToString() == "Klavye")
{
klavyeSayac++;
}
if (rdr["Envanter2"].ToString() == "Klavye")
{
klavyeSayac++;
}
if (rdr["Envanter3"].ToString() == "Klavye")
{
klavyeSayac++;
}
if (rdr["Envanter4"].ToString() == "Klavye")
{
klavyeSayac++;
}
if (rdr["Envanter5"].ToString() == "Klavye")
{
klavyeSayac++;
}
if (rdr["Envanter6"].ToString() == "Klavye")
{
klavyeSayac++;
}
if (rdr["Envanter7"].ToString() == "Klavye")
{
klavyeSayac++;
}
if (rdr["Envanter1"].ToString() == "Mouse")
{
mouseSayac++;
}
if (rdr["Envanter2"].ToString() == "Mouse")
{
mouseSayac++;
}
if (rdr["Envanter3"].ToString() == "Mouse")
{
mouseSayac++;
}
if (rdr["Envanter4"].ToString() == "Mouse")
{
mouseSayac++;
}
if (rdr["Envanter5"].ToString() == "Mouse")
{
mouseSayac++;
}
if (rdr["Envanter6"].ToString() == "Mouse")
{
mouseSayac++;
}
if (rdr["Envanter7"].ToString() == "Mouse")
{
mouseSayac++;
}
if (rdr["Envanter1"].ToString() == "Kasa")
{
kasaSayac++;
}
if (rdr["Envanter2"].ToString() == "Kasa")
{
kasaSayac++;
}
if (rdr["Envanter3"].ToString() == "Kasa")
{
kasaSayac++;
}
if (rdr["Envanter4"].ToString() == "Kasa")
{
kasaSayac++;
}
if (rdr["Envanter5"].ToString() == "Kasa")
{
kasaSayac++;
}
if (rdr["Envanter6"].ToString() == "Kasa")
{
kasaSayac++;
}
if (rdr["Envanter7"].ToString() == "Kasa")
{
kasaSayac++;
}
if (rdr["Envanter1"].ToString() == "Laptop")
{
laptopSayac++;
}
if (rdr["Envanter2"].ToString() == "Laptop")
{
laptopSayac++;
}
if (rdr["Envanter3"].ToString() == "Laptop")
{
laptopSayac++;
}
if (rdr["Envanter4"].ToString() == "Laptop")
{
laptopSayac++;
}
if (rdr["Envanter5"].ToString() == "Laptop")
{
laptopSayac++;
}
if (rdr["Envanter6"].ToString() == "Laptop")
{
laptopSayac++;
}
if (rdr["Envanter7"].ToString() == "Laptop")
{
laptopSayac++;
}
if (rdr["Envanter1"].ToString() == "Monitör")
{
monitorSayac++;
}
if (rdr["Envanter2"].ToString() == "Monitör")
{
monitorSayac++;
}
if (rdr["Envanter3"].ToString() == "Monitör")
{
monitorSayac++;
}
if (rdr["Envanter4"].ToString() == "Monitör")
{
monitorSayac++;
}
if (rdr["Envanter5"].ToString() == "Monitör")
{
monitorSayac++;
}
if (rdr["Envanter6"].ToString() == "Monitör")
{
monitorSayac++;
}
if (rdr["Envanter7"].ToString() == "Monitör")
{
monitorSayac++;
}
if (rdr["Envanter1"].ToString() == "Yazıcı")
{
yaziciSayac++;
}
if (rdr["Envanter2"].ToString() == "Yazıcı")
{
yaziciSayac++;
}
if (rdr["Envanter3"].ToString() == "Yazıcı")
{
yaziciSayac++;
}
if (rdr["Envanter4"].ToString() == "Yazıcı")
{
yaziciSayac++;
}
if (rdr["Envanter5"].ToString() == "Yazıcı")
{
yaziciSayac++;
}
if (rdr["Envanter6"].ToString() == "Yazıcı")
{
yaziciSayac++;
}
if (rdr["Envanter7"].ToString() == "Yazıcı")
{
yaziciSayac++;
}
}
con.Close();
}
ViewBag.view1 = klavyeSayac;
ViewBag.view2 = mouseSayac;
ViewBag.view3 = kasaSayac;
ViewBag.view4 = laptopSayac;
ViewBag.view5 = monitorSayac;
ViewBag.view6 = yaziciSayac;
return(View(stoktakiEnvanters.ToPagedList(pageNumber, pageSize)));
}
