public async Task <ActionResult> DeleteConfirmed(int id)
{
DepoHareket depoHareket = await db.DepoHarekets.FindAsync(id);
db.DepoHarekets.Remove(depoHareket);
await db.SaveChangesAsync();
return(RedirectToAction("Index"));
}
public async Task <ActionResult> Edit([Bind(Include = "DepoHareketId,CihazID,DegpoGelis,DepoGidis,GelisTarihi,CikisTarihi,ProjeID,Durum")] DepoHareket depoHareket)
{
if (ModelState.IsValid)
{
db.Entry(depoHareket).State = EntityState.Modified;
await db.SaveChangesAsync();
return(RedirectToAction("Index"));
}
return(View(depoHareket));
}
public async Task <ActionResult> Create([Bind(Include = "DepoHareketId,CihazID,DegpoGelis,DepoGidis,GelisTarihi,CikisTarihi,ProjeID,Durum")] DepoHareket depoHareket)
{
if (ModelState.IsValid)
{
db.DepoHarekets.Add(depoHareket);
await db.SaveChangesAsync();
return(RedirectToAction("Index"));
}
return(View(depoHareket));
}
// GET: DepoHarekets/Delete/5
public async Task <ActionResult> Delete(int?id)
{
if (id == null)
{
return(new HttpStatusCodeResult(HttpStatusCode.BadRequest));
}
DepoHareket depoHareket = await db.DepoHarekets.FindAsync(id);
if (depoHareket == null)
{
return(HttpNotFound());
}
return(View(depoHareket));
}
public ActionResult GetDepoHareketler()
{
string strcon = ConfigurationManager.ConnectionStrings["dbconnection"].ConnectionString;
List <DepoHareket> yonetim = new List <DepoHareket>();
string FirmaID = Session["FirmaID"].ToString();
string sorg = @"set dateformat dmy;select s.IslemTarih as IslemTarihiF2,* from STORE_PROCESS s,STORE_PROCESS_DETAIL d where d.DepoIslemID = s.ID and s.FirmaID=" + Session["FirmaID"].ToString();
using (SqlConnection con = new SqlConnection(strcon))
{
con.Open();
using (SqlCommand dekontgetir = new SqlCommand(sorg, con))
{
using (SqlDataReader dr = dekontgetir.ExecuteReader())
{
while (dr.Read())
{
DepoHareket yt = new DepoHareket();
yt.IslemNo = dr["IslemKodu"].ToString();
yt.IslemTuru = dr["IslemTipi"].ToString();
yt.IslemTarih = Convert.ToDateTime(dr["IslemTarihiF2"].ToString()).ToString("dd.MM.yyyy");
yt.TarihF2 = Convert.ToDateTime(dr["IslemTarihiF2"].ToString()).ToString("dd.MM.yyyy");
int urunid = Convert.ToInt32(dr["urunID"].ToString());
Stok st = db.Stok.Where(x => x.ID == urunid).FirstOrDefault();
yt.UrunAdi = st.UrunAdi;
yt.UrunKodu = st.StokKodu;
yt.Miktar = Convert.ToDecimal(dr["urunMiktar"].ToString()).ToString("N2");
yt.Fiyat = Convert.ToDecimal(dr["urunFiyat"].ToString()).ToString("N2");
yt.Tutar = Convert.ToDecimal(dr["Tutar"].ToString()).ToString("N2");
yt.Aciklama = dr["Aciklama"].ToString();
int personelid = Convert.ToInt32(dr["personelID"].ToString());
Personel pr = db.Personel.Where(x => x.ID == personelid).FirstOrDefault();
yt.Personel = (pr.Adi + " " + pr.Soyadi).TrimEnd();
int gdepoid = Convert.ToInt32(dr["GonderenDepoID"].ToString());
yt.AlanDepoID = dr["AlanDepoID"].ToString();
yt.GonderenDepoID = dr["GonderenDepoID"].ToString();
if (gdepoid != -1)
{
STORE depo = db.STORE.Where(x => x.ID == gdepoid).FirstOrDefault();
yt.GonderenDepo = depo.DepoAdi;
yt.IslemTuru = "Depo Çıkışı";
}
else
{
yt.GonderenDepo = "";
}
int adepoid = Convert.ToInt32(dr["AlanDepoID"].ToString());
if (adepoid != -1)
{
STORE depo = db.STORE.Where(x => x.ID == adepoid).FirstOrDefault();
yt.AlanDepo = depo.DepoAdi;
yt.IslemTuru = "Depo Girişi";
}
else
{
yt.AlanDepo = "";
}
yt.ID = dr["ID"].ToString();
if (adepoid != -1 && gdepoid != -1)
{
yt.IslemTuru = "Depo Transfer";
}
yonetim.Add(yt);
}
}
}
}
return(Json(new { data = yonetim.ToList() }, JsonRequestBehavior.AllowGet));
}
