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