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