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