예제 #1
0
        public ActionResult SeanceAdd(FormCollection collection)
        {
            string FILMID     = collection["FilmList"];
            string HALLID     = collection["HallList"];
            string HALLTIMEID = collection["HallTimeList"];

            using (DataVw dMan = new DataVw())
            {
                dsFilmD = dMan.ExecuteView_S("FILM_D", "*", "", "", "");
            }

            DataRow newrow = dsFilmD.Tables[0].NewRow();

            newrow["ID"]         = Guid.NewGuid();
            newrow["FILMID"]     = FILMID;
            newrow["HALLID"]     = HALLID;
            newrow["HALLTIMEID"] = HALLTIMEID;
            newrow["EDATE"]      = DateTime.Now;
            //newrow["EUSRID"] = null;
            //newrow["UDATE"] = DateTime.Now;
            //newrow["UUSRID"] = null;
            newrow["NOTE"] = "En Son Kayıt İşlemi Gerçekleştirdi.";
            AgentGc data = new AgentGc();
            string  veri = data.DataAdded("FILM_D", newrow, dsFilmD.Tables[0]);

            return(Redirect("/Home/Admin"));
        }
예제 #2
0
        public ActionResult HomePktAdd(string txtTAPUNO, string txtADRES)
        {
            using (DataVw dMan = new DataVw())
            {
                dsHOME = dMan.ExecuteView_S("HOMESAFETY", "*", "", "", "");
            }

            if (txtTAPUNO.ToString() == "" || txtADRES.ToString() == "")
            {
                Session["useraddsuccess"] = false;
                ViewBag.addmessage        = "Eksik veri girişi! Tüm Alanları Doldurunuz.";
                return(Redirect("/Account/Pacekt"));
            }
            else
            {
                DataRow newrow = dsHOME.Tables[0].NewRow();
                newrow["ID"]     = Guid.NewGuid();
                newrow["TAPUNO"] = txtTAPUNO;
                newrow["ADRES"]  = txtADRES;
                AgentGc data = new AgentGc();
                string  veri = data.DataAdded("HOMESAFETY", newrow, dsHOME.Tables[0]);
                Session["useraddsuccess"] = true;
                ViewBag.addmessageinfo    = veri;
                return(Redirect("/Account/Admin"));
            }
        }
예제 #3
0
        public ActionResult FilmTypAdd(string txtFILMTYPNM)
        {
            //HomeController homeC = new HomeController();

            using (DataVw dMan = new DataVw())
            {
                dsFilmTyp  = dMan.ExecuteView_S("FILMTYP", "*", "", "", "");
                dsLogTable = dMan.ExecuteView_S("LOGTABLE", "*", "", "", "");
            }

            if (txtFILMTYPNM.ToString() == "")
            {
                Session["filmtypaddsuccess"] = false;
                ViewBag.addmessage           = "Eksik veri girişi! Tüm Alanları Doldurunuz.";
                return(Redirect("/Film/Category"));
            }
            else
            {
                DataRow newrow = dsFilmTyp.Tables[0].NewRow();
                newrow["ID"] = Guid.NewGuid();
                string ID = newrow["ID"].ToString();
                newrow["FILMTYPNM"] = txtFILMTYPNM;
                newrow["EDATE"]     = DateTime.Now;
                //newrow["EUSRID"] = homeC.UserData.USRID.ToString();
                //newrow["UDATE"] = DateTime.Now;
                //newrow["UUSRID"] = null;
                newrow["NOTE"] = "En Son Kayıt İşlemi Gerçekleştirdi.";
                AgentGc data = new AgentGc();
                string  veri = data.DataAdded("FILMTYP", newrow, dsFilmTyp.Tables[0]);
                if (veri == "İşleminiz Tamamlandı..")
                {
                    DataRow _newrow = dsLogTable.Tables[0].NewRow();
                    _newrow["ID"]         = Guid.NewGuid();
                    _newrow["LOGTABLE"]   = "FILMTYP";
                    _newrow["LOGTABLEID"] = ID;
                    _newrow["LOGIP"]      = GetIp();
                    _newrow["LOGUSRID"]   = Session["USRIDv"].ToString();
                    _newrow["EDATE"]      = DateTime.Now;
                    //newrow["EUSRID"] = null;
                    _newrow["UDATE"] = DateTime.Now;
                    //newrow["UUSRID"] = null;
                    _newrow["NOTE"] = "Kayıt İşlemi.";
                    AgentGc _data = new AgentGc();
                    string  _veri = _data.DataAdded("LOGTABLE", _newrow, dsLogTable.Tables[0]);
                    Session["filmtypaddsuccess"] = true;
                }
                ViewBag.addmessageinfo = veri;
                return(Redirect("/Home/Admin"));
            }
        }
예제 #4
0
        public ActionResult PktAdd(string txtPKTNAME, string txtPKTFIYAT, HttpPostedFileBase file, FormCollection collection)
        {
            string filefo = "";
            string pktTyp = collection["PktTyp"];

            using (DataVw dMan = new DataVw())
            {
                dsPKT = dMan.ExecuteView_S("PKT", "*", "", "", "");
            }

            if (txtPKTNAME.ToString() == "" || txtPKTFIYAT.ToString() == "")
            {
                Session["useraddsuccess"] = false;
                ViewBag.addmessage        = "Eksik veri girişi! Tüm Alanları Doldurunuz.";
                return(Redirect("/Account/Pacekt"));
            }
            else
            {
                if (file != null)
                {
                    string pic   = System.IO.Path.GetFileName(file.FileName);
                    string path  = System.IO.Path.Combine(Server.MapPath("~/images/pkt"), pic);
                    string pathd = "~/images/pkt/" + pic;
                    // file is uploaded
                    file.SaveAs(path);
                    filefo = pathd;

                    using (MemoryStream ms = new MemoryStream())
                    {
                        file.InputStream.CopyTo(ms);
                        byte[] array = ms.GetBuffer();
                    }
                }
                DataRow newrow = dsPKT.Tables[0].NewRow();
                newrow["ID"]       = Guid.NewGuid();
                newrow["PKTNAME"]  = txtPKTNAME;
                newrow["PKTFIYAT"] = txtPKTFIYAT;
                newrow["PKTTIPI"]  = pktTyp;
                newrow["PKTIMG"]   = filefo;
                AgentGc data = new AgentGc();
                string  veri = data.DataAdded("PKT", newrow, dsPKT.Tables[0]);
                Session["useraddsuccess"] = true;
                ViewBag.addmessageinfo    = veri;
                return(Redirect("/Account/Admin"));
            }
        }
예제 #5
0
        public ActionResult PriceUpdateEndAction(string txtPRICENM, string txtPRICE, FormCollection collection)
        {
            string C       = collection["btnCatID"];
            string PRICEID = Session["PRICEID"].ToString();

            using (DataVw dMan = new DataVw())
            {
                dsTicketPrice = dMan.ExecuteView_S("PRICES", "*", PRICEID, "", "ID = ");
                dsLogTable    = dMan.ExecuteView_S("LOGTABLE", "*", "", "", "");
            }

            DataRow newrow = dsTicketPrice.Tables[0].Rows[0];

            newrow["ID"]      = PRICEID;
            newrow["PRICENM"] = txtPRICENM;
            newrow["PRICE"]   = txtPRICE;
            //newrow["EDATE"] = DateTime.Now;
            //newrow["EUSRID"] = null;
            newrow["UDATE"] = DateTime.Now;
            //newrow["UUSRID"] = null;
            newrow["NOTE"] = "En Son Güncelleme İşlemi Gerçekleştirdi.";
            AgentGc data = new AgentGc();
            string  veri = data.DataModified("PRICES", newrow, dsTicketPrice.Tables[0]);

            if (veri == "İşleminiz Tamamlandı..")
            {
                DataRow _newrow = dsLogTable.Tables[0].NewRow();
                _newrow["ID"]         = Guid.NewGuid();
                _newrow["LOGTABLE"]   = "PRICES";
                _newrow["LOGTABLEID"] = PRICEID;
                _newrow["LOGIP"]      = GetIp();
                _newrow["LOGUSRID"]   = Session["USRIDv"].ToString();
                _newrow["EDATE"]      = DateTime.Now;
                //newrow["EUSRID"] = null;
                _newrow["UDATE"] = DateTime.Now;
                //newrow["UUSRID"] = null;
                _newrow["NOTE"] = "Güncelleme İşlemi.";
                AgentGc _data = new AgentGc();
                string  _veri = _data.DataAdded("LOGTABLE", _newrow, dsLogTable.Tables[0]);
                Session["filmaddsuccess"] = true;
            }

            return(Redirect("/Film/PriceUpdate"));
        }
예제 #6
0
        public ActionResult HomeSatis(string txtTAPUNO, string txtADRES)
        {
            DataSet dsHOMEAFETY = new DataSet();

            using (DataVw dMan = new DataVw())
            {
                dsHOMEAFETY = dMan.ExecuteView_S("HOMESAFETY", "*", "", "", "");
            }
            string  USRID  = Session["USRIDv"].ToString();
            DataRow newrow = dsHOMEAFETY.Tables[0].NewRow();

            newrow["ID"]     = Guid.NewGuid();
            newrow["PKTID"]  = Session["PKTID"].ToString();
            newrow["USRID"]  = USRID;
            newrow["TAPUNO"] = txtTAPUNO;
            newrow["ADRES"]  = txtADRES;
            AgentGc data = new AgentGc();
            string  veri = data.DataAdded("HOMESAFETY", newrow, dsHOMEAFETY.Tables[0]);


            return(Redirect("/Home/Index"));
        }
예제 #7
0
        public ActionResult PaketSatis(string txtPLAKA, string txtSASENO)
        {
            DataSet dsCARSAFETY = new DataSet();

            using (DataVw dMan = new DataVw())
            {
                dsCARSAFETY = dMan.ExecuteView_S("CARSAFETY", "*", "", "", "");
            }
            string  USRID  = Session["USRIDv"].ToString();
            DataRow newrow = dsCARSAFETY.Tables[0].NewRow();

            newrow["ID"]     = Guid.NewGuid();
            newrow["PKTID"]  = Session["PKTID"].ToString();
            newrow["USRID"]  = USRID;
            newrow["PLAKA"]  = txtPLAKA;
            newrow["SASENO"] = txtSASENO;
            AgentGc data = new AgentGc();
            string  veri = data.DataAdded("CARSAFETY", newrow, dsCARSAFETY.Tables[0]);


            return(Redirect("/Home/Index"));
        }
예제 #8
0
        public ActionResult FilmUpdateEndAction(string txtFILMNM, string txtFILMTYPID, string txtVISIONDATE, string txtFILMEXPLANATION, string txtFILMTIME, HttpPostedFileBase file, FormCollection collection)
        {
            string FILMID    = Session["FILMID"].ToString();
            string filmTypID = collection["FilmList"];
            string filefo    = "";

            using (DataVw dMan = new DataVw())
            {
                dsFilm     = dMan.ExecuteView_S("FILM", "*", FILMID, "", "ID = ");
                dsLogTable = dMan.ExecuteView_S("LOGTABLE", "*", "", "", "");
            }

            if (file != null)
            {
                string pic   = System.IO.Path.GetFileName(file.FileName);
                string path  = System.IO.Path.Combine(Server.MapPath("~/images/film"), pic);
                string pathd = "~/images/film/" + pic;
                // file is uploaded
                file.SaveAs(path);
                filefo = pathd;

                using (MemoryStream ms = new MemoryStream())
                {
                    file.InputStream.CopyTo(ms);
                    byte[] array = ms.GetBuffer();
                }
            }

            DataRow newrow = dsFilm.Tables[0].Rows[0];

            newrow["ID"]     = FILMID;
            newrow["FILMNM"] = txtFILMNM;
            if (filmTypID == "")
            {
                newrow["FILMTYPID"] = newrow["FILMTYPID"];
            }
            else
            {
                newrow["FILMTYPID"] = filmTypID;
            }

            if (filefo == "")
            {
                newrow["FILMIMG"] = newrow["FILMIMG"];
            }
            else
            {
                newrow["FILMIMG"] = filefo;
            }
            newrow["VISIONDATE"]  = Convert.ToDateTime(txtVISIONDATE);
            newrow["TIME"]        = txtFILMTIME;
            newrow["EXPLANATION"] = txtFILMEXPLANATION;
            //newrow["EDATE"] = DateTime.Now;
            //newrow["EUSRID"] = null;
            newrow["UDATE"] = DateTime.Now;
            //newrow["UUSRID"] = null;
            newrow["NOTE"] = "En Son Güncelleme İşlemi Gerçekleştirdi.";
            AgentGc data = new AgentGc();
            string  veri = data.DataModified("FILM", newrow, dsFilm.Tables[0]);

            if (veri == "İşleminiz Tamamlandı..")
            {
                DataRow _newrow = dsLogTable.Tables[0].NewRow();
                _newrow["ID"]         = Guid.NewGuid();
                _newrow["LOGTABLE"]   = "FILM";
                _newrow["LOGTABLEID"] = FILMID;
                _newrow["LOGIP"]      = GetIp();
                _newrow["LOGUSRID"]   = Session["USRIDv"].ToString();
                _newrow["EDATE"]      = DateTime.Now;
                //newrow["EUSRID"] = null;
                _newrow["UDATE"] = DateTime.Now;
                //newrow["UUSRID"] = null;
                _newrow["NOTE"] = "Güncelleme İşlemi.";
                AgentGc _data = new AgentGc();
                string  _veri = _data.DataAdded("LOGTABLE", _newrow, dsLogTable.Tables[0]);
                Session["filmaddsuccess"] = true;
            }
            return(Redirect("/Film/FilmUpdate"));
        }
예제 #9
0
        public ActionResult FilmAdd(string txtFILMNM, string txtFILMTYPID, /*string txtHALLID,*/ string txtVISIONDATE, string txtFILMEXPLANATION, string txtFILMTIME, HttpPostedFileBase file, FormCollection collection)
        {
            string filmID = collection["FilmList"];
            //string hallID = collection["HallList"];

            string filefo = "";

            using (DataVw dMan = new DataVw())
            {
                dsFilm     = dMan.ExecuteView_S("FILM", "*", "", "", "");
                dsLogTable = dMan.ExecuteView_S("LOGTABLE", "*", "", "", "");
            }

            if (txtFILMNM.ToString() == "" || txtVISIONDATE.ToString() == "" || filmID.ToString() == "" || txtFILMEXPLANATION.ToString() == "" || txtFILMTIME.ToString() == "" /*|| hallID.ToString() == ""*/)
            {
                Session["filmaddsuccess"] = false;
                ViewBag.addmessage        = "Eksik veri girişi! Tüm Alanları Doldurunuz.";
                return(Redirect("/Film/Film"));
            }
            else
            {
                if (file != null)
                {
                    string pic   = System.IO.Path.GetFileName(file.FileName);
                    string path  = System.IO.Path.Combine(Server.MapPath("~/images/film"), pic);
                    string pathd = "~/images/film/" + pic;
                    // file is uploaded
                    file.SaveAs(path);
                    filefo = pathd;

                    //Image img = System.Drawing.Image.FromFile(pathd);
                    //Image img2 = ResizeImage(img, 190, 273);

                    using (MemoryStream ms = new MemoryStream())
                    {
                        /////***********************************  Test Edilecek. ***********************************

                        //using (Image img = System.Drawing.Image.FromStream(ms))
                        //using (var newImage = ResizeImage(img, 190, 273))
                        //{
                        //    //Image img2 = ResizeImage(img, 190, 273);
                        //    newImage.Save(pathd, ImageFormat.Jpeg);
                        //}

                        file.InputStream.CopyTo(ms);
                        byte[] array = ms.GetBuffer();
                    }
                }

                DataRow newrow = dsFilm.Tables[0].NewRow();
                newrow["ID"] = Guid.NewGuid();
                string ID = newrow["ID"].ToString();
                newrow["FILMNM"]    = txtFILMNM;
                newrow["FILMTYPID"] = filmID;
                //newrow["HALLID"] = hallID;
                newrow["FILMIMG"]     = filefo;
                newrow["VISIONDATE"]  = Convert.ToDateTime(txtVISIONDATE);
                newrow["TIME"]        = txtFILMTIME;
                newrow["EXPLANATION"] = txtFILMEXPLANATION.Replace("'", "");
                newrow["EDATE"]       = DateTime.Now;
                //newrow["EUSRID"] = null;
                //newrow["UDATE"] = DateTime.Now;
                //newrow["UUSRID"] = null;
                newrow["NOTE"] = "En Son Kayıt İşlemi Gerçekleştirdi.";
                AgentGc data = new AgentGc();
                string  veri = data.DataAdded("FILM", newrow, dsFilm.Tables[0]);
                if (veri == "İşleminiz Tamamlandı..")
                {
                    DataRow _newrow = dsLogTable.Tables[0].NewRow();
                    _newrow["ID"]         = Guid.NewGuid();
                    _newrow["LOGTABLE"]   = "FILM";
                    _newrow["LOGTABLEID"] = ID;
                    _newrow["LOGIP"]      = GetIp();
                    _newrow["LOGUSRID"]   = Session["USRIDv"].ToString();
                    _newrow["EDATE"]      = DateTime.Now;
                    //newrow["EUSRID"] = null;
                    _newrow["UDATE"] = DateTime.Now;
                    //newrow["UUSRID"] = null;
                    _newrow["NOTE"] = "Kayıt İşlemi.";
                    AgentGc _data = new AgentGc();
                    string  _veri = _data.DataAdded("LOGTABLE", _newrow, dsLogTable.Tables[0]);
                    Session["filmaddsuccess"] = true;
                }
                ViewBag.addmessageinfo = veri;
                return(Redirect("/Home/Admin"));
            }
        }
예제 #10
0
        public ActionResult UserAdd(string txtUSRNM, string txtFULNM, string txtPWD, string txtEMAIL, string txtCARDNO, string txtCVC, string txtSTKDAY, string txtSTKMONTH, HttpPostedFileBase file)
        {
            string filefo = "";

            using (DataVw dMan = new DataVw())
            {
                dsUser = dMan.ExecuteView_S("USR", "*", "", "", "");
            }

            if (txtUSRNM.ToString() == "" || txtFULNM.ToString() == "" || txtPWD.ToString() == "" || txtEMAIL.ToString() == "" || txtCARDNO.ToString() == "" || txtCVC.ToString() == "" || txtSTKDAY.ToString() == "" || txtSTKMONTH.ToString() == "")
            {
                Session["useraddsuccess"] = false;
                ViewBag.addmessage        = "Eksik veri girişi! Tüm Alanları Doldurunuz.";
                return(Redirect("/Account/Register"));
            }
            else
            {
                if (file != null)
                {
                    string pic   = System.IO.Path.GetFileName(file.FileName);
                    string path  = System.IO.Path.Combine(Server.MapPath("~/images/avatar"), pic);
                    string pathd = "~/images/avatar/" + pic;
                    // file is uploaded
                    file.SaveAs(path);
                    filefo = pathd;

                    using (MemoryStream ms = new MemoryStream())
                    {
                        file.InputStream.CopyTo(ms);
                        byte[] array = ms.GetBuffer();
                    }
                }
                DataRow newrow = dsUser.Tables[0].NewRow();
                newrow["ID"]        = Guid.NewGuid();
                newrow["USRNM"]     = txtUSRNM;
                newrow["PWD"]       = CryptionHelper.Encrypt(txtPWD, "tb");
                newrow["FULNM"]     = txtFULNM;
                newrow["EMAIL"]     = txtEMAIL;
                newrow["IS_ADMIN"]  = 1;
                newrow["IS_SYSADM"] = 0;
                if (filefo == "")
                {
                    newrow["AVATAR"] = "~/images/avatar/nullavatar.jpg";
                }
                else
                {
                    newrow["AVATAR"] = filefo;
                }
                newrow["AVATAR"]   = filefo;
                newrow["CARDNO"]   = txtCARDNO;
                newrow["CVC"]      = txtCVC;
                newrow["STKDAY"]   = txtSTKDAY;
                newrow["STKMONTH"] = txtSTKMONTH;
                newrow["EDATE"]    = DateTime.Now;
                //newrow["EUSRID"] = null;
                newrow["UDATE"] = DateTime.Now;
                //newrow["UUSRID"] = null;
                newrow["NOTE"] = "En Son Kayıt İşlemi Gerçekleştirdi.";
                AgentGc data = new AgentGc();
                string  veri = data.DataAdded("USR", newrow, dsUser.Tables[0]);
                Session["useraddsuccess"] = true;
                ViewBag.addmessageinfo    = veri;
                return(Redirect("/Account/Login"));
            }
        }
예제 #11
0
        public ActionResult FilmticketFuncEnd(string txtFULNM, string txtEMAIL, string txtCARDNO, string txtCVC, string txtSTKDAY, FormCollection collection)
        {
            DataSet dsTICKET = new DataSet();

            Session["ISSENDMAIL"] = false;
            //string ToEmailStr = collection[0].ToString();
            string mailBody   = "<body><head>Null</head></body>";
            string mailtext   = "";
            string ToEmailStr = txtEMAIL;

            using (DataVw dMan = new DataVw())
            {
                dsTICKET = dMan.ExecuteView_S("TICKET", "*", "", "", "");
            }

            string STATUS = collection["bagButton"];                //1 İse Bilet al demiştir 0 İse sepete ekle demiştir.

            string TICKETTOTAL = Session["TICKETTOTAL"].ToString(); //Bilet Tutar
            string TICKETPIECE = Session["TICKETPIECE"].ToString(); //Adet

            string USRID      = Session["USRIDv"].ToString();
            string FILMID     = Session["FILMID"].ToString();
            string FILMNM     = GetFILMNM(Session["FILMID"].ToString());
            string FILMIMG    = GetFILMIMG(Session["FILMID"].ToString());
            string HALLID     = Session["HALLIDV"].ToString();
            string HALLNM     = GetHALLNM(Session["HALLIDV"].ToString());
            string HALLTIMEID = Session["HALLTIMEIDV"].ToString();
            string HALLTIME   = GetHALLTIME(Session["HALLTIMEIDV"].ToString());
            string SEATID     = Session["SEATID"].ToString();
            string SEATNM     = GetSEAT(Session["SEATID"].ToString());

            //FILMIMG = "http://*****:*****@hotmail.com"; //Gönderen
                        _Mail.ToEmail   = ToEmailStr;                     //Alıcı

                        _MailH.Send(_Mail);
                        Session["ISSENDMAIL"] = true;

                        DataRow[] dr = dsTICKET.Tables[0].Select(string.Format("ID='{0}'", ticketID));
                        if (dr.Length == 1)
                        {
                            string sql = "UPDATE TICKET SET MAILBODY=CAST('" + mailtext.Replace("'", "") + "' AS VARBINARY(MAX)) WHERE ID='" + ticketID + "'";
                            using (DataManager dMan = new DataManager())
                            {
                                dMan.Excequte(sql);
                            }
                        }

                        Session["TICKETSUCCESS"] = true;
                        return(Redirect("/Home/Filmticket"));
                    }
                    else
                    {
                        Session["TICKETSUCCESS"] = false;
                        ViewBag.TICKETINFO       = "Sistemsel Bir Hata Oluştu. Lütfen Daha Sonra Tekrar Deneyiniz.";
                        return(Redirect("/Home/Filmticket"));
                        //return Content("<script language='javascript' type='text/javascript'>alert('Sistemsel Bir Hata Oluştu. Lütfen Daha Sonra Tekrar Deneyiniz.');</script>");  ////Alert Mesajı Göndermek için.
                    }
                }
                catch (Exception)
                {
                    Session["TICKETSUCCESS"] = false;
                    ViewBag.addmessage       = "Sistemsel Bir Hata Oluştu. Lütfen Daha Sonra Tekrar Deneyiniz.";
                }
            }
            else
            {
                DataRow newrow = dsTICKET.Tables[0].NewRow();
                newrow["ID"] = Guid.NewGuid();
                string ticketID = newrow["ID"].ToString().ToUpper();
                newrow["FILMID"]      = FILMID;
                newrow["HALLID"]      = HALLID;
                newrow["HALLTIMEID"]  = HALLTIMEID;
                newrow["SEATID"]      = SEATID;
                newrow["USRID"]       = USRID;
                newrow["DATETIME"]    = DateTime.Now;
                newrow["TICKETPRICE"] = TICKETTOTAL.Replace("₺", "");
                newrow["SEATPIECE"]   = TICKETPIECE; //Düşünülecek..
                newrow["STATUS"]      = 0;
                newrow["EDATE"]       = DateTime.Now;
                //string xml = GetDashboardXml(mailBody);
                //newrow["MAILBODY"] = xml;
                //newrow["MAILTEXT"] = mailtext;
                //newrow["EUSRID"] = null;
                //newrow["UDATE"] = DateTime.Now;
                //newrow["UUSRID"] = null;
                newrow["NOTE"] = "En Son Kayıt İşlemi Gerçekleştirdi.";
                AgentGc data      = new AgentGc();
                string  insetInfo = data.DataAdded("TICKET", newrow, dsTICKET.Tables[0]);

                return(Redirect("/Home/Filmticket"));
            }

            return(Redirect("/Home/Filmticket"));
        }
예제 #12
0
        public ActionResult Control(string txtUsername, string txtPassword)
        {
            UserManager uMan = new UserManager(txtUsername, txtPassword);

            _li = uMan.CheckLogin();

            using (DataVw dMan = new DataVw())
            {
                dsUser     = dMan.ExecuteView_S("USR", "*", txtUsername, "", "USRNM =");
                dsLogError = dMan.ExecuteView_S("LOGERROR", "*", "", "", "");
            }

            if (dsUser.Tables[0].Rows.Count > 0)
            {
                DataRow row = dsUser.Tables[0].Rows[0];

                UserData       = new User();
                UserData.USRID = (Guid)row["ID"];

                UserData.USRNM     = Convert.ToString(row["USRNM"]);
                UserData.FULNM     = Convert.ToString(row["FULNM"]);
                UserData.AVATAR    = Convert.ToString(row["AVATAR"]);
                UserData.Email     = Convert.ToString(row["EMAIL"]);
                UserData.IS_ADMIN  = Convert.ToBoolean(row["IS_ADMIN"]);
                UserData.IS_SYSADM = Convert.ToBoolean(row["IS_SYSADM"]);
                UserData.IS_HR     = Convert.ToBoolean(row["IS_HR"]);

                if (txtUsername.ToString() == row["USRNM"].ToString() && txtPassword.ToString() == CryptionHelper.Decrypt(row["PWD"].ToString(), "tb").ToString())
                {
                    Session["USRIDv"]          = row["ID"].ToString();
                    Session["name"]            = row["FULNM"].ToString();
                    Session["admin"]           = true;
                    Session["IsAuthenticated"] = true;
                    Session["IS_SYSADM"]       = row["IS_SYSADM"].ToString();
                    //await SignInAsync(user, model.RememberMe);
                    if (row["IS_SYSADM"].ToString() == "True")
                    {
                        Session["loginRoles"] = true;
                        Session["admin"]      = true;
                        if (row["AVATAR"].ToString() == "")
                        {
                            Session["avatarimg"] = "~/images/avatar/nullavatar.jpg";
                        }
                        else
                        {
                            Session["avatarimg"] = row["AVATAR"].ToString();
                        }

                        return(Redirect("/Home/Admin"));
                    }
                    else
                    {
                        Session["IsAuthenticated"] = true;
                        Session["loginRoles"]      = false;
                        Session["admin"]           = false;
                        if (row["AVATAR"].ToString() == "")
                        {
                            Session["avatarimg"] = "~/images/avatar/nullavatar.jpg";
                        }
                        else
                        {
                            Session["avatarimg"] = row["AVATAR"].ToString();
                        }
                    }

                    return(Redirect("/Home/Index"));
                }

                DataRow newrow = dsLogError.Tables[0].NewRow();
                newrow["ID"]      = Guid.NewGuid();
                newrow["LOGINFO"] = "Kullanıcı adı : " + txtUsername + " " + "Parola : " + txtPassword;
                newrow["LOGIP"]   = GetIp();
                newrow["LOGDATE"] = DateTime.Now;
                newrow["EDATE"]   = DateTime.Now;
                //newrow["EUSRID"] = null;
                newrow["UDATE"] = DateTime.Now;
                //newrow["UUSRID"] = null;
                newrow["NOTE"] = "Parolaya Bağlı Hatalı Giriş.";
                AgentGc data = new AgentGc();
                string  veri = data.DataAdded("LOGERROR", newrow, dsLogError.Tables[0]);

                Session["loginFailed"]     = true;
                Session["IsAuthenticated"] = false;

                int loginErrorCount = Convert.ToInt32(Session["wrongpiece"]);

                Session["wrongpiece"] = loginErrorCount + 1;
                Session["wrongdate"]  = DateTime.Now;
                //Session["IP"] = GetIp();

                return(Redirect("/Account/Login"));
            }
            else
            {
                DataRow newrow = dsLogError.Tables[0].NewRow();
                newrow["ID"]      = Guid.NewGuid();
                newrow["LOGINFO"] = "Kullanıcı adı : " + txtUsername + " " + "Parola : " + txtPassword;
                newrow["LOGIP"]   = GetIp();
                newrow["LOGDATE"] = DateTime.Now;
                newrow["EDATE"]   = DateTime.Now;
                //newrow["EUSRID"] = null;
                newrow["UDATE"] = DateTime.Now;
                //newrow["UUSRID"] = null;
                newrow["NOTE"] = "Hatalı Giriş.";
                AgentGc data = new AgentGc();
                string  veri = data.DataAdded("LOGERROR", newrow, dsLogError.Tables[0]);

                Session["loginFailed"] = true;
                return(Redirect("/Account/Login"));
            }
        }