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