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"));
}
public ActionResult UsersActive(System.Web.Mvc.FormCollection collection)
{
string USRID = collection["btnUsrId"];
int IS_AC;
using (DataVw dMan = new DataVw())
{
dsUser = dMan.ExecuteView_S("USR", "*", USRID, "", "ID = ");
}
DataRow newrow = dsUser.Tables[0].Rows[0];
if (Convert.ToBoolean(newrow["IS_AC"]))
{
IS_AC = 0;
}
else
{
IS_AC = 1;
}
newrow["ID"] = USRID;
newrow["IS_AC"] = IS_AC;
//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("USR", newrow, dsUser.Tables[0]);
return(Redirect("/Account/Users"));
}
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"));
}
}
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"));
}
}
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"));
}
}
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"));
}
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"));
}
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"));
}
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"));
}
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"));
}
}
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"));
}
}
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"));
}
public ActionResult SelectUserInfoChange(string txtUSRNM, string txtFULNM, string txtPWD, string txtEMAIL, string txtCARDNO, string txtCVC, string txtSTKDAY, string txtSTKMONTH, HttpPostedFileBase file, System.Web.Mvc.FormCollection collection)
{
DataSet dsUser = new DataSet();
string USRID = collection.AllKeys[8].ToString();
string filefo = "";
using (DataVw dMan = new DataVw())
{
dsUser = dMan.ExecuteView_S("USR", "*", USRID, "", "ID = ");
}
//if (txtUSRNM.ToString() == "" || txtFULNM.ToString() == "" || txtPWD.ToString() == "" || txtEMAIL.ToString() == "" || txtCARDNO.ToString() == "" || txtCVC.ToString() == "" || txtSTKDAY.ToString() == "" || txtSTKMONTH.ToString() == "")
//{
// return Content("<script language='javascript' type='text/javascript'>alert('Eksik veri girişi! Tüm Alanları Doldurunuz.');</script>"); ////Alert Mesajı Göndermek için.
// //ViewBag.addmessage = "Eksik veri girişi! Tüm Alanları Doldurunuz.";
// //return Redirect("/Account/Manage");
//}
//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].Rows[0];
newrow["ID"] = USRID;
newrow["USRNM"] = txtUSRNM;
newrow["FULNM"] = txtFULNM;
newrow["EMAIL"] = txtEMAIL;
newrow["PWD"] = CryptionHelper.Encrypt(txtPWD, "tb");
newrow["IS_ADMIN"] = 1;
newrow["IS_SYSADM"] = 0;
newrow["IS_HR"] = 0;
newrow["CHNG_PWD"] = 0;
if (filefo == "")
{
//newrow["AVATAR"] = "~/images/avatar/nullavatar.jpg";
newrow["AVATAR"] = newrow["AVATAR"];
}
else
{
newrow["AVATAR"] = filefo;
}
if (!Convert.ToBoolean(Session["IS_SYSADM"]))
{
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 Güncelleme İşlemi Gerçekleştirdi.";
AgentGc data = new AgentGc();
string veri = data.DataModified("USR", newrow, dsUser.Tables[0]);
//return Content("<script language='javascript' type='text/javascript'>alert('" + veri + "');</script>");
//ViewBag.addmessageinfo = veri;
return(Redirect("/Account/Manage"));
//}
//return Redirect("/Account/Manage");
}
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"));
}
}
