public JsonResult SatisIade_Onay(SatisIadeOnayList tbl)
{
var result = new Result();
try
{
string[] ids = tbl.ID.Split(',');
var yns = new YeniNesil(SqlExper, vUser.SirketKodu);
yns.SatisIadeOnay(new SatisIadeOnay
{
IadeNo = ids[0],
IadeTarih = ids[1],
Onay = true,
Kaydeden = vUser.UserName,
tbl = tbl
});
result = new Result(true, 1);
return(Json(result, JsonRequestBehavior.AllowGet));
}
catch (Exception ex)
{
Logger(ex, "YN/OnayBekleyenler/SatisIade_Onay");
return(Json(new Result(false, "Hata Oluştu"), JsonRequestBehavior.AllowGet));
}
}
public JsonResult Tahsilat_Onay(string ID, bool Onay)
{
var result = new Result();
try
{
if (Onay == true)
{
var item = db.Database.SqlQuery <frmOnayTahsilatList>(string.Format(@"
SELECT TahsilatNo, HesapKodu, CAR002_Unvan1 AS Unvan,
CONVERT(VARCHAR(15), CAST(TahsilatTarihi - 2 AS datetime), 104) as Tarih,
CASE IslemTuru WHEN 0 THEN 'Tahsilat' WHEN 1 THEN 'İskonto' END as IslemTuru,
CASE OdemeTuru WHEN 0 THEN 'Nakit' WHEN 1 THEN 'Kredi Kartı' END as OdemeTuru,
Tutar, DovizCinsi, KapatilanTL, KapatilanUSD, KapatilanEUR, Kaydeden, Aciklama,
ISNULL(DvzEfektisSatis1,0) AS USDKur , ISNULL(DvzEfektisSatis2,0) AS EURKur
FROM YNS{0}.YNS{0}.TahsilatMobil(NOLOCK)
LEFT JOIN YNS{0}.YNS{0}.CAR002 ON TahsilatMobil.HesapKodu = CAR002_HesapKodu
WHERE TahsilatNo='{1}'" , vUser.SirketKodu, ID)).FirstOrDefault();
var yns = new YeniNesil(SqlExper, vUser.SirketKodu);
result = yns.TahsilatKaydet(item, vUser.UserName);
}
if (result.Status == true)
{
db.Database.ExecuteSqlCommand(string.Format("UPDATE YNS{0}.YNS{0}.[TahsilatMobil] SET IslemDurumu = '{1}' WHERE TahsilatNo='{2}'", vUser.SirketKodu, Onay == true ? 1 : 2, ID));
}
return(Json(result, JsonRequestBehavior.AllowGet));
}
catch (Exception ex)
{
Logger(ex, "YN/OnayBekleyenler/Tahsilat_Onay");
return(Json(new Result(false, "Hata Oluştu"), JsonRequestBehavior.AllowGet));
}
}
public JsonResult Fatura_Onay(string ID, bool Onay)
{
var result = new Result();
try
{
if (Onay == true)
{
var list = db.Database.SqlQuery <SepetUrun>(string.Format("SELECT 1 AS SatirTip, HesapKodu, UrunKodu, Birim, CONVERT(varchar(50), Miktar) as Miktar, CONVERT(varchar(50), Fiyat) as Fiyat, Depo, ParaCinsi, '{2}' AS KullaniciKodu, Kaydeden FROM YNS{0}.YNS{0}.TempFatura WHERE (EvrakNo = '{1}') AND (IslemDurumu = 0)", vUser.SirketKodu, ID, vUser.UserName)).ToList();
var yns = new YeniNesil(SqlExper, vUser.SirketKodu);
var sepetIslemleri = yns.FaturaKaydet(list);
result = new Result(true, 1);
}
if (result.Status == true)
{
db.Database.ExecuteSqlCommand(string.Format("UPDATE YNS{0}.YNS{0}.[TempFatura] SET IslemDurumu={1} WHERE EvrakNo='{2}'", vUser.SirketKodu, Onay == true ? 1 : 2, ID));
db.Database.ExecuteSqlCommand(string.Format("UPDATE YNS{0}.YNS{0}.[STK005] SET STK005_Kod12=datediff(d,0,getdate()+2), STK005_Kod3='{1}' WHERE STK005_EvrakSeriNo='{2}'", vUser.SirketKodu, vUser.UserName, ID));
}
return(Json(result, JsonRequestBehavior.AllowGet));
}
catch (Exception ex)
{
Logger(ex, "YN/OnayBekleyenler/Fatura_Onay");
return(Json(new Result(false, "Hata Oluştu"), JsonRequestBehavior.AllowGet));
}
}
