public ActionResult FormEdit(int id, string formtype, FORMLines FormLines) { LoginCheck(); using (IDbConnection db = new SqlConnection(ConfigurationManager.ConnectionStrings["PTEKNIKMSSQL"].ConnectionString)) { string MontajDate = Convert.ToDateTime(((FormLines.MONTAJDATE == null) ? DateTime.Parse("1900-01-01") : FormLines.MONTAJDATE)).ToString("MM/dd/yyyy"); string ARIZADATE = Convert.ToDateTime(((FormLines.ARIZADATE == null) ? DateTime.Parse("1900-01-01") : FormLines.ARIZADATE)).ToString("MM/dd/yyyy"); string FatDate = Convert.ToDateTime(((FormLines.FATURADATE == null) ? DateTime.Parse("1900-01-01") : FormLines.FATURADATE)).ToString("MM/dd/yyyy"); string sqlQuery = "update [dbo].[FORMLINE] set " + "BELGENO=" + FormLines.BELGENO + "" + ",BELGESTR='" + FormLines.BELGESTR + "'" + ",ADSOYAD='" + FormLines.ADSOYAD + "'" + ",ADRES='" + FormLines.ADRES + "'" + ",TEL='" + FormLines.TEL + "'" + ",TEL2='" + FormLines.TEL2 + "'" + ",EMAIL='" + FormLines.EMAIL + "'" + ",MONTAJDATE='" + MontajDate + "'" + ",ARIZADATE='" + ARIZADATE + "'" + ",FIRMA='" + FormLines.FIRMA + "'" + ",SATICIFIRMA='" + FormLines.SATICIFIRMA + "'" + ",FATURADATE='" + Convert.ToDateTime(FatDate).ToString("MM/dd/yyyy") + "'" + ",FATURANO='" + FormLines.FATURANO + "'" + ",GARANTINO='" + FormLines.GARANTINO + "'" + ",CIHAZ='" + FormLines.CIHAZ + "'" + ",CIHAZSERINO='" + FormLines.CIHAZSERINO + "',DURUM=1" + ",CACIKLAMA='" + FormLines.CACIKLAMA + "'" + " WHERE LOGICALREF=" + id; int rowsAffected = db.Execute(sqlQuery); } return(RedirectToAction("Index")); }
public ActionResult FormAdd(FORMLines FormLines) { LoginCheck(); //zorunlu alan kontrolü if (FormLines.TEL == "" && FormLines.TEL2 == "") { return(View()); } using (IDbConnection db = new SqlConnection(ConfigurationManager.ConnectionStrings["PTEKNIKMSSQL"].ConnectionString)) { string sqlQuery = "INSERT INTO [dbo].[FORMLINE]([BELGENO],[BELGESTR],[ADSOYAD],[ADRES],[TEL],[TEL2],[EMAIL],[MONTAJDATE],[ARIZADATE],[FIRMA],[SATICIFIRMA],[FATURADATE],[FATURANO],[GARANTINO],[CIHAZ],[CIHAZSERINO])VALUES" + "(" + FormLines.BELGENO + "" + ",'" + FormLines.BELGESTR + "'" + ",'" + FormLines.ADSOYAD + "'" + ",'" + FormLines.ADRES + "'" + ",'" + FormLines.TEL + "'" + ",'" + FormLines.TEL2 + "'" + ",'" + FormLines.EMAIL + "'" + ",cast('" + Convert.ToDateTime(FormLines.MONTAJDATE).ToString("MM/dd/yyyy") + "' as datetime)" + ",cast('" + Convert.ToDateTime(FormLines.ARIZADATE).ToString("MM/dd/yyyy") + "' as datetime)" + ",'" + FormLines.FIRMA + "'" + ",'" + FormLines.SATICIFIRMA + "'" + ",cast('" + Convert.ToDateTime(FormLines.FATURADATE).ToString("MM/dd/yyyy") + "' as datetime)" + ",'" + FormLines.FATURANO + "'" + ",'" + FormLines.GARANTINO + "'" + ",'" + FormLines.CIHAZ + "'" + ",'" + FormLines.CIHAZSERINO + "')"; int rowsAffected = db.Execute(sqlQuery); } return(RedirectToAction("FormList", "Forms", new { @formtype = FormLines.FORMTYPE })); }
// GET: Forms/Create public ActionResult FormAdd(string formtype) { LoginCheck(); if (formtype == "Arıza") { ViewData["FormAddTitle"] = "Arıza Formu Ekranı"; ViewData["montajdateStyle"] = "display:none"; } else if (formtype == "montaj") { ViewData["FormAddTitle"] = "Montaj Formu Ekranı"; ViewData["arizadateStyle"] = "display:none"; } else { return(Redirect("Index")); } FORMLines _DefaultModel = new FORMLines(); _DefaultModel.BELGENO = Convert.ToInt32(GLOBALS.GetCookie("giris")["BELGEID"]); _DefaultModel.BELGESTR = GLOBALS.GetCookie("giris")["CLIENTREF"]; _DefaultModel.FORMTYPE = formtype; _DefaultModel.MONTAJDATE = DateTime.Now; _DefaultModel.ARIZADATE = DateTime.Now; _DefaultModel.FATURADATE = DateTime.Now; return(View(_DefaultModel)); }
public ActionResult FormOnizle(string ficheno) { FORMLines _formLines = new FORMLines(); using (db) { _formLines = db.Query <FORMLines>("select * from FORMLINE where FICHENO='" + ficheno + "'").SingleOrDefault(); } return(View(_formLines)); }
public ActionResult FormKaydetJQ(FORMLines FormLines) { //zorunlu alan kontrolü if (FormLines.TEL == "" && FormLines.TEL2 == "") { return(View()); } string MontajDate = Convert.ToDateTime(((FormLines.MONTAJDATE == null) ? DateTime.Parse("1900-01-01") : FormLines.MONTAJDATE)).ToString("MM/dd/yyyy"); string ARIZADATE = Convert.ToDateTime(((FormLines.ARIZADATE == null) ? DateTime.Parse("1900-01-01") : FormLines.ARIZADATE)).ToString("MM/dd/yyyy"); string FatDate = Convert.ToDateTime(((FormLines.FATURADATE == null) ? DateTime.Parse("1900-01-01") : FormLines.FATURADATE)).ToString("MM/dd/yyyy"); bool durum = true; if ((FormLines.FORMTYPE == "montaj" && FormLines.MONTAJDATE > DateTime.Now) || (FormLines.FORMTYPE == "Arıza" && FormLines.ARIZADATE > DateTime.Now)) { durum = false; } using (IDbConnection db = new SqlConnection(ConfigurationManager.ConnectionStrings["PTEKNIKMSSQL"].ConnectionString)) { string sqlQuery = "INSERT INTO [dbo].[FORMLINE](FORMTYPE,FICHENO,[BELGENO],[BELGESTR],[ADSOYAD],[ADRES],[TEL],[TEL2],[EMAIL],[MONTAJDATE],[ARIZADATE],[FIRMA],[SATICIFIRMA],[FATURADATE],[FATURANO],[GARANTINO],[CIHAZ],[CIHAZSERINO],CLIENTREF)VALUES" + "('" + FormLines.FORMTYPE + "','" + FormLines.BELGESTR + "-" + FormLines.BELGENO + "'," + FormLines.BELGENO + "" + ",'" + FormLines.BELGESTR + "'" + ",'" + FormLines.ADSOYAD + "'" + ",'" + FormLines.ADRES + "'" + ",'" + FormLines.TEL + "'" + ",'" + FormLines.TEL2 + "'" + ",'" + FormLines.EMAIL + "'" + ",cast('" + MontajDate + "' as datetime)" + ",cast('" + ARIZADATE + "' as datetime)" + ",'" + FormLines.FIRMA + "'" + ",'" + FormLines.SATICIFIRMA + "'" + ",cast('" + FatDate + "' as datetime)" + ",'" + FormLines.FATURANO + "'" + ",'" + FormLines.GARANTINO + "'" + ",'" + FormLines.CIHAZ + "'" + ",'" + FormLines.CIHAZSERINO + "'" + ",'" + GLOBALS.GetCookie("giris")["CLIENTREF"] + "'" + ")"; if (durum == true) { int rowsAffected = db.Execute(sqlQuery); int rowsUpdated = db.Execute("update USERS set BELGEID=BELGEID+1 where LOGICALREF=" + GLOBALS.GetCookie("giris")["USERID"] + ""); int belgeid = Convert.ToInt32(giris["BELGEID"]); belgeid++; giris["BELGEID"] = belgeid.ToString(); Response.Cookies.Add(giris); } } // Response.Redirect("FormEdit?ficheno="+ FormLines.BELGESTR + "-" + FormLines.BELGENO+ "&formtype="+Request.QueryString["formtype"]+""); return(Json(new { success = durum }, JsonRequestBehavior.AllowGet)); // return RedirectToAction("FormEdit",new {ficheno=FormLines.BELGESTR+"-"+FormLines.BELGENO,formtype=Request.QueryString["formtype"] }); }
// GET: Forms/Details/5 public ActionResult Details(int id) { LoginCheck(); FORMLines FormDetail = new FORMLines(); using (IDbConnection db = new SqlConnection(ConfigurationManager.ConnectionStrings["PTEKNIKMSSQL"].ConnectionString)) { FormDetail = db.Query <FORMLines>("Select * From FORMLINE where LOGICALREF=" + id, new { id }).SingleOrDefault(); } return(View(FormDetail)); }
// GET: Forms/Edit/5 public ActionResult FormEdit(string ficheno, string formtype) { LoginCheck(); FORMTYPECheck(formtype); FORMLines FormDetail = new FORMLines(); using (IDbConnection db = new SqlConnection(ConfigurationManager.ConnectionStrings["PTEKNIKMSSQL"].ConnectionString)) { FormDetail = db.Query <FORMLines>("Select * From FORMLINE where FICHENO='" + ficheno + "'").SingleOrDefault(); } return(View(FormDetail)); }
public ActionResult FormBas(string ficheno, string formtype) { FORMLines _DefaultModel = new FORMLines(); using (db) { _DefaultModel = db.Query <FORMLines>("select * from FORMLINE where FICHENO='" + ficheno + "'").SingleOrDefault(); } ViewData["MONTAJDATE"] = (formtype != "MONTAJ") ? "display:none;" : ""; ViewData["ARIZADATE"] = (formtype != "ARIZA") ? "display:none;" : ""; return(View(_DefaultModel)); }
// GET: Forms/Edit/5 public ActionResult TeknikTalepEdit(int id, string formtype) { if (!GLOBALS.CookieAuth()) { return(RedirectToAction("Index", "Home")); } FORMTYPECheck(formtype); FORMLines FormDetail = new FORMLines(); using (db) { FormDetail = db.Query <FORMLines>("Select * From FORMLINE where LOGICALREF=" + id, new { id }).SingleOrDefault(); } return(View(FormDetail)); }
public ActionResult TeknikTalep(string clientid, string caridef, string carikod) { if (!GLOBALS.CookieAuth()) { return(RedirectToAction("Index", "Home")); } FORMLines _fORMLines = new FORMLines(); _fORMLines.BELGENO = Convert.ToInt32(cookie["BELGEID"]); _fORMLines.BELGESTR = cookie["USERID"]; _fORMLines.CLIENTREF = Convert.ToInt32((clientid == null)?"0":clientid); _fORMLines.NAME = caridef; _fORMLines.CODE = carikod; return(View(_fORMLines)); }
public ActionResult TeknikTalepEdit(int id, FORMLines FormLines) { if (!GLOBALS.CookieAuth()) { return(RedirectToAction("Index", "Home")); } using (db) { string sqlQuery = "update [dbo].[FORMLINE] set " + "BELGENO=" + FormLines.BELGENO + "" + ",BELGESTR='" + FormLines.BELGESTR + "'" + ",ADSOYAD='" + FormLines.ADSOYAD + "'" + ",ADRES='" + FormLines.ADRES + "'" + ",TEL='" + FormLines.TEL + "'" + " WHERE LOGICALREF=" + id; int rowsAffected = db.Execute(sqlQuery); } return(RedirectToAction("TeknikTalepler")); }
public ActionResult FormBas(string ficheno) { FORMLines _DefaultModel = new FORMLines(); if (ficheno != "0") { using (db) { _DefaultModel = db.Query <FORMLines>("select * from FORMLINE where FICHENO='" + ficheno + "'").SingleOrDefault(); } } else { _DefaultModel.BELGENO = Convert.ToInt32(GLOBALS.GetCookie("fichenos")["BELGEID"]); _DefaultModel.BELGESTR = GLOBALS.GetCookie("fichenos")["CLIENTREF"]; _DefaultModel.FORMTYPE = "MONTAJ"; _DefaultModel.MONTAJDATE = DateTime.Now; } return(View(_DefaultModel)); }
public ActionResult TeknikTalep(FORMLines _talep) { if (!GLOBALS.CookieAuth()) { return(RedirectToAction("Index", "Home")); } using (db) { string sqlQuery = "INSERT INTO [dbo].[FORMLINE](ISTALEP,FICHENO,ACIKLAMA,CLIENTREF,NAME,CODE,FORMTYPE,ADMIN,DURUM,BELGESTR,BELGENO,ADSOYAD,FIRMA,ADRES,TEL,ADDDATE) VALUES" + "(1,'" + _talep.BELGESTR + "-" + _talep.BELGENO + "','" + _talep.ACIKLAMA + "'," + _talep.CLIENTREF + ",'" + _talep.NAME + "','" + _talep.CODE + "','" + _talep.FORMTYPE + "'," + giris["USERID"] + ",0,'" + _talep.BELGESTR + "'," + _talep.BELGENO + ",'" + _talep.ADSOYAD + "','" + _talep.FIRMA + "','" + _talep.ADRES + "','" + _talep.TEL + "','" + DateTime.Now.ToString("MM/dd/yyyy HH:mm:ss") + "') "; int rowsAffected = GLOBALS.db.Execute(sqlQuery); GLOBALS.db.Execute("update USERS set BELGEID=BELGEID+1 where LOGICALREF=" + giris["USERID"] + ""); int belgeid = Convert.ToInt32(cookie["BELGEID"]); belgeid++; cookie["BELGEID"] = belgeid.ToString(); Response.Cookies.Add(cookie); //mail at } return(RedirectToAction("TeknikTalepler", "Admin")); }
public ActionResult FormBas(string ficheno, FORMLines FormLines) { bool durum = false; LoginCheck(); //zorunlu alan kontrolü if (String.IsNullOrEmpty(FormLines.TEL) && String.IsNullOrEmpty(FormLines.TEL2)) { TempData["msg"] = "<script>alert('En Az Bir Telefon Numarası Girmelisiniz!!!');</script>"; return(View()); } if (String.IsNullOrEmpty(FormLines.ADRES) && String.IsNullOrEmpty(FormLines.ADSOYAD)) { TempData["msg"] = "<script>alert('Müşteri Adı Ve Adres Girmeden İlerleyemezsiniz!!!');</script>"; return(View()); } if ((FormLines.FORMTYPE == "MONTAJ" && FormLines.MONTAJDATE > DateTime.Now)) { durum = false; TempData["msg"] = "<script>alert('İleri Bir Tarih Seçimi Yapamazsınız!!!');</script>"; return(View()); } string MontajDate = Convert.ToDateTime(((FormLines.MONTAJDATE == null) ? DateTime.Parse("1900-01-01") : FormLines.MONTAJDATE)).ToString("MM/dd/yyyy"); if (ficheno != "0") { string sqlQuery = "update [dbo].[FORMLINE] set " + "ADSOYAD='" + FormLines.ADSOYAD + "'" + ",ADRES='" + FormLines.ADRES + "'" + ",TEL='" + FormLines.TEL + "'" + ",TEL2='" + FormLines.TEL2 + "'" + ",EMAIL='" + FormLines.EMAIL + "'" + ",MONTAJDATE='" + MontajDate + "'" + ",FIRMA='" + FormLines.FIRMA + "'" + ",SATICIFIRMA='" + FormLines.SATICIFIRMA + "'" + ",FATURANO='" + FormLines.FATURANO + "'" + ",GARANTINO='" + FormLines.GARANTINO + "'" + ",CIHAZ='" + FormLines.CIHAZ + "'" + ",CIHAZSERINO='" + FormLines.CIHAZSERINO + "'" + ",CACIKLAMA='" + FormLines.CACIKLAMA + "'" + " WHERE FICHENO='" + ficheno + "'"; int rowsAffected = db.Execute(sqlQuery); return(RedirectToAction("FormLine", new { ficheno = ficheno, adsoyad = FormLines.ADSOYAD })); } FormLines.BELGENO = Convert.ToInt32(GLOBALS.GetCookie("fichenos")["BELGEID"]); FormLines.BELGESTR = GLOBALS.GetCookie("fichenos")["CLIENTREF"]; using (db) { string sqlQuery = "INSERT INTO [dbo].[FORMLINE](ADDDATE,NAME,FORMTYPE,FICHENO,[BELGENO],[BELGESTR],[ADSOYAD],[ADRES],[TEL],[TEL2],[EMAIL],[MONTAJDATE],[FIRMA],[SATICIFIRMA],ACIKLAMA,CLIENTREF)VALUES" + "(GETDATE(),(select DEFINITION_ FROM LKSDB..LG_" + GLOBALS.GFirma + "_CLCARD WHERE LOGICALREF=" + GLOBALS.GetCookie("giris")["CLIENTREF"] + ")," + "'" + FormLines.FORMTYPE + "','" + FormLines.BELGESTR + "-" + FormLines.BELGENO + "'," + FormLines.BELGENO + "" + ",'" + FormLines.BELGESTR + "'" + ",'" + FormLines.ADSOYAD + "'" + ",'" + FormLines.ADRES + "'" + ",'" + FormLines.TEL + "'" + ",'" + FormLines.TEL2 + "'" + ",'" + FormLines.EMAIL + "'" + ",cast('" + MontajDate + "' as datetime)" + ",'" + FormLines.FIRMA + "'" + ",'" + FormLines.SATICIFIRMA + "'" + ",'" + FormLines.ACIKLAMA + "'" + ",'" + GLOBALS.GetCookie("giris")["CLIENTREF"] + "'" + ")"; int rowsAffected = db.Execute(sqlQuery); int rowsUpdated = db.Execute("update USERS set BELGEID=BELGEID+1 where LOGICALREF=" + GLOBALS.GetCookie("giris")["USERID"] + ""); int belgeid = Convert.ToInt32(cookie["BELGEID"]); belgeid++; cookie["BELGEID"] = belgeid.ToString(); cookie.Expires = DateTime.Now.AddDays(1); Response.Cookies.Add(cookie); } return(RedirectToAction("FormLine", new { ficheno = FormLines.BELGESTR + "-" + FormLines.BELGENO, adsoyad = FormLines.ADSOYAD })); }