private void LoginCheck() { if (!GLOBALS.CookieAuthClients()) { RedirectToAction("Index", "Home"); } }
// 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 Index() { if (!GLOBALS.CookieAuth()) { return(RedirectToAction("Index", "Home")); } return(View()); }
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"] }); }
public ActionResult HakedisList() { List <FORMLines> _list = new List <FORMLines>(); using (IDbConnection db = new SqlConnection(ConfigurationManager.ConnectionStrings["PTEKNIKMSSQL"].ConnectionString)) { _list = db.Query <FORMLines>("select case when durum=2 then 'Ödendi' end as ONAYDURUM," + "* from FORMLINE WHERE CLIENTREF=" + GLOBALS.GetCookie("giris")["CLIENTREF"] + " and DURUM=2").ToList(); } return(View(_list)); }
void Start() { playerT = GameObject.FindGameObjectWithTag("Player").transform; player = GameObject.FindGameObjectWithTag("Player"); glob = player.gameObject.GetComponent <GLOBALS> (); navA = GetComponent <NavMeshAgent> (); navA.autoBraking = false; glob.Espeed = 1.5f; }
public ActionResult UserDelete(string id, FormCollection collection) { if (!GLOBALS.CookieAuth()) { return(RedirectToAction("Index", "Home")); } using (db) { db.Execute("delete from USERS where LOGICALREF=" + id); } return(RedirectToAction("UserList")); }
public ActionResult TeknikTalepDelete(int id, FormCollection collection) { if (!GLOBALS.CookieAuth()) { return(RedirectToAction("Index", "Home")); } using (db) { int rowsAffected = db.Execute("delete from FORMLINE where LOGICALREF=" + id); } return(RedirectToAction("TeknikTalepler")); }
public ActionResult GetClients(string searchSTR) { if (!GLOBALS.CookieAuth()) { return(RedirectToAction("Index", "Home")); } List <CLIENTS> USERLists = new List <CLIENTS>(); using (db) { USERLists = db.Query <CLIENTS>("Select DEFINITION_,CODE,SPECODE,LOGICALREF,TELNRS1 From LKSDB..LG_" + GLOBALS.GFirma + "_CLCARD where 1=1 and CODE like '120%' and replace(DEFINITION_+CODE,' ','') like '%" + searchSTR.Replace(" ", "") + "%' order by DEFINITION_").ToList(); } return(Json(USERLists, JsonRequestBehavior.AllowGet)); }
public ActionResult UserEdit(string id, USERS _users) { if (!GLOBALS.CookieAuth()) { return(RedirectToAction("Index", "Home")); } using (db) { db.Execute("update USERS set USERNAME='******',PASSWORD='******',CODE='" + _users.CODE + "'" + ",TEL='" + _users.TEL + "',TEL2='" + _users.TEL2 + "',EMAIL='" + _users.EMAIL + "'" + " where LOGICALREF=" + id + ""); } return(RedirectToAction("UserList")); }
public ActionResult UrunList(string searchSTR) { if (!GLOBALS.CookieAuth()) { return(RedirectToAction("Index", "Home")); } List <BarcodeUrun> _barcodeUrun = new List <BarcodeUrun>(); using (db) { _barcodeUrun = db.Query <BarcodeUrun>("Select top 200 * from LKSDB..AA_FormUrun").ToList(); } return(View(_barcodeUrun)); }
public ActionResult TeknikTalepler(string searchSTR) { if (!GLOBALS.CookieAuth()) { return(RedirectToAction("Index", "Home")); } List <FORMLines> _formLines = new List <FORMLines>(); using (db) { _formLines = db.Query <FORMLines>("select * from FORMLINE where DURUM=0 and ISTALEP=1 order by ADDDATE desc").ToList(); } return(View(_formLines)); }
// 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 UserList() { if (!GLOBALS.CookieAuth()) { return(RedirectToAction("Index", "Home")); } List <USERS> USERLists = new List <USERS>(); using (db) { USERLists = db.Query <USERS>("Select U.LOGICALREF, U.USERNAME, U.PASSWORD, AUTHORITY, AUTHID, FLAG, ADDDATE,C.LOGICALREF as CLIENTREF, C.DEFINITION_ as NAME,U.CODE" + " From USERS as U left outer join LKSDB..LG_" + GLOBALS.GFirma + "_CLCARD as C on U.CODE=C.CODE where 1=1 ").ToList(); } return(View(USERLists)); }
public ActionResult UserDelete(string id) { if (!GLOBALS.CookieAuth()) { return(RedirectToAction("Index", "Home")); } USERS _users = new USERS(); using (db) { _users = db.Query <USERS>("select * from USERS where LOGICALREF=" + id).SingleOrDefault(); } return(View(_users)); }
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 FormLine(FORMUrun obj) { //barkodlar ile ilgili kontorller if (String.IsNullOrEmpty(obj.ICBARKOD) || String.IsNullOrEmpty(obj.DISBARKOD)) { ViewData["msg"] = "<script>alert('İç Ve Dış Barkodlar Girilmeden İlerleyemezsiniz!!!');</script>"; return(View()); } SqlDataReader oku; if (obj.FORMTYPE == "MONTAJ") { oku = GLOBALS.GetDataReader("select LOGICALREF from FORMUrun where FORMTYPE = 'MONTAJ' and GOSTER=1 and(ICBARKOD in ('" + obj.ICBARKOD + "', '" + obj.DISBARKOD + "')" + " or DISBARKOD in ('" + obj.ICBARKOD + "','" + obj.DISBARKOD + "') or BARKOD3 in ('" + obj.ICBARKOD + "','" + obj.DISBARKOD + "') ) "); if (oku.Read()) { ViewData["msg"] = "<script>alert('Önceden Montajı Yapılmış Bir Ürünü Monte Edemezsiniz!!!');</script>"; return(View()); } oku = GLOBALS.GetDataReader("select * from FORMUrun where FICHENO='" + obj.FICHENO + "' and(ICBARKOD in ('" + obj.ICBARKOD + "', '" + obj.DISBARKOD + "')" + " or DISBARKOD in ('" + obj.ICBARKOD + "','" + obj.DISBARKOD + "') or BARKOD3 in ('" + obj.ICBARKOD + "','" + obj.DISBARKOD + "') ) "); if (oku.Read()) { ViewData["msg"] = "<script>alert('Aynı Barkoddan Giriş Yapamazsınız!!!');</script>"; return(View()); } } oku = GLOBALS.GetDataReader("select count(LOGICALREF) as Sayi from LKSDB..AA_FormUrun where Barcode='" + obj.ICBARKOD + "' or Barcode='" + obj.DISBARKOD + "' or Barcode='" + obj.BARKOD3 + "' "); if (oku.Read()) { int sayi = Convert.ToInt32(oku[0].ToString()); if (sayi < 2) { ViewData["msg"] = "<script>alert('Ticari sistemimizde Girdiğiniz Barkodlardan Eşleşen Bir Ürün Bulunmamaktadır!!!.');</script>"; return(View()); } else { string query = "insert into FORMUrun (FORMTYPE,FICHENO,ADDDATE,ICBARKOD,DISBARKOD,BARKOD3,FORMREF) values" + "('" + obj.FORMTYPE + "','" + obj.FICHENO + "','" + DateTime.Now.ToString("MM/dd/yyyy HH:mm:ss") + "','" + obj.ICBARKOD + "','" + obj.DISBARKOD + "','" + obj.BARKOD3 + "'," + obj.FORMREF + ")"; int affected = db.Execute(query); } } return(RedirectToAction("FormLine", new { ficheno = obj.FICHENO })); }
public ActionResult FormLine(FORMUrun obj) { //barkodlar ile ilgili kontorller if (String.IsNullOrEmpty(obj.ICBARKOD) || String.IsNullOrEmpty(obj.DISBARKOD)) { ViewData["msg"] = "<script>alert('İç Ve Dış Barkodlar Girilmeden İlerleyemezsiniz!!!');</script>"; return(View()); } SqlDataReader oku; if (obj.FORMTYPE == "ARIZA") { oku = GLOBALS.GetDataReader("select LOGICALREF from FORMUrun where FICHENO='" + obj.FICHENO + "' and(ICBARKOD in ('" + obj.ICBARKOD + "', '" + obj.DISBARKOD + "')" + " or DISBARKOD in ('" + obj.ICBARKOD + "','" + obj.DISBARKOD + "') or BARKOD3 in ('" + obj.ICBARKOD + "','" + obj.DISBARKOD + "') ) "); if (oku.Read()) { ViewData["msg"] = "<script>alert('Fiş İçerisine Aynı Üründen Giremezsiniz!!!');</script>"; return(View()); } } oku = GLOBALS.GetDataReader("select count(LOGICALREF) as Sayi from LKSDB..AA_FormUrun where Barcode='" + obj.ICBARKOD + "' or Barcode='" + obj.DISBARKOD + "' or Barcode='" + obj.BARKOD3 + "' "); if (oku.Read()) { int sayi = Convert.ToInt32(oku[0].ToString()); if (sayi < 2) { ViewData["msg"] = "<script>alert('Ticari sistemimizde Girdiğiniz Barkodlardan Eşleşen Bir Ürün Bulunmamaktadır!!!.');</script>"; return(View()); } else { string query = "insert into FORMUrun (FORMTYPE,FICHENO,ADDDATE,ICBARKOD,DISBARKOD,BARKOD3,FORMREF) values" + "('" + obj.FORMTYPE + "','" + obj.FICHENO.Replace(" ", "") + "','" + DateTime.Now.ToString("MM/dd/yyyy HH:mm:ss") + "','" + obj.ICBARKOD + "','" + obj.DISBARKOD + "','" + obj.BARKOD3 + "'," + obj.FORMREF + ")"; int affected = db.Execute(query); //garanti kontrolü yap SqlDataReader oku2 = GLOBALS.GetDataReader("select dateadd(year,2,ADDDATE) from FORMURUNView where FORMTYPE='MONTAJ' and (ICBARKOD='" + obj.ICBARKOD + "' or DISBARKOD='" + obj.DISBARKOD + "')"); if (!oku2.Read()) { ViewData["msg"] = "<script>alert('Girmiş Olduğunuz Ürünün Garanti Tanımı Bulunamadı!!!.');</script>"; return(View(obj)); } } } return(RedirectToAction("FormLine", new { ficheno = obj.FICHENO.Replace(" ", "") })); }
public ActionResult FormUrunEkle(FORMUrun obj) { bool durum = false; using (IDbConnection db = new SqlConnection(ConfigurationManager.ConnectionStrings["PTEKNIKMSSQL"].ConnectionString)) { SqlDataReader oku; if (obj.FORMTYPE == "montaj") { oku = GLOBALS.GetDataReader("select LOGICALREF from FORMUrun where FORMTYPE = 'montaj' and(ICBARKOD in ('" + obj.ICBARKOD + "', '" + obj.DISBARKOD + "', '" + obj.BARKOD3 + "')" + " or DISBARKOD in ('" + obj.ICBARKOD + "','" + obj.DISBARKOD + "','" + obj.BARKOD3 + "') or BARKOD3 in ('" + obj.ICBARKOD + "','" + obj.DISBARKOD + "','" + obj.BARKOD3 + "') ) "); if (!oku.Read()) { durum = true; } } oku = GLOBALS.GetDataReader("select count(LOGICALREF) as Sayi from LKSDB..AA_FormUrun where Barcode='" + obj.ICBARKOD + "' or Barcode='" + obj.DISBARKOD + "' or Barcode='" + obj.BARKOD3 + "' "); if (oku.Read()) { int sayi = Convert.ToInt32(oku[0].ToString()); if (sayi < 2) { durum = false; } else { durum = true; } } else { durum = false; } if (durum == true) { string query = "insert into FORMUrun (FORMTYPE,FICHENO,ADDDATE,ICBARKOD,DISBARKOD,BARKOD3,FORMREF) values" + "('" + obj.FORMTYPE + "','" + obj.FICHENO + "','" + DateTime.Now.ToString("MM/dd/yyyy HH:mm:ss") + "','" + obj.ICBARKOD + "','" + obj.DISBARKOD + "','" + obj.BARKOD3 + "'," + obj.FORMREF + ")"; int affected = db.Execute(query); } } return(Json(new { success = durum, }, JsonRequestBehavior.AllowGet)); }
public ActionResult UserEdit(string id, string fromAdd) { if (!GLOBALS.CookieAuth()) { return(RedirectToAction("Index", "Home")); } USERS _users = new USERS(); if (fromAdd == "1") { TempData["msg"] = "<script>alert('Bu Firmanın Kullanıcısı Mevcut Güncelleme Yapabilirsiniz!!!');</script>"; } using (db) { _users = db.Query <USERS>("select * from USERS where LOGICALREF=" + id).SingleOrDefault(); } return(View(_users)); }
public ActionResult GetUrunList(string searchSTR) { if (!GLOBALS.CookieAuth()) { return(RedirectToAction("Index", "Home")); } string SqlAra = ""; if (searchSTR != "") { SqlAra += " and replace(Barcode,' ','') like '%" + searchSTR.Replace(" ", "") + "%'"; } List <BarcodeUrun> _barcodeUrun = new List <BarcodeUrun>(); using (db) { _barcodeUrun = db.Query <BarcodeUrun>("Select top 200 * from LKSDB..AA_FormUrun where 1=1 " + SqlAra + " order by UrunAdi ").ToList(); } return(Json(_barcodeUrun, JsonRequestBehavior.AllowGet)); }
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 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 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 JsonResult FormSilJson(string ficheno, string ADDDATE) { int affectedRow = 0; SqlDataReader oku = GLOBALS.GetDataReader("select DURUM from FORMLINE where FICHENO='" + ficheno + "'"); if (oku.Read()) { if (String.IsNullOrEmpty(oku[0].ToString()) || oku[0].ToString() == "0") { using (db) { affectedRow += db.Execute("update FORMLINE set GOSTER=0 where replace(FICHENO,' ','')='" + ficheno.Replace(" ", "") + "'"); affectedRow += db.Execute("delete from FORMServes where replace(FICHENO,' ','')='" + ficheno.Replace(" ", "") + "'"); affectedRow += db.Execute("delete from FORMUrun where replace(FICHENO,' ','')='" + ficheno.Replace(" ", "") + "'"); } } } bool durum = (affectedRow > 0) ? true : false; return(Json(new { success = durum }, JsonRequestBehavior.AllowGet)); }
/// <summary> /// DisplayKeysUpdate - /// Update the key amounts based on the amounts contained in the line item. /// </summary> public void DisplayKeysUpdate() { this.display_keys.Clear(); // display keys are fine - but we need to edit working file. #if UPDATE_20190723 #if DEBUG // we're going to try the List <Tuple <string, string> > workingFileKeys = new List <Tuple <string, string> >(); foreach (Tuple <string, string> tss in working_file.entryAddenda.Keys) { workingFileKeys.Add(tss); } // okay - with the keys obtained - we're going to get the entry addedna value. #endif #endif foreach (Tuple <string, string> a in working_file.entryAddenda.Keys) { // set it up to pretty print the amount and pair with the name. // it almost looked like item 2 was assigned as amount. #if UPDATE_20190723 // updating this to only show a more manageable output value. string my_key = $"{GLOBALS.PadString(a.Item1,15)},\t{ENTRY_FORM.padding_router("Amount ", a.Item2, true)}"; #else string my_key = $"{a.Item1},\t{ENTRY_FORM.padding_router("Amount ", a.Item2, true)}"; #endif try { display_keys.Add(my_key, a); // update with the new keys amount. } catch (Exception e) { #if UPDATE_20190807 Program.encountered_Exceptions.Add(e); #endif // looks like this case is that key is duplicate - we'll need to adjust the key. my_key = $"[DUPLICATE]{my_key}"; display_keys.Add(my_key, a); }// this will help identify duplicates while we're at it. } }
public ActionResult UserAdd(USERS PostedUsers) { if (!GLOBALS.CookieAuth()) { return(RedirectToAction("Index", "Home")); } using (db) { string sqlQuery = "INSERT INTO [dbo].[USERS]" + "([USERNAME]" + ",[PASSWORD]" + ",[AUTHORITY]" + ",[AUTHID]" + ",[FLAG]" + ",[ADDDATE]" + ",[CLIENTREF]" + ",[TEL]" + ",[TEL2]" + ",[EMAIL]" + ",[NAME]" + ",[CODE])" + "VALUES" + "('" + PostedUsers.USERNAME + "'" + ",'" + PostedUsers.PASSWORD + "'" + ",'" + PostedUsers.AUTHORITY + "'" + ",'" + PostedUsers.AUTHID + "'" + ",0" + ",'" + DateTime.Now.ToString("MM/dd/yyyy HH:mm:ss") + "'" + ",'" + PostedUsers.CLIENTREF + "'" + ",'" + PostedUsers.TEL + "'" + ",'" + PostedUsers.TEL2 + "'" + ",'" + PostedUsers.EMAIL + "'" + ",'" + PostedUsers.NAME + "'" + ",'" + PostedUsers.CODE + "')"; int rowsAffected = db.Execute(sqlQuery); } return(RedirectToAction("UserList")); }
public ActionResult UserAdd(string clientref, string def, string code, string authid, string telnrs1) { if (!GLOBALS.CookieAuth()) { return(RedirectToAction("Index", "Home")); } //kullanıcı kontrolü SqlDataReader oku = GLOBALS.GetDataReader("select LOGICALREF from USERS where CLIENTREF=" + clientref + ""); if (oku.Read()) { return(RedirectToAction("UserEdit", new { id = oku[0].ToString(), fromAdd = 1 })); } USERS _users = new USERS(); _users.CLIENTREF = Convert.ToInt32((clientref == null) ? "0" : clientref); _users.NAME = def; _users.CODE = code; _users.AUTHID = Convert.ToInt32(authid); _users.TEL2 = telnrs1; _users.AUTHORITY = (authid == "1") ? "Teknik Servis" : "Admin"; return(View(_users)); }
void Start() { player = GameObject.FindGameObjectWithTag("Player"); glob = player.GetComponent <GLOBALS> (); }
// GET: Forms public ActionResult FormList(string formtype, string SearchSTR) { LoginCheck(); if (formtype == "Arıza") { ViewData["FormListTitle"] = "Arıza Formları"; } else if (formtype == "montaj") { ViewData["FormListTitle"] = "Montaj Formları"; } else { return(RedirectToAction("Index")); } string SqlAra = ""; if (!String.IsNullOrEmpty(SearchSTR)) { SqlAra = " and replace(BELGESTR,' ','') like '%" + SearchSTR.Replace(" ", "") + "%'"; } List <FORMLines> FormLists = new List <FORMLines>(); using (IDbConnection db = new SqlConnection(ConfigurationManager.ConnectionStrings["PTEKNIKMSSQL"].ConnectionString)) { FormLists = db.Query <FORMLines>("Select * From FORMLINE where CLIENTREF=" + GLOBALS.GetCookie("giris")["CLIENTREF"] + " and formtype='" + formtype + "' " + SqlAra).ToList(); } return(View(FormLists)); }
private void Fly( GLOBALS.Direction p_direction ) { if (!m_maxLeftReached && !m_maxRightReached) { Vector2 axisValue = Vector2.zero; switch (p_direction) { case GLOBALS.Direction.North: axisValue = new Vector2 (0f,1f); break; case GLOBALS.Direction.East: axisValue = new Vector2 (1f,0f); break; case GLOBALS.Direction.South: axisValue = new Vector2 (0f,-1f); break; case GLOBALS.Direction.West: axisValue = new Vector2 (-1f,0f); break; } m_movement.Move(axisValue); } if (transform.position.x <= m_maxLeftPosition) { m_maxLeftReached = true; } if (transform.position.x >= m_maxRightPosition) { m_maxRightReached = true; } }
private void Fly( GLOBALS.Direction p_direction ) { Vector2 axisValue = Vector2.zero; switch (p_direction) { case GLOBALS.Direction.North: axisValue = new Vector2 (0f,1f); break; case GLOBALS.Direction.East: axisValue = new Vector2 (1f,0f); break; case GLOBALS.Direction.South: axisValue = new Vector2 (0f,-1f); break; case GLOBALS.Direction.West: axisValue = new Vector2 (-1f,0f); break; } m_movement.Move(axisValue); }