public int UpdateAccessLevel(AspNetAccessLevelsModel model)
{
SQLData db = new SQLData();
string sql = "UPDATE dbo.AspNetAccessLevels SET Name=@Name, Description=@Description, AccessLevel=@AccessLevel WHERE Id=@Id";
List <SqlParameter> parms = new List <SqlParameter>();
int _ret = 0;
try
{
parms.Add(new SqlParameter("@Id", model.Id));
parms.Add(new SqlParameter("@Name", model.Name));
parms.Add(new SqlParameter("@Description", model.Description));
parms.Add(new SqlParameter("@AccessLevel", model.AccessLevel));
db.Open(ConfigurationManager.ConnectionStrings["WWI"].ConnectionString);
_ret = db.ExecuteNonQuery(sql, parms);
}
catch (Exception ex)
{
Logger.LogError("UpdateAccessLevel Exception: ", ex);
}
finally
{
db.Close();
}
return(_ret);
}
public AspNetAccessLevelsModel AddAccessLevel(AspNetAccessLevelsModel model)
{
SQLData db = new SQLData();
string sql = "INSERT INTO dbo.AspNetAccessLevels (Id, Name, Description, AccessLevel) VALUES(@Id, @Name, @Description, @AccessLevel)";
List <SqlParameter> parms = new List <SqlParameter>();
try
{
if (string.IsNullOrEmpty(model.Description))
{
model.Description = "";
}
model.Id = Guid.NewGuid().ToString();
parms.Add(new SqlParameter("@Id", model.Id));
parms.Add(new SqlParameter("@Name", model.Name));
parms.Add(new SqlParameter("@Description", model.Description));
parms.Add(new SqlParameter("@AccessLevel", model.AccessLevel));
db.Open(ConfigurationManager.ConnectionStrings["WWI"].ConnectionString);
db.ExecuteNonQuery(sql, parms);
}
catch (Exception ex)
{
Logger.LogError("AddAccessLevel Exception: ", ex);
}
finally
{
db.Close();
}
return(model);
}
public ActionResult EditAccessLevel(AspNetAccessLevelsModel model)
{
WWIDal dal = new WWIDal();
dal.UpdateAccessLevel(model);
return(RedirectToAction("AccessLevels"));
}
public ActionResult AddAccessLevel(AspNetAccessLevelsModel model)
{
try
{
WWIDal dal = new WWIDal();
model = dal.AddAccessLevel(model);
}
catch (Exception ex)
{
Logger.LogError("AddAccessLevel Exception", ex);
}
return(RedirectToAction("AccessLevels"));
}
public AspNetAccessLevelsModel GetAccessLevel(string id)
{
SQLData db = new SQLData();
string sql = "SELECT * FROM dbo.AspNetAccessLevels WHERE Id=@Id";
List <SqlParameter> parms = new List <SqlParameter>();
AspNetAccessLevelsModel model = new AspNetAccessLevelsModel();
try
{
db.Open(ConfigurationManager.ConnectionStrings["WWI"].ConnectionString);
parms.Add(new SqlParameter("@Id", id.ToString()));
DataTable dt = db.Execute(sql, parms);
DataRow row = dt.Rows[0];
if (!row["Id"].ToString().Equals(string.Empty))
{
model.Id = row["Id"].ToString();
}
if (!row["Name"].ToString().Equals(string.Empty))
{
model.Name = row["Name"].ToString();
}
if (!row["Description"].ToString().Equals(string.Empty))
{
model.Description = row["Description"].ToString();
}
if (!row["AccessLevel"].ToString().Equals(string.Empty))
{
model.AccessLevel = (int)row["AccessLevel"];
}
}
catch (Exception ex)
{
Logger.LogError("GetAccessLevel exception: ", ex);
}
finally
{
db.Close();
}
return(model);
}
