public virtual System.Web.Mvc.ActionResult Edit(Models.Roles role)
{
Models.Roles originalItem =
MyDatabaseContext.Role.Find(role.Id);
if (originalItem == null)
{
return(HttpNotFound());
}
var foundedItem =
MyDatabaseContext.Role
.Where(current => current.Id != role.Id)
.Where(current => string.Compare(current.Name, role.Name, true) == 0)
.FirstOrDefault();
if (foundedItem != null)
{
ModelState.AddModelError
(key: "Name", errorMessage: "Name is exist! Please choose another one...");
}
if (ModelState.IsValid)
{
originalItem.Name = role.Name;
originalItem.IsActive = role.IsActive;
originalItem.IsAdmin = role.IsAdmin;
MyDatabaseContext.SaveChanges();
return(RedirectToAction(MVC.Admin.Roles.Index()));
}
return(View(model: role));
}
// GET: Roles
public ActionResult Index()
{
Models.Roles modelo = new Models.Roles();
modelo.ListaRoles = baseDatos.AspNetRoles.ToList();
modelo.ListaPermisos = baseDatos.permisos.ToList();
return(View(modelo));
}
public IActionResult Add(Models.Roles roles)
{
if (string.IsNullOrEmpty(roles.Name))
{
TempData["title"] = "Boş";
return(RedirectToAction("Index"));
}
else
{
using (SqlConnection sqlconnection = new SqlConnection(connection))
{
sqlconnection.Open();
var name = CultureInfo.CurrentCulture.TextInfo.ToTitleCase(roles.Name);
string query = "INSERT INTO Roles VALUES ('" + name + "')";
SqlCommand sqlCommand = new SqlCommand(query, sqlconnection);
sqlCommand.ExecuteNonQuery();
}
}
TempData["title"] = "Başarılı";
return(RedirectToAction("Index"));
}
private void Add(HttpContext context)
{
var roleModel = new Models.Roles();
roleModel.ID = Guid.NewGuid();
//roleModel.CreateId = Profile.CurrentUser.UserId;
//roleModel.CreateName = Profile.CurrentUser.UserName;
roleModel.CreateTime = System.DateTime.Now;
SetModelValue(roleModel, context);
var roleBll = new BLL.Roles();
var result = false;
var msg = "";
try
{
result = roleBll.Add(roleModel);
if (!result)
{
msg = "保存失败！";
}
}
catch (Exception ex)
{
LogHelper.WriteLogofExceptioin(ex);
result = false;
msg = ex.Message;
}
context.Response.Write(msg);
}
public override System.Web.Mvc.ActionResult Edit(Models.Roles role)
{
var callInfo = new T4MVC_System_Web_Mvc_ActionResult(Area, Name, ActionNames.Edit);
ModelUnbinderHelpers.AddRouteValues(callInfo.RouteValueDictionary, "role", role);
EditOverride(callInfo, role);
return(callInfo);
}
public virtual System.Web.Mvc.ViewResult Create()
{
Models.Roles defaultItem = new Models.Roles();
defaultItem.IsActive = true;
defaultItem.IsAdmin = false;
return(View(model: defaultItem));
}
public object Delete(Models.Roles deleted)
{
string msgError = "";
bool result = repository.Remove(deleted, ref msgError);
object json = new
{
success = result,
message = msgError
};
return(json);
}
public async Task UpdateRole(Models.Roles Role)
{
if (_db != null)
{
var existingRole = _db.Roles.Where(s => s.RoleId == Role.RoleId).FirstOrDefault <Roles>();
if (existingRole != null)
{
existingRole.Name = Role.Name;
existingRole.StatusId = Role.RoleId;
}
await _db.SaveChangesAsync();
}
}
// GET: Accounts
public ActionResult Index(int?page)
{
var role = new Models.Roles();
IList <Account> accounts;
accounts = _accountRepository.GetAll().Where(x => x.ID == ((Account)Session["Account"]).ID).ToList();
var list = accounts;
int pageSize = 10;
return(View(list.ToPagedList(page ?? 1, pageSize)));
}
public async Task <int> AddRole(Models.Roles Role)
{
if (_db != null)
{
await _db.Roles.AddAsync(new Roles()
{
Name = Role.Name,
StatusId = Role.StatusId
});
await _db.SaveChangesAsync();
return(Role.RoleId);
}
return(0);
}
public object Post(Models.Roles added)
{
object json;
string messageError = "";
try
{
Models.Roles posted = repository.Add(added, ref messageError);
if (posted != null)
{
json = new
{
total = 1,
data = posted,
success = true
};
}
else
{
json = new
{
message = messageError,
success = false
};
};
}
catch (Exception ex)
{
LogManager.Write("ERROR:" + Environment.NewLine + "\tMETHOD = " + this.GetType().FullName + "." + MethodBase.GetCurrentMethod().Name + Environment.NewLine + "\tMESSAGE = " + ex.Message);
object error = new { message = ex.Message };
json = new
{
message = ex.Message,
success = false
};
};
return(json);
}
public ActionResult CreateorEditRole(Models.Roles role)
{
string query = "insert into role (RoleName,CreatedTimestamp,CreatedBy) values (@RoleName,@CreatedTimestamp,@CreatedBy)";
using (SqlConnection sqlCon = new SqlConnection(constrs))
{
if (ModelState.IsValid)
{
if (role.RoleId == 0)
{
SqlCommand cmd = new SqlCommand(query, sqlCon);
sqlCon.Open();
cmd.Parameters.AddWithValue("@RoleName", role.RoleName);
cmd.Parameters.AddWithValue("@CreatedTimestamp", DateTime.Now);
cmd.Parameters.AddWithValue("@CreatedBy", Session["UserName"]);
cmd.ExecuteNonQuery();
sqlCon.Close();
return(RedirectToAction("roleIndexpage"));
}
else
{
query = "update role set RoleName=@RoleName,UpdatedBy=@UpdatedBy,modifiedTimestamp=@modifiedTimestamp where RoleId=@RoleId;";
SqlCommand cmd = new SqlCommand(query, sqlCon);
sqlCon.Open();
cmd.Parameters.AddWithValue("@RoleName", role.RoleName);
cmd.Parameters.AddWithValue("@modifiedTimestamp", DateTime.Now);
cmd.Parameters.AddWithValue("@UpdatedBy", Session["UserName"]);
cmd.Parameters.AddWithValue("@RoleId", role.RoleId);
cmd.ExecuteNonQuery();
sqlCon.Close();
return(RedirectToAction("roleIndexpage"));
}
}
return(View());
}
}
public ActionResult GoogleLoginCallback()
{
var claimsPrincipal = HttpContext.User.Identity as ClaimsIdentity;
var loginInfo = GoogleLoginViewModel.GetLoginInfo(claimsPrincipal);
if (loginInfo == null)
{
return(View("SignIn"));
}
SandeepDBEntities db = new SandeepDBEntities();
var user = db.UserAccount.FirstOrDefault(x => x.Email == loginInfo.emailaddress);
if (user == null)
{
user = new UserAccount
{
Email = loginInfo.emailaddress,
GivenName = loginInfo.givenname,
Identifier = loginInfo.nameidentifier,
Name = loginInfo.name,
SurName = loginInfo.surname,
IsActive = true
};
var roleInsert = new Models.Roles
{
Id = user.Id,
RoleName = "user"
};
db.UserAccount.Add(user);
db.Roles.Add(roleInsert);
db.SaveChanges();
}
Response.Cookies["Cookie"]["RoleName"] = db.Roles.FirstOrDefault(x => x.Id == user.Id).RoleName;
string str = Response.Cookies["Cookie"]["RoleName"];
return(Redirect("signin"));
}
Create([System.Web.Mvc.Bind(Exclude = "Id")] Models.Roles role)
{
var foundedItem =
MyDatabaseContext.Role
.Where(current => string.Compare(current.Name, role.Name, true) == 0)
.FirstOrDefault();
if (foundedItem != null)
{
ModelState.AddModelError
(key: "Name", errorMessage: "Name is exist! Please choose another one...");
}
if (ModelState.IsValid)
{
MyDatabaseContext.Role.Add(role);
MyDatabaseContext.SaveChanges();
return(RedirectToAction(MVC.Admin.Roles.Index()));
}
return(View(model: role));
}
partial void EditOverride(T4MVC_System_Web_Mvc_ActionResult callInfo, Models.Roles role);
public object GetAll()
{
var queryValues = Request.RequestUri.ParseQueryString();
int page = Convert.ToInt32(queryValues["page"]);
int start = Convert.ToInt32(queryValues["start"]);
int limit = Convert.ToInt32(queryValues["limit"]);
int id = Convert.ToInt32(queryValues["id"]);
int orden = Convert.ToInt32(queryValues["orden"]);
#region Configuramos el orden de la consulta si se obtuvo como parametro
string strOrder = !string.IsNullOrWhiteSpace(queryValues["sort"]) ? queryValues["sort"] : "";
strOrder = strOrder.Replace('[', ' ');
strOrder = strOrder.Replace(']', ' ');
Sort sort;
if (!string.IsNullOrWhiteSpace(strOrder))
{
sort = JsonConvert.DeserializeObject <Sort>(strOrder);
}
else
{
sort = new Sort();
}
#endregion
string query = !string.IsNullOrWhiteSpace(queryValues["query"]) ? queryValues["query"] : "";
int totalRecords = 0;
try
{
if (id == 0)
{
object json;
string msgError = "";
IList <Roles> lista;
lista = repository.GetList(query, sort, page, start, limit, ref totalRecords, ref msgError);
json = new
{
total = totalRecords,
data = lista,
success = true
};
return(json);
}
else
{
string msgError = "";
Models.Roles estatus = repository.Get(id, ref msgError);
object json = new
{
data = estatus,
success = true,
message = msgError
};
return(json);
}
}
catch (Exception ex)
{
LogManager.Write("ERROR:" + Environment.NewLine + "\tMETHOD = " + this.GetType().FullName + "." + MethodBase.GetCurrentMethod().Name + Environment.NewLine + "\tMESSAGE = " + ex.Message);
object error = new { message = ex.Message };
object json = new
{
message = ex.Message,
success = false
};
return(json);
}
}
public ActionResult AddRole(Models.Roles roles)
{
var status = roles.createRole(roles.NewRole_Name);
return(Json(status.ToString(), JsonRequestBehavior.AllowGet));
}
