public ActionResult Login(member_login model)
{
using (var context = new sql_mangeEntities())
{
bool isValid = context.employ_user.Any(x => x.name == model.name && x.Password == model.Password);
if (isValid)
{
FormsAuthentication.SetAuthCookie(model.name, false);
//var logerIn = new LoginHistroy
//{
// username = model.name,
// Action = Request.ServerVariables["REMOTE_ADDR"],
// LoginTime = DateTime.UtcNow
//};
//db.LoginHistroy.Add(logerIn);
//db.SaveChanges();
return(RedirectToAction("About", "Home"));
}
ModelState.AddModelError("", "Invalide user and password");
return(View());
}
}
public JsonResult CreatBackup(string dl)
{
string[] arr = dl.Split(',');
foreach (var Name in arr)
{
var currentID = Name;
var dataTime = DateTime.Now.ToString("h;mm;ss");
string dbPath = Server.MapPath("~/App_Data/" + currentID + "_" + dataTime + ".bak");
using (var db = new sql_mangeEntities())
{
try
{
var cmd = String.Format("BACKUP DATABASE {0} TO DISK='{1}' WITH FORMAT, MEDIANAME='DbBackups', MEDIADESCRIPTION='Media set for {0} database';"
, currentID, dbPath);
db.Database.ExecuteSqlCommand(TransactionalBehavior.DoNotEnsureTransaction, cmd);
}
catch (Exception m)
{
ViewBag.err = m.Message;
TempData["errorM"] = m.Message;
}
}
}
if (ViewBag.err == null)
{
TempData["sucessMes"] = "Crete successfully";
TempData["Action"] = "Backup";
}
if (ViewBag.err != null)
{
TempData["EAction"] = "Faild !";
}
return(Json("", JsonRequestBehavior.AllowGet));
}
