protected void btnSayacKaydet_Click(object sender, EventArgs e) { if (String.IsNullOrEmpty(hdnSayacID.Value)) { if (grdMasraf.SelectedValue != null) { int makineid = Int32.Parse(Request.QueryString["makineid"]); int id = Convert.ToInt32(grdMasraf.SelectedValue); string birim = grdMasraf.SelectedRow.Cells[4].Text; using (radiusEntities dc = MyContext.Context(KullaniciIslem.firma())) { decimal sayac = Decimal.Parse(txtSayac.Text); decimal sayac_alarm = Decimal.Parse(txtSayacAlarm.Text); MakineIslem m = new MakineIslem(dc); bool tamam = m.sayacekle(makineid, id, sayac, birim, sayac_alarm); if (tamam == true) { m.sayacdelete(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.success('Sayaç kaydedildi');"); sb.Append("$('#yeniSayacModal').modal('hide');"); sb.Append(@"</script>"); ScriptManager.RegisterClientScriptBlock(this, this.GetType(), "yeniSayaceModalScript", sb.ToString(), false); } else { System.Text.StringBuilder sb = new System.Text.StringBuilder(); sb.Append(@"<script type='text/javascript'>"); sb.Append(" alertify.error('Bu sayaç tanımı zaten yapılmış');"); sb.Append("$('#yeniSayacModal').modal('hide');"); sb.Append(@"</script>"); ScriptManager.RegisterClientScriptBlock(this, this.GetType(), "yeniSayaceModalScript", sb.ToString(), false); } } } } else { int id = Int32.Parse(hdnSayacID.Value); using (radiusEntities dc = MyContext.Context(KullaniciIslem.firma())) { MakineIslem m = new MakineIslem(dc); m.sayacupdate(id, Int32.Parse(txtSayac.Text)); System.Text.StringBuilder sb = new System.Text.StringBuilder(); sb.Append(@"<script type='text/javascript'>"); sb.Append(" alertify.success('Sayaç kaydedildi');"); sb.Append("$('#yeniSayacModal').modal('hide');"); sb.Append(@"</script>"); ScriptManager.RegisterClientScriptBlock(this, this.GetType(), "yeniSayaceModalScript", sb.ToString(), false); } } }
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); } MakineIslem s = new MakineIslem(dc); string makine_id = Request.QueryString["makineid"]; string masraf_id = Request.QueryString["masrafid"]; GirisOzet ozet = s.Girisler(baslangic, bitis, makine_id, masraf_id); txtAdet.InnerHtml = "İşlem :" + ozet.adet.ToString(); txtMiktar.InnerHtml = "Miktar :" + ozet.miktar.ToString(); txtTutar.InnerHtml = "Tutar :" + ozet.tutar.ToString("C"); grdAlimlar.DataSource = ozet.liste; grdAlimlar.DataBind(); }
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 grdAlimlarGirisler_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.GirisIptal(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); } } } }
protected void Page_Load(object sender, EventArgs e) { if (!User.Identity.IsAuthenticated || (!User.IsInRole("Admin") && !User.IsInRole("mudur"))) { System.Web.HttpContext.Current.Response.Redirect("/Account/Giris"); } string firma = KullaniciIslem.firma(); using (radiusEntities dc = MyContext.Context(firma)) { if (!IsPostBack) { AyarCurrent ay = new AyarCurrent(dc); if (ay.lisansKontrol() == false) { Response.Redirect("/LisansError"); } MasrafAraa(dc); MakineIslem m = new MakineIslem(dc); string makine_id = Request.QueryString["makineid"]; if (!String.IsNullOrEmpty(makine_id)) { int makineid = Int32.Parse(makine_id); var mak = m.tekmakine(makineid); baslik.InnerHtml = mak.adi + "-" + mak.plaka; } } // detaylara bakalım DetayGoster(); } }
private void Ara(radiusEntities dc) { MakineIslem s = new MakineIslem(dc); string terim = txtAra.Value; grdAlimlar.DataSource = s.makineler(terim); grdAlimlar.DataBind(); }
private void Ara(radiusEntities dc) { MakineIslem s = new MakineIslem(dc); string terim = txtAra.Value; grdAlimlar.DataSource = s.makinelerOperator(terim, User.Identity.Name); grdAlimlar.DataBind(); }
public void goster(radiusEntities dc) { MakineIslem al = new MakineIslem(dc); string id = Request.QueryString["makineid"]; grdAlimlarGirisler.DataSource = al.OperatorGirisleri(id, User.Identity.Name); grdAlimlarGirisler.DataBind(); }
private void makineGoster(radiusEntities dc) { MakineIslem c = new MakineIslem(dc); string arama_terimi = txtMakineAra.Value; grdMakine.DataSource = c.makinelerOperator(arama_terimi, User.Identity.Name); grdMakine.DataBind(); }
protected void btnAlimKaydet_Click(object sender, EventArgs e) { string makineids = Request["makineid"]; if (!String.IsNullOrEmpty(makineids)) { int makineid = Int32.Parse(makineids); DateTime islem_tarih = DateTime.Now; //string tars = tarih2.Value; //if (!String.IsNullOrEmpty(tars)) //{ // islem_tarih = DateTime.Parse(tars); //} string firma = KullaniciIslem.firma(); using (radiusEntities dc = MyContext.Context(firma)) { MakineIslem a = new MakineIslem(dc); if (Session["alimdetay"] != null) { List <MakineGiris> detaylar = (List <MakineGiris>)Session["alimdetay"]; a.masraf_girisi(detaylar); string back = Request.QueryString["back"]; if (back.Equals("servis")) { string kimlik = Request.QueryString["kimlik"]; string servisid = Request.QueryString["servisid"]; string custid = Request.QueryString["custid"]; Response.Redirect("/TeknikTeknik/Servis?servisid=" + servisid + "&kimlik=" + kimlik + "&custid=" + custid); } else if (back.Equals("makine")) { Response.Redirect("/TeknikMakine/MakineTek?makineid=" + makineid); } else { Response.Redirect("/TeknikMakine/Makineler"); } } } Session["alimdetay"] = null; } }
private void tarife_listesi(radiusEntities dc) { string makine_id = Request.QueryString["makineid"]; if (!String.IsNullOrEmpty(makine_id)) { int makineid = Int32.Parse(makine_id); MakineIslem m = new MakineIslem(dc); //drdTarifeTanim.AppendDataBoundItems = true; drdTarifeTanim.DataSource = m.tarifeler_saatlik(makineid); drdTarifeTanim.DataValueField = "id"; drdTarifeTanim.DataTextField = "ad"; drdTarifeTanim.DataBind(); } }
private void fiyatCek(radiusEntities dc) { if (grdMakine.SelectedValue != null && drdTarife.SelectedValue != null) { int id = Convert.ToInt32(grdMakine.SelectedValue); int tarifeid = Convert.ToInt32(drdTarife.SelectedValue); MakineIslem m = new MakineIslem(dc); Makine mak = m.tekmakine(id); Tarife t = m.tarife_tek(tarifeid); txtFiyat.Text = t.tutar.ToString(); txtSonNumara.Text = mak.son_sayac.ToString(); txtMakineAdiGoster.Value = mak.adi; } }
private void tarifeCek(radiusEntities dc) { if (grdMakine.SelectedValue != null) { int id = Convert.ToInt32(grdMakine.SelectedValue); MakineIslem m = new MakineIslem(dc); var tarifeler = m.tarifeler(id); //if (tarifeler.Count > 0) //{ drdTarife.DataSource = tarifeler; drdTarife.DataValueField = "id"; drdTarife.DataTextField = "ad"; drdTarife.DataBind(); //} Makine mak = m.tekmakine(id); txtSonNumara.Text = mak.son_sayac.ToString(); txtMakineAdiGoster.Value = mak.adi; if (tarifeler.Count > 0) { int tarifeid = Convert.ToInt32(drdTarife.SelectedValue); Tarife t = m.tarife_tek(tarifeid); txtFiyat.Text = t.tutar.ToString(); if (t.saatlik == true) { numara_aralik.Visible = true; hdnSaatlik.Value = "yes"; tarih_aralik.Visible = false; } else { numara_aralik.Visible = false; hdnSaatlik.Value = string.Empty; tarih_aralik.Visible = true; } } else { txtFiyat.Text = String.Empty; hdnSaatlik.Value = string.Empty; } } }
protected void btnAddRecordTarife_Click(object sender, EventArgs e) { string tarife_tipi = drdTarifeTipi.SelectedValue; string makineids = Request.QueryString["makineid"]; string calismatipi = txtCalismaTipi.Text.Trim().ToLower(); string fiyats = txtTarifeFiyat.Text; if (!String.IsNullOrEmpty(makineids) && !String.IsNullOrEmpty(tarife_tipi)) { using (radiusEntities dc = MyContext.Context(KullaniciIslem.firma())) { MakineIslem m = new MakineIslem(dc); int i = m.tarife_ekle(Int32.Parse(makineids), tarife_tipi, calismatipi, Decimal.Parse(fiyats)); if (i == 1) { 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("$('#addTarifeModal').modal('hide');"); sb.Append(" alertify.error('Tarife tanımlandı!');"); sb.Append(@"</script>"); ScriptManager.RegisterClientScriptBlock(this, this.GetType(), "AtaShowModalScript", sb.ToString(), false); } else if (i == -1) { //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("$('#addTarifeModal').modal('hide');"); sb.Append(" alertify.error('Bu tarife tipi ve çalışma tipi için tarife tanımı mevcut!');"); sb.Append(@"</script>"); ScriptManager.RegisterClientScriptBlock(this, this.GetType(), "AtaShowModalScript", sb.ToString(), false); } } } }
protected void btnDetayKaydetMasraf_Click(object sender, EventArgs e) { string makineids = Request["makineid"]; if (!String.IsNullOrEmpty(makineids)) { int makineid = Int32.Parse(makineids); int adet = Int32.Parse(txtAdetMasraf.Text); string ad = ""; int masraf_id = -1; List <MakineGiris> detaylar = new List <MakineGiris>(); if (grdMasraf.SelectedValue != null) { masraf_id = Convert.ToInt32(grdMasraf.SelectedValue); ad = grdMasraf.SelectedRow.Cells[2].Text; } decimal birim_maliyet = Decimal.Parse(grdMasraf.SelectedRow.Cells[7].Text); bool sifirla = false; MakineGiris detay = new MakineGiris(); detay.aciklama = txtDetayAciklamaMasraf.Text; detay.belge_no = "bakarız"; detay.makine_adi = "önemsiz"; detay.makine_id = makineid; detay.makine_plaka = "ödemsiz"; detay.masraf_adi = ad; detay.masraf_id = masraf_id; detay.miktar = adet; detay.tarih = DateTime.Now; detay.tutar = adet * birim_maliyet; detay.id = 0; detay.kullanici = User.Identity.Name; detay.sifirla = sifirla; detaylar.Add(detay); DateTime islem_tarih = DateTime.Now; using (radiusEntities dc = MyContext.Context(KullaniciIslem.firma())) { MakineIslem a = new MakineIslem(dc); if (detaylar.Count > 0) { a.masraf_girisi(detaylar); goster(dc); System.Text.StringBuilder sb = new System.Text.StringBuilder(); sb.Append(@"<script type='text/javascript'>"); sb.Append(" alertify.success('Sarf Kaydı Eklendi!');"); sb.Append("$('#detayModalMasraf').modal('hide');"); sb.Append(@"</script>"); ScriptManager.RegisterClientScriptBlock(this, this.GetType(), "DetayShowModalMasrafScript", sb.ToString(), false); } } } else { System.Text.StringBuilder sb = new System.Text.StringBuilder(); sb.Append(@"<script type='text/javascript'>"); sb.Append(" alertify.error('Lütfen önce makine seçiniz!');"); sb.Append(@"</script>"); ScriptManager.RegisterClientScriptBlock(this, this.GetType(), "DetayShowModalMasrafScript", sb.ToString(), false); } }
protected void btnTanimKaydet_Click(object sender, EventArgs e) { if (String.IsNullOrEmpty(hdnTanimID.Value)) { if (grdMasraf2.SelectedValue != null) { int makineid = Int32.Parse(Request.QueryString["makineid"]); int id = Convert.ToInt32(grdMasraf2.SelectedValue); string birim = grdMasraf2.SelectedRow.Cells[4].Text; using (radiusEntities dc = MyContext.Context(KullaniciIslem.firma())) { int sayac = Int32.Parse(txtSayac2.Text); decimal miktar = Decimal.Parse(txtMiktar2.Text); decimal masraf_saat = (decimal)(miktar / sayac); MakineIslem m = new MakineIslem(dc); bool tamam = false; AyarCurrent ay = new AyarCurrent(dc); int tarifeid = Convert.ToInt32(drdTarifeTanim.SelectedValue); tamam = m.tanimekle_tipli(makineid, id, tarifeid, masraf_saat, txtAciklama.Text, birim); if (tamam == true) { //m.sayacdelete(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.success('Tanım kaydedildi');"); sb.Append("$('#yeniTanimModal').modal('hide');"); sb.Append(@"</script>"); ScriptManager.RegisterClientScriptBlock(this, this.GetType(), "yeniSayactModalScript", sb.ToString(), false); } else { System.Text.StringBuilder sb = new System.Text.StringBuilder(); sb.Append(@"<script type='text/javascript'>"); sb.Append(" alertify.error('Bu tanım zaten yapılmış');"); sb.Append("$('#yeniTanimModal').modal('hide');"); sb.Append(@"</script>"); ScriptManager.RegisterClientScriptBlock(this, this.GetType(), "yeniSayacetModalScript", sb.ToString(), false); } } } } else { int id = Int32.Parse(hdnTanimID.Value); using (radiusEntities dc = MyContext.Context(KullaniciIslem.firma())) { MakineIslem m = new MakineIslem(dc); int sayac = Int32.Parse(txtSayac2.Text); decimal miktar = Decimal.Parse(txtMiktar2.Text); decimal masraf_saat = (decimal)(miktar / sayac); m.tanimupdate(id, masraf_saat, txtAciklama.Text); System.Text.StringBuilder sb = new System.Text.StringBuilder(); sb.Append(@"<script type='text/javascript'>"); sb.Append(" alertify.success('Tanım kaydedildi');"); sb.Append("$('#yeniTanimModal').modal('hide');"); sb.Append(@"</script>"); ScriptManager.RegisterClientScriptBlock(this, this.GetType(), "yeniSayacetModalScript", sb.ToString(), false); } } }
protected void grdTanim_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[] arg = new string[2]; arg = e.CommandArgument.ToString().Split(';'); int id = Convert.ToInt32(arg[0]); using (radiusEntities dc = MyContext.Context(KullaniciIslem.firma())) { MakineIslem s = new MakineIslem(dc); s.tanimdelete_tipli(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); } else { System.Text.StringBuilder sb = new System.Text.StringBuilder(); sb.Append(@"<script type='text/javascript'>"); sb.Append(" alertify.error('" + deger + "');"); sb.Append(@"</script>"); ScriptManager.RegisterClientScriptBlock(this, this.GetType(), "EditHideModalScript3", sb.ToString(), false); } } else if (e.CommandName.Equals("duzenle")) { string[] arg = new string[2]; arg = e.CommandArgument.ToString().Split(';'); int index = Convert.ToInt32(arg[1]); GridViewRow row = grdTanim.Rows[index]; string sayac = row.Cells[2].Text; hdnTanimID.Value = Convert.ToString(arg[0]); grdMasraf.SelectedIndex = -1; System.Text.StringBuilder sb = new System.Text.StringBuilder(); sb.Append(@"<script type='text/javascript'>"); sb.Append("$('#yeniTanimModal').modal('show');"); sb.Append(@"</script>"); ScriptManager.RegisterClientScriptBlock(this, this.GetType(), "yeniSayacetModalScript", sb.ToString(), false); } }