public ActionResult HallAdd(string txtHALLNM)
{
//HomeController homeC = new HomeController();
using (DataVw dMan = new DataVw())
{
dsHall = dMan.ExecuteView_S("HALL", "*", "", "", "");
dsLogTable = dMan.ExecuteView_S("LOGTABLE", "*", "", "", "");
}
if (txtHALLNM.ToString() == "")
{
Session["halladdsuccess"] = false;
ViewBag.addmessage = "Eksik veri girişi! Tüm Alanları Doldurunuz.";
return(Redirect("/Film/Hall"));
}
else
{
DataRow newrow = dsHall.Tables[0].NewRow();
newrow["ID"] = Guid.NewGuid();
string ID = newrow["ID"].ToString();
newrow["HALLNM"] = txtHALLNM;
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("HALL", newrow, dsHall.Tables[0]);
if (veri == "İşleminiz Tamamlandı..")
{
DataRow _newrow = dsLogTable.Tables[0].NewRow();
_newrow["ID"] = Guid.NewGuid();
_newrow["LOGTABLE"] = "HALL";
_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 Cust()
{
DataSet UserCarPKT = new DataSet();
string USRID = Session["USRIDv"].ToString();
using (DataVw dMan = new DataVw())
{
UserCarPKT = dMan.ExecuteView_S("CARv", "*", USRID, "", "USRID =");
}
List <CarPaket> CarPKT = new List <CarPaket>();
foreach (DataRow dr in UserCarPKT.Tables[0].Rows)
{
CarPKT.Add(new CarPaket
{
ID = (Guid)dr["ID"],
PKTID = dr["PKTNAME"].ToString(),
USRID = dr["USRNM"].ToString(),
PLAKA = dr["PLAKA"].ToString(),
SASENO = dr["SASENO"].ToString(),
});
}
ViewBag.CARPKT = CarPKT;
DataSet UserHomePKT = new DataSet();
using (DataVw dMan = new DataVw())
{
UserHomePKT = dMan.ExecuteView_S("HOMEv", "*", USRID, "", "USRID =");
}
List <HomePaket> HomePKT = new List <HomePaket>();
foreach (DataRow dr in UserHomePKT.Tables[0].Rows)
{
HomePKT.Add(new HomePaket
{
ID = (Guid)dr["ID"],
PKTID = dr["PKTNAME"].ToString(),
USRID = dr["USRNM"].ToString(),
TAPUNO = dr["TAPUNO"].ToString(),
ADRES = dr["ADRES"].ToString(),
});
}
ViewBag.HOMEPKT = HomePKT;
return(View());
}
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 UserBag()
{
using (DataVw dMan = new DataVw())
{
dsUserBag = dMan.ExecuteView_S("TICKETINFO_V WHERE USRID = '" + Session["USRIDv"].ToString() + "' AND STATUS = 0", "*", "", "", "");
}
List <UserBagV> userBag = new List <UserBagV>();
foreach (DataRow dr in dsUserBag.Tables[0].Rows)
{
userBag.Add(new UserBagV
{
ID = (Guid)dr["ID"],
FILMID = (Guid)dr["FILMID"],
HALLID = (Guid)dr["HALLID"],
HALLTIMEID = (Guid)dr["HALLTIMEID"],
SEATID = (Guid)dr["SEATID"],
USRID = (Guid)dr["USRID"],
DATETIME = (DateTime)dr["DATETIME"],
TICKETPRICE = dr["TICKETPRICE"].ToString() + " ₺",
FID = (Guid)dr["FID"],
FILMNM = dr["FILMNM"].ToString(),
FILMIMG = dr["FILMIMG"].ToString(),
VISIONDATE = (DateTime)dr["VISIONDATE"],
TIME = dr["TIME"].ToString(),
EXPLANATION = dr["EXPLANATION"].ToString(),
HID = (Guid)dr["HID"],
HALLNM = dr["HALLNM"].ToString(),
HTID = (Guid)dr["HTID"],
HALLTIME = dr["HALLTIME"].ToString(),
SID = (Guid)dr["SID"],
SEATNM = dr["SEATNM"].ToString(),
UID = (Guid)dr["UID"],
USRNM = dr["USRNM"].ToString(),
FULNM = dr["FULNM"].ToString(),
AVATAR = dr["AVATAR"].ToString()
});
}
ViewBag.UserBag = userBag;
return(View());
}
public ActionResult FilmTicketProcess()
{
using (DataVw dMan = new DataVw())
{
dsTicketInfo = dMan.ExecuteView_S("TICKETINFO_V WHERE STATUS = 1", "*", "", "", "");
}
List <TicketInfo> ticketInfoList = new List <TicketInfo>();
foreach (DataRow dr in dsTicketInfo.Tables[0].Rows)
{
ticketInfoList.Add(new TicketInfo {
ID = (Guid)dr["ID"],
FILMID = (Guid)dr["FILMID"],
HALLID = (Guid)dr["HALLID"],
HALLTIMEID = (Guid)dr["HALLTIMEID"],
SEATID = (Guid)dr["SEATID"],
USRID = (Guid)dr["USRID"],
DATETIME = (DateTime)dr["DATETIME"],
FID = (Guid)dr["FID"],
FILMNM = dr["FILMNM"].ToString(),
FILMIMG = dr["FILMIMG"].ToString(),
VISIONDATE = (DateTime)dr["VISIONDATE"],
TIME = dr["TIME"].ToString(),
EXPLANATION = dr["EXPLANATION"].ToString(),
HID = (Guid)dr["HID"],
HALLNM = dr["HALLNM"].ToString(),
HTID = (Guid)dr["HTID"],
HALLTIME = dr["HALLTIME"].ToString(),
SID = (Guid)dr["SID"],
SEATNM = dr["SEATNM"].ToString(),
UID = (Guid)dr["UID"],
USRNM = dr["USRNM"].ToString(),
FULNM = dr["FULNM"].ToString(),
AVATAR = dr["AVATAR"].ToString()
});
}
ViewBag.TicketInfoList = ticketInfoList;
return(View());
}
public ActionResult FilmUpdateEnd()
{
string FILMID = Session["FILMID"].ToString();
using (DataVw dMan = new DataVw())
{
dsFilmInfo = dMan.ExecuteView_S("FILM_TYP_V", "*", FILMID, "", "ID = ");
dsFilmTyp = dMan.ExecuteView_S("FILMTYP", "*", "", "", "");
}
List <SelectListItem> filmList = new List <SelectListItem>();
foreach (DataRow dr in dsFilmTyp.Tables[0].Rows)
{
filmList.Add(new SelectListItem {
Text = Convert.ToString(dr["FILMTYPNM"]), Value = dr["ID"].ToString()
});
}
List <FilmTypV> FilmListSelect = new List <FilmTypV>();
foreach (DataRow dr in dsFilmInfo.Tables[0].Rows)
{
FilmListSelect.Add(new FilmTypV
{
ID = (Guid)dr["ID"],
FILMNM = dr["FILMNM"].ToString(),
FILMTYPID = (Guid)dr["FILMTYPID"],
FILMIMG = dr["FILMIMG"].ToString(),
VISIONDATE = (DateTime)dr["VISIONDATE"],
TIME = dr["TIME"].ToString(),
EXPLANATION = dr["EXPLANATION"].ToString().Substring(0, 230),
F2ID = (Guid)dr["F2ID"],
FILMTYPNM = dr["FILMTYPNM"].ToString(),
});
}
ViewBag.FilmList = filmList;
ViewBag.FilmListSelect = FilmListSelect;
return(View());
}
//
// GET: /Paket/
public ActionResult Pacekt()
{
using (DataVw dMan = new DataVw())
{
dsPKTTYP = dMan.ExecuteView_S("PKTTYPE", "*", "", "", "");
}
List <SelectListItem> pktTyp = new List <SelectListItem>();
foreach (DataRow dr in dsPKTTYP.Tables[0].Rows)
{
pktTyp.Add(new SelectListItem {
Text = Convert.ToString(dr["TPYENAME"]), Value = dr["ID"].ToString()
});
}
ViewBag.PktTyp = pktTyp;
return(View());
}
public ActionResult CategoryDelete()
{
using (DataVw dMan = new DataVw())
{
dsFilmTyp = dMan.ExecuteView_S("FILMTYP", "*", "", "", "");
}
List <FilmTypList> FilmTypList = new List <FilmTypList>();
foreach (DataRow dr in dsFilmTyp.Tables[0].Rows)
{
FilmTypList.Add(new FilmTypList {
ID = (Guid)dr["ID"], FILMTYPNM = dr["FILMTYPNM"].ToString()
});
}
ViewBag.FilmTypList = FilmTypList;
return(View());
}
public ActionResult HallDelete()
{
using (DataVw dMan = new DataVw())
{
dsHall = dMan.ExecuteView_S("HALL", "*", "", "", "");
}
List <HallList> HallList = new List <HallList>();
foreach (DataRow dr in dsHall.Tables[0].Rows)
{
HallList.Add(new HallList {
ID = (Guid)dr["ID"], HALLNM = dr["HALLNM"].ToString()
});
}
ViewBag.HallList = HallList;
return(View());
}
public ActionResult Seance()
{
using (DataVw dMan = new DataVw())
{
dsFilm = dMan.ExecuteView_S("FILM", "*", "", "", "");
dsHall = dMan.ExecuteView_S("HALL", "*", "", "", "");
dsHallTime = dMan.ExecuteView_S("HALLTIME", "*", "", "", "");
}
List <SelectListItem> filmList = new List <SelectListItem>();
List <SelectListItem> hallList = new List <SelectListItem>();
List <SelectListItem> hallTimeList = new List <SelectListItem>();
foreach (DataRow dr in dsFilm.Tables[0].Rows)
{
filmList.Add(new SelectListItem {
Text = Convert.ToString(dr["FILMNM"]), Value = dr["ID"].ToString()
});
}
foreach (DataRow dr in dsHall.Tables[0].Rows)
{
hallList.Add(new SelectListItem {
Text = Convert.ToString(dr["HALLNM"]), Value = dr["ID"].ToString()
});
}
foreach (DataRow dr in dsHallTime.Tables[0].Rows)
{
hallTimeList.Add(new SelectListItem {
Text = Convert.ToString(dr["HALLTIME"]), Value = dr["ID"].ToString()
});
}
ViewBag.FilmList = filmList;
ViewBag.HallList = hallList;
ViewBag.HallTimeList = hallTimeList;
return(View());
}
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 Filmseat()
{
string HALLIDStr = Session["HALLIDV"].ToString();
string HALLTIMEIDStr = Session["HALLTIMEIDV"].ToString();
string IdValue = Session["FILMID"].ToString();
DataSet dsFilmD = new DataSet();
DataSet dsFilmInfo = new DataSet();
DataSet dsFilmSeat = new DataSet();
using (DataVw dMan = new DataVw())
{
dsFilmD = dMan.ExecuteView_S("FILM", "*", IdValue, "", "ID = ");
dsFilmInfo = dMan.ExecuteView_S("FILMINFO", "*", IdValue, "", "FILMID = ");
dsFilmSeat = dMan.ExecuteView_S("SEAT", "*", HALLIDStr, "", "HALLID = ");
}
FilmSeat s = new FilmSeat();
List <FilmSeat> filmSeat = new List <FilmSeat>();
foreach (DataRow dr in dsFilmSeat.Tables[0].Rows)
{
filmSeat.Add(new FilmSeat
{
ID = (Guid)dr["ID"],
SEATNM = dr["SEATNM"].ToString(),
HALLID = (Guid)dr["HALLID"],
STATUS = Convert.ToBoolean(dr["STATUS"].ToString())
});
}
List <FilmSeat> filmSeatSorted = filmSeat.OrderBy(o => o.SEATNM).ToList();
//filmSeat.Sort();
ViewBag.FilmSeatList = filmSeatSorted;
return(View(filmSeat));
}
public ActionResult CategoryUpdateEnd()
{
string CATEGOTYID = Session["CATEGOTYID"].ToString();
using (DataVw dMan = new DataVw())
{
dsFilmTyp = dMan.ExecuteView_S("FILMTYP", "*", CATEGOTYID, "", "ID = ");
}
List <FilmTypList> FilmTypListSelect = new List <FilmTypList>();
foreach (DataRow dr in dsFilmTyp.Tables[0].Rows)
{
FilmTypListSelect.Add(new FilmTypList {
ID = (Guid)dr["ID"], FILMTYPNM = dr["FILMTYPNM"].ToString()
});
}
ViewBag.FilmTypListSelect = FilmTypListSelect;
return(View());
}
public ActionResult HallUpdateEnd()
{
string HALLID = Session["HALLID"].ToString();
using (DataVw dMan = new DataVw())
{
dsFilmTyp = dMan.ExecuteView_S("HALL", "*", HALLID, "", "ID = ");
}
List <HallList> HallListSelect = new List <HallList>();
foreach (DataRow dr in dsFilmTyp.Tables[0].Rows)
{
HallListSelect.Add(new HallList {
ID = (Guid)dr["ID"], HALLNM = dr["HALLNM"].ToString()
});
}
ViewBag.HallListSelect = HallListSelect;
return(View());
}
public ActionResult PriceUpdate()
{
using (DataVw dMan = new DataVw())
{
dsTicketPrice = dMan.ExecuteView_S("PRICES", "*", "", "", "");
}
List <PriceList> priceList = new List <PriceList>();
foreach (DataRow dr in dsTicketPrice.Tables[0].Rows)
{
priceList.Add(new PriceList {
ID = (Guid)dr["ID"],
PRICENM = dr["PRICENM"].ToString(),
PRICE = dr["PRICE"].ToString(),
});
}
ViewBag.PriceList = priceList;
return(View());
}
public ActionResult Filmprice()
{
using (DataVw dMan = new DataVw())
{
dsFilmprice = dMan.ExecuteView_S("PRICES", "*", "1", "", "PRICESTATUS = ");
}
List <FilmPrice> filmprice = new List <FilmPrice>();
foreach (DataRow dr in dsFilmprice.Tables[0].Rows)
{
filmprice.Add(new FilmPrice
{
ID = (Guid)dr["ID"],
PRICENM = dr["PRICENM"].ToString(),
PRICE = dr["PRICE"].ToString()
});
}
ViewBag.Filmprice = filmprice;
return(View());
}
public ActionResult BagTransactions(FormCollection collection)
{
DataSet dsTICKET = new DataSet();
DataSet dsUSR = new DataSet();
string TICKETID = collection.AllKeys[0]; // TICKET id
string STATUS = collection[0]; //1 İse ödeme yap 0 ise çıkar yani sil
string mailtext = "";
if (Convert.ToInt32(STATUS) == 1)
{
using (DataVw dMan = new DataVw())
{
dsTICKET = dMan.ExecuteView_S("TICKET", "*", "", "", "");
dsUSR = dMan.ExecuteView_S("USR", "*", "", "", "");
}
DataRow[] drTick = dsTICKET.Tables[0].Select(string.Format("ID='{0}'", TICKETID));
string FILMNM = GetFILMNM(drTick[0]["FILMID"].ToString());
string FILMIMG = GetFILMIMG(drTick[0]["FILMID"].ToString());
string HALLNM = GetHALLNM(drTick[0]["HALLID"].ToString());
string HALLTIME = GetHALLTIME(drTick[0]["HALLTIMEID"].ToString());
string SEATNM = GetSEAT(drTick[0]["SEATID"].ToString());
string TICKETPRICE = drTick[0]["TICKETPRICE"].ToString();
string SEATPIECE = drTick[0]["SEATPIECE"].ToString();
//FILMIMG = "http://*****:*****@hotmail.com"; //Gönderen
DataRow[] drUsrMail = dsUSR.Tables[0].Select(string.Format("ID='{0}'", Session["USRIDv"].ToString()));
_Mail.ToEmail = drUsrMail[0]["EMAIL"].ToString(); //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)), STATUS = 1 WHERE ID='" + TICKETID + "'";
using (DataManager dMan = new DataManager())
{
dMan.Excequte(sql);
}
}
Session["TICKETSUCCESS"] = true;
return(Redirect("/Home/UserBag"));
}
else
{
string sql = string.Format("DELETE FROM TICKET WHERE ID ='{0}'", TICKETID);
using (DataManager dMan = new DataManager())
{
int info = dMan.Excequte(sql);
}
return(Redirect("/Home/UserBag"));
}
return(Redirect("/Home/UserBag"));
}
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 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 Filminfo()
{
string IdValue = Session["FILMID"].ToString();
DataSet dsFilmD = new DataSet();
DataSet dsFilmInfo = new DataSet();
using (DataVw dMan = new DataVw())
{
dsFilmD = dMan.ExecuteView_S("FILM", "*", IdValue, "", "ID = ");
dsFilmInfo = dMan.ExecuteView_S("FILMINFO", "*", IdValue, "", "FILMID = ");
}
FilmD s = new FilmD();
List <FilmD> filmDe = new List <FilmD>();
foreach (DataRow dr in dsFilmD.Tables[0].Rows)
{
filmDe.Add(new FilmD
{
ID = (Guid)dr["ID"],
FILMNM = dr["FILMNM"].ToString(),
FILMTYPID = (Guid)dr["FILMTYPID"],
FILMIMG = dr["FILMIMG"].ToString(),
VISIONDATE = (DateTime)dr["VISIONDATE"],
TIME = dr["TIME"].ToString(),
EXPLANATION = dr["EXPLANATION"].ToString().Substring(0, 230)
});
}
List <FilmInfo> filmInfo = new List <FilmInfo>();
foreach (DataRow dr in dsFilmInfo.Tables[0].Rows)
{
filmInfo.Add(new FilmInfo
{
FID = (Guid)dr["ID"],
FFILMID = (Guid)dr["FILMID"],
FHALLID = (Guid)dr["HALLID"],
FFID = (Guid)dr["FID"],
HID = (Guid)dr["HID"],
HALLNM = dr["HALLNM"].ToString(),
H2ID = (Guid)dr["H2ID"],
HALLTIME = dr["HALLTIME"].ToString()
});
}
//var filmHallGroup = from flm in filmInfo
// group flm by flm.HALLNM;
//var filmHallGroup = filmInfo.GroupBy(flm => flm.HALLNM[0]);
var filmHallGroup = filmInfo.GroupBy(flm => flm.HALLNM).Select(g => new FilmGroup
{
Key = g.Key
//Tag = g
});
ViewBag.FilmListDe = filmDe;
ViewBag.FilmListInfo = filmInfo;
ViewBag.FilmHallGroup = filmHallGroup;
return(View(filmDe));
}
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 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"));
}
}
public ActionResult Control(string txtUsername, string txtPassword)
{
HomeController HomeCont = new HomeController();
UserManager uMan = new UserManager(txtUsername, txtPassword);
_li = uMan.CheckLogin();
using (DataVw dMan = new DataVw())
{
dsUser = dMan.ExecuteView_S("USR", "*", txtUsername, "", "USRNM =");
}
if (dsUser.Tables[0].Rows.Count > 0)
{
DataRow row = dsUser.Tables[0].Rows[0];
if (txtUsername.ToString() == row["USRNM"].ToString() && txtPassword.ToString() == CryptionHelper.Decrypt(row["PWD"].ToString(), "tb").ToString())
{
Session["USRSTATUS"] = row["IS_ADMIN"].ToString();
Session["USRSTATUSADM"] = row["IS_SYSADM"].ToString();
Session["USRIDv"] = row["ID"].ToString();
Session["name"] = row["FULNM"].ToString();
//Session["admin"] = true;
//Session["loginError"] = true;
Session["IsAuthenticated"] = true;
Session["ADMIN"] = row["IS_SYSADM"].ToString();
if (row["IS_SYSADM"].ToString() == "True")
{
Session["IS_SYSADM"] = true;
//Session["loginRoles"] = true;
//Session["admin"] = true;
if (row["AVATAR"].ToString() == "")
{
Session["avatarimg"] = "~/images/profil/nullavatar.jpg";
}
else
{
Session["avatarimg"] = row["AVATAR"].ToString();
}
return(Redirect("/Account/Admin"));
}
else
{
Session["IsAuthenticated"] = true;
Session["loginRoles"] = false;
Session["CUST"] = true;
Session["IS_ADMIN"] = true;
if (row["AVATAR"].ToString() == "")
{
Session["avatarimg"] = "~/images/profil/nullavatar.jpg";
}
else
{
Session["avatarimg"] = row["AVATAR"].ToString();
}
return(Redirect("/Account/Cust"));
}
}
Session["loginError"] = 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
{
Session["loginError"] = true;
return(Redirect("/Account/Login"));
}
}
// GET: /Account/
public ActionResult LogTable()
{
using (DataVw dMan = new DataVw())
{
dsLogTableFilm = dMan.ExecuteView_S("FILM_LOG", "*", "", "", "");
dsLogTableHall = dMan.ExecuteView_S("HALL_LOG", "*", "", "", "");
dsLogTableFilmTyp = dMan.ExecuteView_S("FILMTYP_LOG", "*", "", "", "");
}
List <LogtableFilm> logtableFilm = new List <LogtableFilm>();
foreach (DataRow dr in dsLogTableFilm.Tables[0].Rows)
{
logtableFilm.Add(new LogtableFilm
{
ID = (Guid)dr["ID"],
LOGTABLE = dr["LOGTABLE"].ToString(),
LOGTABLEID = (Guid)dr["LOGTABLEID"],
LOGIP = dr["LOGIP"].ToString(),
FULNM = dr["FULNM"].ToString(),
FILMNM = dr["FILMNM"].ToString(),
FILMIMG = dr["FILMIMG"].ToString(),
EDATE = (DateTime)dr["EDATE"],
EUSRID = dr["EUSRID"].ToString(),
UDATE = (DateTime)dr["UDATE"],
UUSRID = dr["UUSRID"].ToString(),
NOTE = dr["NOTE"].ToString()
});
}
ViewBag.LogtableFilm = logtableFilm;
List <LogtableHall> logtableHall = new List <LogtableHall>();
foreach (DataRow dr in dsLogTableHall.Tables[0].Rows)
{
logtableHall.Add(new LogtableHall
{
ID = (Guid)dr["ID"],
LOGTABLE = dr["LOGTABLE"].ToString(),
LOGTABLEID = (Guid)dr["LOGTABLEID"],
LOGIP = dr["LOGIP"].ToString(),
FULNM = dr["FULNM"].ToString(),
HALLNM = dr["HALLNM"].ToString(),
EDATE = (DateTime)dr["EDATE"],
EUSRID = dr["EUSRID"].ToString(),
UDATE = (DateTime)dr["UDATE"],
UUSRID = dr["UUSRID"].ToString(),
NOTE = dr["NOTE"].ToString()
});
}
ViewBag.LogtableHall = logtableHall;
List <LogtableFilmTyp> logtableFilmTyp = new List <LogtableFilmTyp>();
foreach (DataRow dr in dsLogTableFilmTyp.Tables[0].Rows)
{
logtableFilmTyp.Add(new LogtableFilmTyp
{
ID = (Guid)dr["ID"],
LOGTABLE = dr["LOGTABLE"].ToString(),
LOGTABLEID = (Guid)dr["LOGTABLEID"],
LOGIP = dr["LOGIP"].ToString(),
FULNM = dr["FULNM"].ToString(),
FILMTYPNM = dr["FILMTYPNM"].ToString(),
EDATE = (DateTime)dr["EDATE"],
EUSRID = dr["EUSRID"].ToString(),
UDATE = (DateTime)dr["UDATE"],
UUSRID = dr["UUSRID"].ToString(),
NOTE = dr["NOTE"].ToString()
});
}
ViewBag.LogtableFilmTyp = logtableFilmTyp;
return(View());
}
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"));
}
//
// GET: /Account/
public ActionResult Users()
{
using (DataVw dMan = new DataVw())
{
dsUser = dMan.ExecuteView_S("USR", "*", "", "", "");
}
List <AdmUserList> admuserList = new List <AdmUserList>();
foreach (DataRow dr in dsUser.Tables[0].Rows)
{
string IS_AC, IS_SYSADM, IS_ADMIN, IS_HR, CHNG_PWD;
if (Convert.ToBoolean(dr["IS_AC"]))
{
IS_AC = "Evet";
}
else
{
IS_AC = "Hayır";
}
if (Convert.ToBoolean(dr["IS_SYSADM"]))
{
IS_SYSADM = "Evet";
}
else
{
IS_SYSADM = "Hayır";
}
if (Convert.ToBoolean(dr["IS_ADMIN"]))
{
IS_ADMIN = "Evet";
}
else
{
IS_ADMIN = "Hayır";
}
if (Convert.ToBoolean(dr["IS_HR"]))
{
IS_HR = "Evet";
}
else
{
IS_HR = "Hayır";
}
if (Convert.ToBoolean(dr["CHNG_PWD"]))
{
CHNG_PWD = "Evet";
}
else
{
CHNG_PWD = "Hayır";
}
admuserList.Add(new AdmUserList
{
ID = (Guid)dr["ID"],
IS_AC = IS_AC,
USRNM = dr["USRNM"].ToString(),
PWD = CryptionHelper.Decrypt(dr["PWD"].ToString(), "tb"),
FULNM = dr["FULNM"].ToString(),
EMAIL = dr["EMAIL"].ToString(),
IS_SYSADM = IS_SYSADM,
IS_ADMIN = IS_ADMIN,
IS_HR = IS_HR,
CHNG_PWD = CHNG_PWD,
AVATAR = dr["AVATAR"].ToString(),
EDATE = (DateTime)dr["EDATE"],
UDATE = (DateTime)dr["UDATE"],
CARDNO = dr["CARDNO"].ToString(),
CVC = dr["CVC"].ToString(),
STKDAY = dr["STKDAY"].ToString(),
STKMONTH = dr["STKMONTH"].ToString()
});
}
ViewBag.UserList = admuserList;
return(View());
}
//
// GET: /Account/
public ActionResult Transactions()
{
using (DataVw dMan = new DataVw())
{
dsUserTransactions = dMan.ExecuteView_S("TICKETINFO_V WHERE USRID = '" + Session["USRIDv"].ToString() + "' AND STATUS = 1", "*", "", "", "");
dsUserTransactionsD = dMan.ExecuteView_S("TICKETINFO_V WHERE USRID = '" + Session["USRIDv"].ToString() + "' AND STATUS = 0", "*", "", "", "");
}
string SSTATUS = "";
List <UserTransactions> userTransactions = new List <UserTransactions>();
foreach (DataRow dr in dsUserTransactions.Tables[0].Rows)
{
if (Convert.ToBoolean(dr["STATUS"]))
{
SSTATUS = "Ödendi";
}
userTransactions.Add(new UserTransactions
{
ID = (Guid)dr["ID"],
FILMID = (Guid)dr["FILMID"],
HALLID = (Guid)dr["HALLID"],
HALLTIMEID = (Guid)dr["HALLTIMEID"],
SEATID = (Guid)dr["SEATID"],
USRID = (Guid)dr["USRID"],
DATETIME = (DateTime)dr["DATETIME"],
TICKETPRICE = dr["TICKETPRICE"].ToString() + " ₺",
STATUS = SSTATUS,
FID = (Guid)dr["FID"],
FILMNM = dr["FILMNM"].ToString(),
FILMIMG = dr["FILMIMG"].ToString(),
VISIONDATE = (DateTime)dr["VISIONDATE"],
TIME = dr["TIME"].ToString(),
EXPLANATION = dr["EXPLANATION"].ToString(),
HID = (Guid)dr["HID"],
HALLNM = dr["HALLNM"].ToString(),
HTID = (Guid)dr["HTID"],
HALLTIME = dr["HALLTIME"].ToString(),
SID = (Guid)dr["SID"],
SEATNM = dr["SEATNM"].ToString(),
UID = (Guid)dr["UID"],
USRNM = dr["USRNM"].ToString(),
FULNM = dr["FULNM"].ToString(),
AVATAR = dr["AVATAR"].ToString()
});
}
List <UserTransactions> userTransactionsD = new List <UserTransactions>();
foreach (DataRow dr in dsUserTransactionsD.Tables[0].Rows)
{
if (!Convert.ToBoolean(dr["STATUS"]))
{
SSTATUS = "Ödeme Yapılmadı";
}
userTransactionsD.Add(new UserTransactions
{
ID = (Guid)dr["ID"],
FILMID = (Guid)dr["FILMID"],
HALLID = (Guid)dr["HALLID"],
HALLTIMEID = (Guid)dr["HALLTIMEID"],
SEATID = (Guid)dr["SEATID"],
USRID = (Guid)dr["USRID"],
DATETIME = (DateTime)dr["DATETIME"],
TICKETPRICE = dr["TICKETPRICE"].ToString() + " ₺",
STATUS = SSTATUS,
FID = (Guid)dr["FID"],
FILMNM = dr["FILMNM"].ToString(),
FILMIMG = dr["FILMIMG"].ToString(),
VISIONDATE = (DateTime)dr["VISIONDATE"],
TIME = dr["TIME"].ToString(),
EXPLANATION = dr["EXPLANATION"].ToString(),
HID = (Guid)dr["HID"],
HALLNM = dr["HALLNM"].ToString(),
HTID = (Guid)dr["HTID"],
HALLTIME = dr["HALLTIME"].ToString(),
SID = (Guid)dr["SID"],
SEATNM = dr["SEATNM"].ToString(),
UID = (Guid)dr["UID"],
USRNM = dr["USRNM"].ToString(),
FULNM = dr["FULNM"].ToString(),
AVATAR = dr["AVATAR"].ToString()
});
}
ViewBag.UserTransactions = userTransactions;
ViewBag.UserTransactionsD = userTransactionsD;
return(View());
}
