protected void grdTarifeler_RowCommand(object sender, GridViewCommandEventArgs e)
{
if (e.CommandName.Equals("del"))
{
string confirmValue = Request.Form["confirm_value"];
List <string> liste = confirmValue.Split(new char[] { ',' }).ToList();
int sayimiz = liste.Count - 1;
string deger = liste[sayimiz];
if (deger == "Yes")
{
string firma = KullaniciIslem.firma();
using (radiusEntities dc = MyContext.Context(firma))
{
int id = Convert.ToInt32(e.CommandArgument);
//alım iptal ediliyor
MakineIslem al = new MakineIslem(dc);
al.tarife_iptal(id);
string basS = datetimepicker6.Value;
string sonS = datetimepicker7.Value;
ortak(dc, basS, sonS);
System.Text.StringBuilder sb = new System.Text.StringBuilder();
sb.Append(@"<script type='text/javascript'>");
sb.Append(" alertify.error('Kayıt silindi!');");
sb.Append(@"</script>");
ScriptManager.RegisterClientScriptBlock(this, this.GetType(), "EditHideModalScript3", sb.ToString(), false);
}
}
}
}
protected void btnCariTel_Click(object sender, EventArgs e)
{
radiusEntities dc = MyContext.Context("TOL");
List <carihesap> cariler = dc.carihesaps.ToList();
if (cariler.Count > 0)
{
foreach (carihesap h in cariler)
{
customer c = dc.customers.FirstOrDefault(x => x.CustID == h.MusteriID);
if (c != null)
{
string tel = c.telefon;
if (!String.IsNullOrEmpty(tel))
{
h.telefon = tel;
}
string ad = c.Ad;
if (!String.IsNullOrEmpty(ad))
{
h.adi = ad;
}
}
}
KaydetmeIslemleri.kaydetR(dc);
}
}
protected void grdCihaz_SelectedIndexChanged(object sender, EventArgs e)
{
using (radiusEntities dc = MyContext.Context(KullaniciIslem.firma()))
{
CihazAraa(dc);
}
}
protected void GridView1_RowCommand(object sender, GridViewCommandEventArgs e)
{
if (e.CommandName.Equals("del"))
{
string confirmValue = Request.Form["confirm_value"];
if (confirmValue == "Yes")
{
int id = Convert.ToInt32(e.CommandArgument);
using (radiusEntities dc = MyContext.Context(KullaniciIslem.firma()))
{
Hareket s = new Hareket(dc);
s.odemeIptalR(id, User.Identity.Name);
goster(dc);
}
System.Text.StringBuilder sb = new System.Text.StringBuilder();
sb.Append(@"<script type='text/javascript'>");
sb.Append(" alertify.success('Kayıt silindi!');");
sb.Append(@"</script>");
ScriptManager.RegisterClientScriptBlock(this, this.GetType(), "EditHideModalScript3", sb.ToString(), false);
}
}
}
protected void GridView1_RowCommand(object sender, GridViewCommandEventArgs e)
{
if (e.CommandName.Equals("del"))
{
string confirmValue = Request.Form["confirm_value"];
List <string> liste = confirmValue.Split(new char[] { ',' }).ToList();
int sayimiz = liste.Count - 1;
string deger = liste[sayimiz];
if (deger == "Yes")
{
int paket_id = Convert.ToInt32(e.CommandArgument);
using (radiusEntities dc = MyContext.Context(KullaniciIslem.firma()))
{
ServisPaketli s = new ServisPaketli(dc);
s.paket_iptal(paket_id);
goster(dc);
}
System.Text.StringBuilder sb = new System.Text.StringBuilder();
sb.Append(@"<script type='text/javascript'>");
sb.Append(" alertify.error('Kayıt silindi!');");
sb.Append(@"</script>");
ScriptManager.RegisterClientScriptBlock(this, this.GetType(), "EditHideModalScript3", sb.ToString(), false);
}
}
}
private void Goster(radiusEntities dc)
{
s += "goster-";
string terim = txtAra.Value;
string antenid = Request.QueryString["antenid"];
MusteriIslemleri m = new MusteriIslemleri(dc);
if (!String.IsNullOrEmpty(antenid))
{
musteri_tel_mail musteri_bilgileri = m.antenMusterileri(Convert.ToInt32(antenid));
GridView1.DataSource = musteri_bilgileri.musteriler;
baslik.InnerHtml = musteri_bilgileri.anten_adi + " Kayıtlı Müşteriler";
hdnTeller.Value = musteri_bilgileri.teller;
}
else if (String.IsNullOrEmpty(terim))
{
musteri_tel_mail musteri_bilgileri = m.musteriListesiR();
GridView1.DataSource = musteri_bilgileri.musteriler;
baslik.InnerHtml = " Kayıtlı Müşteriler";
hdnTeller.Value = musteri_bilgileri.teller;
}
else
{
musteri_tel_mail musteri_bilgileri = m.musteriAraR(terim);
GridView1.DataSource = musteri_bilgileri.musteriler;
baslik.InnerHtml = " Kayıtlı Müşteriler";
hdnTeller.Value = musteri_bilgileri.teller;
}
GridView1.DataBind();
}
private void onaylaTc(string kimlik, string firma)
{
radiusEntities db = MyContext.Context(firma);
Radius.customer cust = (from c in db.customers
where c.TC == kimlik
select c).FirstOrDefault();
if (cust != null)
{
List <servicehesap> kararlar = (from s in db.servicehesaps
where s.MusteriID == cust.CustID && s.iptal == false && (s.onay == null || s.onay == false)
orderby s.TarihZaman descending
select s).ToList();
if (kararlar != null)
{
foreach (servicehesap karar in kararlar)
{
karar.onay = true;
karar.Onay_tarih = DateTime.Now;
karar.Aciklama = "Müşteri Onayı";
}
KaydetmeIslemleri.kaydetR(db);
goster();
System.Text.StringBuilder sb = new System.Text.StringBuilder();
sb.Append(@"<script type='text/javascript'>");
sb.Append(" alertify.success('Kararlar Onaylandı!');");
sb.Append(@"</script>");
ScriptManager.RegisterClientScriptBlock(this, this.GetType(), "EditHideModalScript4", sb.ToString(), false);
}
}
}
protected void Page_Load(object sender, EventArgs e)
{
if (!User.Identity.IsAuthenticated)
{
System.Web.HttpContext.Current.Response.Redirect("/Account/Giris.aspx");
}
using (radiusEntities dc = MyContext.Context(KullaniciIslem.firma()))
{
if (!IsPostBack)
{
AyarCurrent ay = new AyarCurrent(dc);
if (ay.lisansKontrol() == false)
{
Response.Redirect("/LisansError");
}
ServisIslemleri s = new ServisIslemleri(dc);
cihazGoster(s);
drdPaketler.AppendDataBoundItems = true;
drdPaketler.DataSource = s.servis_paketleri();
drdPaketler.DataValueField = "paket_id";
drdPaketler.DataTextField = "paket_adi";
drdPaketler.DataBind();
txtGarantiSuresi.Text = "24";
}
}
}
private void cariAra(int musID, radiusEntities dc)
{
Hareket ser = new Hareket(dc);
TeknikServis.Radius.carihesap hesap = ser.tekCariR(musID);
Session["borc"] = hesap.ToplamBakiye.ToString();
decimal bor = hesap.NetBorc;
decimal al = hesap.ToplamBakiye;
decimal alacak_mahsup = hesap.NetAlacak;
if (al < 0)
{
bor = 0;
//alacağı var ise mahsup miktarı net borcu kadardır
Session["alacak_mahsup"] = hesap.NetBorc.ToString();
al = -al;
txtBakiye.InnerHtml = "Bakiye :" + al.ToString() + "-Alacaklı";
}
else
{
//borcu varsa mahsup miktarı net alacağı kadardır
Session["alacak_mahsup"] = hesap.NetAlacak.ToString();
txtBakiye.InnerHtml = "Bakiye :" + al.ToString() + "-Borçlu";
}
Session["alacak"] = al.ToString();
//txtBorc.InnerHtml = "Net Borç :" + hesap.NetBorc.ToString();
//txtOdenen.InnerHtml = "Net Alacak :" + hesap.NetAlacak.ToString();
}
private void Ara(radiusEntities dc)
{
DateTime baslangic = DateTime.Now.AddMonths(-3);
if (!String.IsNullOrEmpty(datetimepicker6.Value))
{
baslangic = DateTime.Parse(datetimepicker6.Value);
}
DateTime bitis = DateTime.Now;
if (!String.IsNullOrEmpty(datetimepicker7.Value))
{
bitis = DateTime.Parse(datetimepicker7.Value);
}
SatinAlim s = new SatinAlim(dc);
string cust_id = Request.QueryString["custid"];
if (!string.IsNullOrEmpty(cust_id))
{
btnMusteriDetayim.Visible = true;
}
AlimOzet ozet = s.Alimlar(baslangic, bitis, cust_id);
txtAdet.InnerHtml = "İşlem :" + ozet.islem_adet.ToString();
txtKDV.InnerHtml = "KDV :" + ozet.kdv.ToString("C");
txtTutar.InnerHtml = "Tutar :" + ozet.tutar.ToString("C");
txtYekun.InnerHtml = "Yekün :" + ozet.yekun.ToString("C");
grdAlimlar.DataSource = ozet.alimlar;
grdAlimlar.DataBind();
}
protected void grdAlimlar_RowCommand(object sender, GridViewCommandEventArgs e)
{
if (e.CommandName.Equals("del"))
{
string confirmValue = Request.Form["confirm_value"];
List <string> liste = confirmValue.Split(new char[] { ',' }).ToList();
int sayimiz = liste.Count - 1;
string deger = liste[sayimiz];
if (deger == "Yes")
{
string firma = KullaniciIslem.firma();
using (radiusEntities dc = MyContext.Context(firma))
{
int alim_id = Convert.ToInt32(e.CommandArgument);
//alım iptal ediliyor
SatinAlim al = new SatinAlim(dc);
al.AlimIptal(alim_id, User.Identity.Name);
Ara(dc);
System.Text.StringBuilder sb = new System.Text.StringBuilder();
sb.Append(@"<script type='text/javascript'>");
sb.Append(" alertify.error('Kayıt silindi!');");
sb.Append(@"</script>");
ScriptManager.RegisterClientScriptBlock(this, this.GetType(), "EditHideModalScript3", sb.ToString(), false);
}
}
}
}
protected void btnSave_Click(object sender, EventArgs e)
{
int id = Int32.Parse(lblID.Value);
int musID = Int32.Parse(custIDHdn.Value);
string aciklama = txtAciklama_4.Text;
int tip = Int32.Parse(drdTip.SelectedValue);
string konu = txtBaslik_2.Text;
kullanici_repo kul = KullaniciIslem.currentKullanici();
using (radiusEntities dc = MyContext.Context(kul.Firma))
{
ServisIslemleri s = new ServisIslemleri(dc);
s.servisGuncelleR(id, musID, aciklama, tip, konu, User.Identity.Name);
gosterHepsi(kul, dc);
//GridView1.DataBind();
}
System.Text.StringBuilder sb = new System.Text.StringBuilder();
sb.Append(@"<script type='text/javascript'>");
sb.Append(" alertify.success('Servis bilgisi güncellendi!');");
sb.Append("$('#editModal').modal('hide');");
sb.Append(@"</script>");
ScriptManager.RegisterClientScriptBlock(this, this.GetType(), "EditHideModalScript", sb.ToString(), false);
//ScriptManager.RegisterStartupScript(this, GetType(), "myFunction", "myFunction();", true);
}
protected void txtBaslangicChanged(object sender, EventArgs e)
{
using (radiusEntities dc = MyContext.Context(KullaniciIslem.firma()))
{
int tarifeid = Convert.ToInt32(drdTarife.SelectedValue);
MakineIslem m = new MakineIslem(dc);
Tarife t = m.tarife_tek(tarifeid);
if (t.saatlik == true)
{
numara_aralik.Visible = true;
tarih_aralik.Visible = false;
hdnSaatlik.Value = "yes";
hdnTarifeTipi.Value = t.tarife_kodu;
dakika_hesapla();
tutar_hesapla();
}
else
{
numara_aralik.Visible = false;
tarih_aralik.Visible = true;
hdnSaatlik.Value = string.Empty;
hdnTarifeTipi.Value = string.Empty;
sure_hesapla();
}
//fiyatCek(dc);
}
}
protected void btnAra_Click(object sender, EventArgs e)
{
using (radiusEntities dc = MyContext.Context(KullaniciIslem.firma()))
{
goster_kasa(dc);
}
}
protected void Page_Load(object sender, EventArgs e)
{
s += "sayfa load postback-";
string antenid = Request.QueryString["antenid"];
if (!String.IsNullOrEmpty(antenid))
{
btnHepsiniTasi.Visible = true;
}
else
{
btnHepsiniTasi.Visible = false;
}
if (IsPostBack)
{
using (radiusEntities dc = MyContext.Context(KullaniciIslem.firma()))
{
AyarCurrent ay = new AyarCurrent(dc);
if (ay.lisansKontrol() == false)
{
Response.Redirect("/LisansError");
}
Kaydet(dc);
}
}
}
private void CariDetay(int musID, radiusEntities dc)
{
Hareket ser = new Hareket(dc);
GridView2.DataSource = ser.CariDetayRYeni(musID, 5000);
GridView2.DataBind();
}
protected void btnAntenKaydet_Click(object sender, EventArgs e)
{
int? antenid = null;
string eskianten = hdnEskiAnten.Value;
if (!string.IsNullOrEmpty(eskianten))
{
int eskiid = Convert.ToInt32(eskianten);
if (drdAntenler.SelectedValue != "-1")
{
antenid = Convert.ToInt32(drdAntenler.SelectedValue);
}
using (radiusEntities dc = MyContext.Context(KullaniciIslem.firma()))
{
MusteriIslemleri m = new MusteriIslemleri(dc);
m.antenTasi(eskiid, antenid);
Response.Redirect("/TeknikHarita/MusteriAnten?antenid=" + antenid.ToString());
//Goster(dc);
}
}
System.Text.StringBuilder sb = new System.Text.StringBuilder();
sb.Append(@"<script type='text/javascript'>");
sb.Append("$('#onayModal').modal('hide');");
sb.Append(" alertify.success('Taşıma tamamlandı!');");
sb.Append(@"</script>");
ScriptManager.RegisterClientScriptBlock(this, this.GetType(), "OnayShowModalScript", sb.ToString(), false);
}
protected void btnCariKaydet_Click(object sender, EventArgs e)
{
string idd = hdnCariCustID.Value;
string bak = txtCariBakiye.Text;
bool borclu = false;
if (chcBorclu.Checked == true)
{
borclu = true;
}
if (!String.IsNullOrEmpty(idd) && !String.IsNullOrEmpty(bak))
{
int id = Int32.Parse(idd);
decimal bakiyee = Decimal.Parse(bak);
using (radiusEntities dc = MyContext.Context(KullaniciIslem.firma()))
{
Kurulum k = new Kurulum(dc);
k.CariGuncelle(id, bakiyee, borclu, User.Identity.Name);
}
System.Text.StringBuilder sb = new System.Text.StringBuilder();
sb.Append(@"<script type='text/javascript'>");
sb.Append("$('#cariModal').modal('hide');");
sb.Append(@"</script>");
ScriptManager.RegisterClientScriptBlock(this, this.GetType(), "CariModalScript", sb.ToString(), false);
}
}
protected void btnCihazKaydet_Click(object sender, EventArgs e)
{
string ad = cihaz_adi.Text;
string acik = aciklama.Text;
int sure = 12;//Int32.Parse(garanti_suresi.Text);
string firma = KullaniciIslem.firma();
int grupid = Int32.Parse(drdGrup.SelectedValue);
string bar = barcode.Text.Trim();
int birimAlinan = Int32.Parse(drdAlinanBirim.SelectedValue);
int birimSatilan = Int32.Parse(drdSatilanBirim.SelectedValue);
bool sinir = chcSinirsiz.Checked;
using (radiusEntities dc = MyContext.Context(firma))
{
CihazMalzeme m = new CihazMalzeme(dc);
m.Yeni(ad, acik, sure, grupid, bar, birimAlinan, birimSatilan, sinir);
Ara(dc);
}
System.Text.StringBuilder sb = new System.Text.StringBuilder();
sb.Append(@"<script type='text/javascript'>");
sb.Append(" alertify.success('Cihaz tanımlandı!');");
sb.Append("$('#cihazModal').modal('hide');");
sb.Append(@"</script>");
ScriptManager.RegisterClientScriptBlock(this, this.GetType(), "CihazShowModalScript", sb.ToString(), false);
}
protected void GridView1_RowCommand(object sender, GridViewCommandEventArgs e)
{
//int index = Convert.ToInt32(e.CommandArgument);
if (e.CommandName.Equals("detail"))
{
int code = Convert.ToInt32(e.CommandArgument);
// int code = Convert.ToInt32(GridView1.DataKeys[index].Value.ToString());
using (radiusEntities dc = MyContext.Context(KullaniciIslem.firma()))
{
MusteriIslemleri m = new MusteriIslemleri(dc);
DetailsView1.DataSource = m.musteriTekListeR(code);
DetailsView1.DataBind();
}
System.Text.StringBuilder sb = new System.Text.StringBuilder();
sb.Append(@"<script type='text/javascript'>");
sb.Append("$('#detailModal').modal('show');");
sb.Append(@"</script>");
ScriptManager.RegisterClientScriptBlock(this, this.GetType(), "DetailModalScript", sb.ToString(), false);
}
else if (e.CommandName.Equals("cari"))
{
int code = Convert.ToInt32(e.CommandArgument);
hdnCariCustID.Value = code.ToString();
System.Text.StringBuilder sb = new System.Text.StringBuilder();
sb.Append(@"<script type='text/javascript'>");
sb.Append("$('#cariModal').modal('show');");
sb.Append(@"</script>");
ScriptManager.RegisterClientScriptBlock(this, this.GetType(), "CariModalScript", sb.ToString(), false);
}
}
private void goster(radiusEntities dc)
{
int gun = 90;
string gunS = Request.QueryString["gun"];
if (!String.IsNullOrEmpty(gunS))
{
gun = Int32.Parse(gunS);
}
Hareket s = new Hareket(dc);
GenelGorunum gor = s.Gosterge(gun);
txtAlinanCek.InnerHtml = gor.alinan_cek_toplami.ToString("C");
txtBanka.InnerHtml = gor.banka_hesaplar_toplami.ToString("C");
txtExtre.InnerHtml = gor.kart_extre_toplami.ToString("C");
txtKasa.InnerHtml = gor.kasa_bakiye.ToString("C");
txtPos.InnerHtml = gor.poslarda_birikenler.ToString("C");
txtVerilenCek.InnerHtml = gor.verilen_cek_toplami.ToString("C");
GridView1.DataSource = gor.islemler;
GridView1.DataBind();
}
protected void MakineAra(object sender, EventArgs e)
{
using (radiusEntities dc = MyContext.Context(KullaniciIslem.firma()))
{
Ara(dc);
}
}
private void goster(radiusEntities dc)
{
ServisPaketli s = new ServisPaketli(dc);
GridView1.DataSource = s.paketler();
GridView1.DataBind();
}
protected void grdDetay_RowCommand(object sender, GridViewCommandEventArgs e)
{
if (e.CommandName.Equals("del"))
{
string confirmValue = Request.Form["confirm_value"];
List <string> liste = confirmValue.Split(new char[] { ',' }).ToList();
int sayimiz = liste.Count - 1;
string deger = liste[sayimiz];
if (deger == "Yes")
{
if (Session["detay"] != null)
{
List <Detay_Repo> detaylar = (List <Detay_Repo>)Session["detay"];
string id = e.CommandArgument.ToString();
Detay_Repo d = detaylar.FirstOrDefault(x => x.detay_id == id);
detaylar.Remove(d);
Session["detay"] = detaylar;
using (radiusEntities dc = MyContext.Context(KullaniciIslem.firma()))
{
DetayGoster(dc);
}
System.Text.StringBuilder sb = new System.Text.StringBuilder();
sb.Append(@"<script type='text/javascript'>");
sb.Append(" alertify.success('Kayıt silindi!');");
sb.Append(@"</script>");
ScriptManager.RegisterClientScriptBlock(this, this.GetType(), "EditHideModalScript3", sb.ToString(), false);
}
}
}
}
protected void Page_Load(object sender, EventArgs e)
{
if (!User.Identity.IsAuthenticated)
{
System.Web.HttpContext.Current.Response.Redirect("/Account/Giris.aspx");
}
barkod.Focus();
this.Master.servisarama = true;
this.Master.kisiarama = true;
using (radiusEntities dc = MyContext.Context(KullaniciIslem.firma()))
{
if (!IsPostBack)
{
AyarCurrent ay = new AyarCurrent(dc);
if (ay.lisansKontrol() == false)
{
Response.Redirect("/LisansError");
}
MusteriIslemleri m = new MusteriIslemleri(dc);
pos_banka_look pb = m.posbankalar();
drdPos.AppendDataBoundItems = true;
drdPos.DataSource = pb.poslar;
drdPos.DataValueField = "pos_id";
drdPos.DataTextField = "pos_adi";
}
CihazAraa(dc);
// detaylara bakalım
DetayGoster();
}
}
public void MusteriAra(object sender, EventArgs e)
{
using (radiusEntities dc = MyContext.Context(KullaniciIslem.firma()))
{
Goster(dc);
}
}
private void goster(radiusEntities dc)
{
Kart c = new Kart(dc);
string basS = datetimepicker6.Value;
string sonS = datetimepicker7.Value;
var son = DateTime.Now;
var bas = new DateTime(son.Year, son.Month, 1);
if (!String.IsNullOrEmpty(basS))
{
bas = DateTime.Parse(basS);
}
if (!String.IsNullOrEmpty(sonS))
{
son = DateTime.Parse(sonS);
}
string kartS = Request.QueryString["kartid"];
kartozet2 ozet = c.ExtreGorunumu(kartS, bas, son);
baslikkk.InnerHtml = ozet.cari.kart_adi;
spnBakiye.InnerHtml = ozet.cari.bakiye.ToString() + " TL Bakiye";
txtAdet.InnerHtml = ozet.adet.ToString() + "İŞLEM";
txtTutar.InnerHtml = ozet.tutar.ToString("C") + "TUTAR";
//Session["alacak"] = ozet.tutar;
GridView1.DataSource = ozet.hesaplar;
GridView1.DataBind();
}
protected void GridView1_RowDataBound(object sender, GridViewRowEventArgs e)
{
if (e.Row.RowType == DataControlRowType.DataRow)
{
s += "row data bound-";
string antenid = Convert.ToString(DataBinder.Eval(e.Row.DataItem, "antenid"));
using (radiusEntities dc = MyContext.Context(KullaniciIslem.firma()))
{
MusteriIslemleri m = new MusteriIslemleri(dc);
List <anten> antenler = m.antenler();
DropDownList ddlCountries = (e.Row.FindControl("ddlAnten") as DropDownList);
ddlCountries.AppendDataBoundItems = true;
ddlCountries.DataSource = antenler;
ddlCountries.DataTextField = "anten_adi";
ddlCountries.DataValueField = "anten_id";
ddlCountries.DataBind();
//string antenadi = (e.Row.FindControl("lblCountry") as Label).Text;
if (!String.IsNullOrEmpty(antenid))
{
ddlCountries.Items.FindByValue(antenid).Selected = true;
}
}
}
}
public void CihazAra(object sender, EventArgs e)
{
using (radiusEntities dc = MyContext.Context(KullaniciIslem.firma()))
{
CihazAraa(dc);
}
}
protected void btnAtamaKaydet_Click(object sender, EventArgs e)
{
string kullanici = grdOperator.SelectedValue.ToString();
string makineids = Request.QueryString["makineid"];
if (!String.IsNullOrEmpty(kullanici) && !String.IsNullOrEmpty(makineids))
{
using (radiusEntities dc = MyContext.Context(KullaniciIslem.firma()))
{
Operator op = new Operator(dc, kullanici);
if (chcHepsi.Checked == true)
{
op.MakineOperatorKontrollu(Int32.Parse(makineids));
}
else
{
op.MakineOperatorAta(Int32.Parse(makineids));
}
string basS = datetimepicker6.Value;
string sonS = datetimepicker7.Value;
grdOperator.DataSource = KullaniciIslem.FirmaOperatorleri();
grdOperator.DataBind();
ortak(dc, basS, sonS);
System.Text.StringBuilder sb = new System.Text.StringBuilder();
sb.Append(@"<script type='text/javascript'>");
sb.Append("$('#atamaModal').modal('hide');");
sb.Append(" alertify.error('Operatör atandı!');");
sb.Append(@"</script>");
ScriptManager.RegisterClientScriptBlock(this, this.GetType(), "AtaShowModalScript", sb.ToString(), false);
}
}
}
