public ActionResult DepoTransfer(int id = -1) { AyarMetot.Siradaki("", "Transfer", "IslemKodu", Session["FirmaID"].ToString()); ViewBag.depoKoduSiradaki = AyarMetot.GetNumara; STORE_PROCESS str = new STORE_PROCESS(); return(View(str)); }
public ActionResult DepoTransferleri(STORE_PROCESS data, string json, string islemtipi) { STORE_PROCESS tk = new STORE_PROCESS(); string KdvDh = "H"; int SiparisID = -1; string Message = "Kayıt Eklendi"; if (data.ID == -1) { tk = data; if (islemtipi == "depogiris") { tk.GonderenDepoID = -1; } else if (islemtipi == "depocikis") { tk.AlanDepoID = -1; } tk.Donem = DateTime.Now.Year.ToString(); tk.KayitPersonelID = Convert.ToInt32(Session["PersonelID"].ToString()); tk.KayitTarih = DateTime.Now; tk.Kur = 1; tk.DolarKur = 1; tk.IslemTarih = Convert.ToDateTime(tk.IslemTarih).ToString("dd.MM.yyyy"); tk.EuroKur = 1; tk.GirisTuru = "Müşteriden Gelen"; tk.TCariID = -1; tk.FirmaID = Convert.ToInt16(Session["FirmaID"].ToString()); string firmaid2 = Session["FirmaID"].ToString(); string company_code = "SA01" + firmaid2.PadLeft(3, '0'); tk.Company_Code = company_code; if (tk.Tutar == null) { tk.Tutar = 0; } db.STORE_PROCESS.Add(tk); db.SaveChanges(); using (SqlConnection conp1 = new SqlConnection(AyarMetot.strcon)) { string srg = @"select top (1) ID FROM STORE_PROCESS Order BY ID Desc"; if (conp1.State == ConnectionState.Closed) { conp1.Open(); } using (SqlCommand sID = new SqlCommand(srg, conp1)) { SiparisID = Convert.ToInt32(sID.ExecuteScalar()); } } } else { tk = db.STORE_PROCESS.Where(x => x.ID == data.ID).FirstOrDefault <STORE_PROCESS>(); if (islemtipi == "depogiris") { tk.GonderenDepoID = -1; } else if (islemtipi == "depocikis") { tk.AlanDepoID = -1; } tk.Donem = DateTime.Now.Year.ToString(); tk.KayitPersonelID = Convert.ToInt32(Session["PersonelID"].ToString()); tk.KayitTarih = DateTime.Now; tk.IslemTarih = Convert.ToDateTime(tk.IslemTarih).ToString("dd.MM.yyyy"); tk.Kur = 1; tk.DolarKur = 1; tk.EuroKur = 1; tk.GirisTuru = "Müşteriden Gelen"; tk.TCariID = -1; tk.FirmaID = Convert.ToInt16(Session["FirmaID"].ToString()); string firmaid2 = Session["FirmaID"].ToString(); string company_code = "SA01" + firmaid2.PadLeft(3, '0'); tk.Company_Code = company_code; db.SaveChanges(); Message = "Kayıt Güncellendi"; } json = "[" + json + "]"; List <STORE_PROCESS_DETAIL> items = JsonConvert.DeserializeObject <List <STORE_PROCESS_DETAIL> >(json); for (int i = 0; i < items.Count; i++) { STORE_PROCESS_DETAIL er = items[i]; decimal Kdv = Convert.ToDecimal(er.KDV); try { if (er.ID.ToString() == "-1" || er.ID.ToString() == "0") { using (SqlConnection con = new SqlConnection(AyarMetot.strcon)) { if (con.State == ConnectionState.Closed) { con.Open(); } using (SqlDataAdapter da = new System.Data.SqlClient.SqlDataAdapter("select Top 1 * from STORE_PROCESS_DETAIL", con)) { using (SqlCommandBuilder cb = new SqlCommandBuilder(da)) { DataSet ds = new DataSet(); da.Fill(ds, "STORE_PROCESS_DETAIL"); DataRow df = ds.Tables["STORE_PROCESS_DETAIL"].NewRow(); df["DepoIslemID"] = SiparisID; df["IslemTarihi"] = DateTime.Now; df["gDepoID"] = tk.GonderenDepoID; df["aDepoID"] = tk.AlanDepoID; df["personelID"] = tk.personelID; df["urunID"] = er.urunID; df["urunFiyat"] = er.urunFiyat; df["urunMiktar"] = er.urunMiktar; df["urunBirim"] = er.urunBirim; df["paraBirimi"] = tk.paraBirimi; df["Kur"] = tk.Kur; df["Donem"] = DateTime.Now.Year; df["IslemTipi"] = "Depo İşlem"; df["KDV"] = er.KDV; df["Aciklama"] = er.Aciklama; df["GirisTuru"] = tk.GirisTuru; df["TCariID"] = -1; df["TakimID"] = -1; df["KodID"] = -1; df["SiparisIDHFT"] = -1; df["FirmaID"] = tk.FirmaID; df["Company_Code"] = tk.Company_Code; ds.Tables["STORE_PROCESS_DETAIL"].Rows.Add(df); da.Update(ds, "STORE_PROCESS_DETAIL"); } } } } else { using (SqlConnection con = new SqlConnection(AyarMetot.conString)) { if (con.State == ConnectionState.Closed) { con.Open(); } using (SqlDataAdapter da = new System.Data.SqlClient.SqlDataAdapter( "select * from STORE_PROCESS_DETAIL where ID='" + er.ID + "'", con)) { using (SqlCommandBuilder cb = new SqlCommandBuilder(da)) { DataSet ds = new DataSet(); da.Fill(ds, "STORE_PROCESS_DETAIL"); DataRow[] adf = ds.Tables["STORE_PROCESS_DETAIL"].Select("ID='" + er.ID + "'"); if (adf.Length != 0) { DataRow df = adf[0]; df["DepoIslemID"] = SiparisID; df["IslemTarihi"] = Convert.ToDateTime(data.IslemTarih); df["gDepoID"] = tk.GonderenDepoID; df["aDepoID"] = tk.AlanDepoID; df["personelID"] = tk.personelID; df["urunID"] = er.urunID; df["urunFiyat"] = er.urunFiyat; df["urunMiktar"] = er.urunMiktar; df["urunBirim"] = er.urunBirim; df["paraBirimi"] = tk.paraBirimi; df["Kur"] = tk.Kur; df["Donem"] = DateTime.Now.Year; df["IslemTipi"] = "Depo İşlem"; df["KDV"] = er.KDV; df["Aciklama"] = er.Aciklama; df["GirisTuru"] = tk.GirisTuru; df["TCariID"] = -1; df["TakimID"] = -1; df["KodID"] = -1; df["SiparisIDHFT"] = -1; df["FirmaID"] = tk.FirmaID; df["Company_Code"] = tk.Company_Code; ds.Tables["STORE_PROCESS_DETAIL"].Rows.Add(df); da.Update(ds, "STORE_PROCESS_DETAIL"); } } } } } } catch (Exception E1) { try { System.IO.File.WriteAllText(Path.Combine(@"C:\Users\Alperen\AppData\Local\Sayazilim", "sonuç.xml"), E1.ToString()); } catch { } } } var result = new { sonuc = 1, Message = Message }; return(Json(result, JsonRequestBehavior.AllowGet)); }