public ActionResult YeniTahsilat(int id = 0)
{
ViewBag.vKasaID = Session["vKasaID"].ToString();
ViewBag.vBankaID = Session["vBankaID"].ToString();
AyarMetot.Siradaki("", "TAHSILAT", "IslemNo", Session["FirmaID"].ToString());
ViewBag.MasrafSiradakiNo = AyarMetot.GetNumara;
if (Session["Grubu"].ToString() != "Teknik Servis Kullanıcısı")
{
if (id != 0)
{
CASH_PAY cp = db.CASH_PAY.Where(x => x.ID == id).FirstOrDefault <CASH_PAY>();
if (cp.IslemTipi != "KAF" && cp.IslemTipi != "BAF")
{
return(View(cp));
}
else
{
return(RedirectToAction("FinansHareketleri", "Finans"));
}
}
else
{
return(View(new CASH_PAY()));
}
}
else
{
try
{
TECHNICAL tech = db.TECHNICAL.Where(x => x.ID == id).FirstOrDefault <TECHNICAL>();
ViewBag.ServisCariID = tech.CariID;
}
catch
{
}
try
{
ViewBag.ServisPersonelID = Session["PersonelID"].ToString();
int idpersonel = Convert.ToInt32(Session["PersonelID"].ToString());
Personel pr = db.Personel.Where(x => x.ID == idpersonel).FirstOrDefault <Personel>();
ViewBag.PersonelKasaId = pr.vKasaID;
ViewBag.PersonelBankaId = pr.vBankaID;
}
catch
{
}
return(View(new CASH_PAY()));
}
}
public JsonResult yeniTahsilat(
string IslemTipi,
int id,
int CariID,
string IslemNo,
string Aciklama,
string Tutar,
string ThisKasaID,
string ThisBankaID,
string parabirimi,
string Personel,
int OzelKodID,
int durum = -1
)
{
var result = new { sonuc = 0, Message = "Eklenmedi", cid = -1 };
decimal TutarDecimal = decimal.Parse(Tutar, CultureInfo.InvariantCulture);
CASH_PAY cs = new CASH_PAY();
if (durum == -1)
{
cs.IslemTipi = IslemTipi;
cs.IslemNo = "1";
cs.IslemTarih = DateTime.Now.ToString();
cs.CariID = CariID;
cs.ParaBirimi = parabirimi;
if (Personel != "")
{
cs.PersonelID = Convert.ToInt32(Personel);
}
else
{
cs.PersonelID = Convert.ToInt32(Session["PersonelID"]);
}
cs.KayitPersonelID = 1;
cs.exRate = 1;
cs.PrimOr = 0;
cs.KasaID = -1;
cs.BankaID = -1;
cs.KrediKartiID = -1;
cs.AdisYonTahsilatID = -1;
cs.IslemNo = IslemNo;
cs.OzelKodID = OzelKodID;
cs.OzelKodKdv = -1;
cs.Aciklama = Aciklama;
cs.TaksitSayisi = 1;
cs.ParaBirimi = parabirimi;
if (parabirimi == "")
{
cs.ParaBirimi = "TL";
}
cs.Tutar = TutarDecimal;
int kasaID = -1;
int bankaID = -1;
int kkID = -1;
if (IslemTipi == "T" || IslemTipi == "O")
{
kasaID = Convert.ToInt32(ThisKasaID);
bankaID = -1;
kkID = -1;
}
else if (IslemTipi == "G" || IslemTipi == "KKT" || IslemTipi == "H")
{
kasaID = -1;
bankaID = Convert.ToInt32(ThisBankaID);
kkID = -1;
}
cs.KasaID = kasaID;
cs.BankaID = bankaID;
cs.KrediKartiID = kkID;
cs.OzelKodID = OzelKodID;
cs.OzelKodKdv = 0;
cs.TaksitSayisi = 1;
cs.ParaBirimi = parabirimi;
cs.Tutar = TutarDecimal;
cs.gTutar = 0;
cs.gParaBirimi = parabirimi;
cs.aTutar = 0;
cs.aParaBirimi = "";
cs.gonderenID = -1;
cs.gonderenType = "";
cs.alanID = -1;
cs.alanType = "";
cs.AlanCariID = -1;
cs.KayT = DateTime.Now.ToString();
cs.DegT = DateTime.Now.ToString();
cs.Donem = DateTime.Now.Year.ToString();
cs.HavaleMasrafID = -1;
cs.CekSenetID = -1;
cs.CariBankaKID = -1;
cs.ProjeID = -1;
cs.SantiyeID = -1;
cs.AracPlaka = "";
cs.FirmaID = Convert.ToInt16(Session["FirmaID"].ToString());
string firmaid = Session["FirmaID"].ToString();
string company_code = "SA01" + firmaid.PadLeft(3, '0');
cs.Company_Code = company_code;
try
{
cs.Plaka2 = "";
}
catch { }
db.CASH_PAY.Add(cs);
db.SaveChanges();
int cid = -1;
using (SqlConnection conp1 = new SqlConnection(AyarMetot.strcon))
{
if (conp1.State == ConnectionState.Closed)
{
conp1.Open();
}
using (SqlCommand sID = new SqlCommand(@"select top (1) ID FROM
CASH_PAY where PersonelID=" + Session["PersonelID"] + " Order BY ID Desc", conp1))
{
cid = Convert.ToInt32(sID.ExecuteScalar());
}
}
result = new { sonuc = 1, Message = "Kayıt Eklendi", cid = cid };
}
else if (durum == 0)
{
var tahsilatlist = db.CASH_PAY.Where(x => x.ID == id).ToList();
foreach (var item in tahsilatlist)
{
item.IslemNo = IslemNo;
item.IslemTipi = IslemTipi;
item.CariID = CariID;
item.Tutar = TutarDecimal;
item.OzelKodID = OzelKodID;
int kasaID = -1;
int bankaID = -1;
int kkID = -1;
if (IslemTipi == "G" || IslemTipi == "KKT" || IslemTipi == "H")
{
if (ThisBankaID != "")
{
bankaID = Convert.ToInt32(ThisBankaID);
item.BankaID = bankaID;
}
}
else if (IslemTipi == "T" || IslemTipi == "O")
{
if (ThisKasaID != "")
{
kasaID = Convert.ToInt32(ThisKasaID);
item.KasaID = kasaID;
}
}
item.ParaBirimi = parabirimi;
}
int cid = -1;
using (SqlConnection conp1 = new SqlConnection(AyarMetot.strcon))
{
if (conp1.State == ConnectionState.Closed)
{
conp1.Open();
}
using (SqlCommand sID = new SqlCommand(@"select top (1) ID FROM
CASH_PAY where PersonelID=" + Session["PersonelID"] + " Order BY ID Desc", conp1))
{
cid = Convert.ToInt32(sID.ExecuteScalar());
}
}
db.SaveChanges();
result = new { sonuc = 1, Message = "Kayıt Güncellendi", cid = cid };
}
return(Json(result, JsonRequestBehavior.AllowGet));
}
