public void savePermission()
{
// CALL `p_save_permision_user`(@p0, @p1);
try
{
using (MySqlConnection conn = new MySqlConnection(App.setting.connectString))
{
conn.Open();
string query = "CALL `p_save_permision_user` (@_user_id , @_permision);";
using (MySqlCommand cmd = new MySqlCommand(query, conn))
{
cmd.Parameters.AddWithValue("@_user_id", this.ID);
cmd.Parameters.AddWithValue("@_permision", Permision.Write(this.Permision));
cmd.ExecuteNonQuery();
};
conn.Close();
};
}
catch (MySqlException)
{
}
catch (Exception)
{
}
}
public void Save(Permision item)
{
try
{
var old = db.Permisions.Where(x => x.ID == item.ID).FirstOrDefault();
if (item.ID == 0)
{
item.IsDelete = false;
db.Permisions.Add(item);
db.SaveChanges();
}
else
{
if (old != null)
{
old.Name = item.Name;
db.SaveChanges();
}
}
}
catch (Exception)
{
throw;
}
}
private void LoadGUI(Permision p)
{
this.UIConfirmMedia.IsChecked = p.confirm_media;
this.UIManaUser.IsChecked = p.mana_user;
this.UISchedule.IsChecked = p.mana_schedule;
this.UIViewAllMedia.IsChecked = p.view_all_media;
this.UIDEvice.IsChecked = p.mana_device;
}
public async Task <IActionResult> Edit(int id, [Bind("PermisionId,PermisionName,PermisionAction")] Permision permisions)
{
/*Check Session */
var page = "29";
var typeofuser = "";
var PermisionAction = "";
// CheckSession
if (string.IsNullOrEmpty(HttpContext.Session.GetString("Username")))
{
Alert("คุณไม่มีสิทธิ์ใช้งานหน้าดังกล่าว", NotificationType.error);
return(RedirectToAction("Index", "Home"));
}
else
{
typeofuser = HttpContext.Session.GetString("TypeOfUserId");
PermisionAction = HttpContext.Session.GetString("PermisionAction");
if (PermisionHelper.CheckPermision(typeofuser, PermisionAction, page) == false)
{
Alert("คุณไม่มีสิทธิ์ใช้งานหน้าดังกล่าว", NotificationType.error);
return(RedirectToAction("Index", "Home"));
}
}
/*Check Session */
if (id != permisions.PermisionId)
{
return(NotFound());
}
if (ModelState.IsValid)
{
try
{
_context.Update(permisions);
await _context.SaveChangesAsync();
}
catch (DbUpdateConcurrencyException)
{
if (!PermisionExists(permisions.PermisionId))
{
return(NotFound());
}
else
{
throw;
}
}
return(RedirectToAction(nameof(Index)));
}
return(View(permisions));
}
public static UserData toUser(this MySqlDataReader reader)
{
UserData u = null;
while (reader.Read())
{
if (!reader.IsDBNull(0))
{
u = new UserData();
u.ID = reader.GetInt32(Define.user_id);
u.Full_Name = reader.GetString(Define.user_full_name);
u.Permision = Permision.Read(reader.GetString(Define.user_permision));
u.Status = reader.GetBoolean(Define.user_status);
u.Type = reader.GetInt32(Define.user_type);
u.Time = reader.GetDateTime(Define.user_time);
u.User_Name = reader.GetString(Define.user_name);
u.setDirectpass(reader.GetString(Define.user_pass));
try
{
u.Comment = reader.GetString(Define.user_content);
}
catch (Exception)
{
}
try
{
u.Phone = reader.GetString(Define.user_phone);
}
catch (Exception)
{
}
try
{
u.Email = reader.GetString(Define.user_email);
}
catch (Exception)
{
}
try
{
u.Finger_Print = new byte[10 * 1024 * 1024];
long bytesRead = reader.GetBytes(reader.GetOrdinal(Define.user_finger_print), 0, u.Finger_Print, 0, u.Finger_Print.Length);
Console.WriteLine(bytesRead + " bytes downloaded from table to file.");
}
catch (Exception)
{
}
}
}
return(u);
}
public ActionResult EditPermiso(Permision permiso)
{
if (ModelState.IsValid)
{
db.Entry(permiso).State = EntityState.Modified;
db.SaveChanges();
string url = Url.Action("Index", "Permiso");
return(Json(new { success = true, mensaje = "Permiso registrado exitosamente" }));
}
else
{
return(PartialView("AddPermiso", permiso));
}
}
protected async Task OpenCreate(T template = null)
{
if (!Permision.HasFlag(EntityManagementPermision.CanCreateNew))
{
ErrorSubject = "Permission Error";
ErrorMessage = "You can not create new entity.";
return;
}
EdittingModel = template == null ? new T() : template;
SetSomeParameterToModel(EdittingModel);
EdittingModel.PrepareModelForAddNew(DB.Context, Config);
Mode = EditMode.CreateNew;
ResetEdittingModel();
await OpenEditDialog();
}
public static List <UserData> toUsers(this MySqlDataReader reader)
{
if (reader.HasRows)
{
List <UserData> results = new List <UserData>();
while (reader.Read())
{
if (!reader.IsDBNull(0))
{
UserData u = new UserData();
u.ID = reader.GetInt32(Define.user_id);
u.Full_Name = reader.GetString(Define.user_full_name);
u.Permision = Permision.Read(reader.GetString(Define.user_permision));
u.Status = reader.GetBoolean(Define.user_status);
u.Type = reader.GetInt32(Define.user_type);
u.Time = reader.GetDateTime(Define.user_time);
u.setDirectpass(reader.GetString(Define.user_pass));
try
{
u.Comment = reader.GetString(Define.user_content);
}
catch (Exception)
{
}
try
{
u.Phone = reader.GetString(Define.user_phone);
}
catch (Exception)
{
}
try
{
u.Email = reader.GetString(Define.user_email);
}
catch (Exception)
{
}
u.User_Name = reader.GetString(Define.user_name);
results.Add(u);
}
}
return(results);
}
return(null);
}
public ActionResult AddPermiso(Permision permiso)
{
if (ModelState.IsValid)
{
var permisoparent = db.Permisions.Find(permiso.ParentID);
//var myPermision = db.Permisions.Create();
//myPermision.PermisionTypeID = permiso.PermisionTypeID;
//myPermision.Description = permiso.Description;
//myPermision.Name = myPermision.Name;
permiso.Parent = permisoparent;
db.Permisions.Add(permiso);
db.SaveChanges();
string url = Url.Action("Index", "Permiso");
return(Json(new { success = true, mensaje = "Permiso registrado exitosamente" }));
}
else
{
return(PartialView(permiso));
}
}
public static UserTypeData toTypeUser(this MySqlDataReader reader)
{
if (reader.HasRows)
{
UserTypeData type = new UserTypeData();
while (reader.Read())
{
if (!reader.IsDBNull(0))
{
type.Id = reader.GetInt32(Define.type_id);
type.Name = reader.GetString(Define.type_name);
type.Status = reader.GetBoolean(Define.type_status);
type.DefaultPermision = Permision.Read(reader.GetString(Define.default_permision));
type.Icon = reader.GetString(Define.type_icon);
}
}
return(type);
}
return(null);
}
protected async Task RemoveAsync(T model)
{
if (!Permision.HasFlag(EntityManagementPermision.CanRemove))
{
ErrorSubject = "Permission Error";
ErrorMessage = "You can not remove entity.";
return;
}
if (model == null)
{
return;
}
if (!await JS.InvokeAsync <bool>("confirmDialog", new[] { "Are you sure?" }))
{
return;
}
var m = model.GetEntityForEditOrRemove(DB.Context, Config);
if (m == null)
{
ErrorSubject = "Error";
ErrorMessage = "Not found the entity";
return;
}
try
{
m.Remove(DB.Context, Config);
}
catch (Exception e)
{
ErrorSubject = e.Message;
ErrorMessage = e.StackTrace;
}
DB.Context.SaveChanges();
await OnAfterRemoveAsync();
await InvokeAsync(() => StateHasChanged());
await InvokeAsync(() => Notifier.Update());
}
protected async Task OpenEdit(T beforeModel)
{
if (!Permision.HasFlag(EntityManagementPermision.CanEdit))
{
ErrorSubject = "Permission Error";
ErrorMessage = "You can not edit entity.";
return;
}
BeforeModel = beforeModel;
EdittingModel = beforeModel.GetEntityForEditOrRemove(DB.Context, Config);
if (EdittingModel == null)
{
ErrorSubject = "Error";
ErrorMessage = "Not found the entity";
return;
}
SetSomeParameterToModel(EdittingModel);
EdittingModel.PrepareModelForEdit(DB.Context, Config, beforeModel);
Mode = EditMode.Edit;
ResetEdittingModel(EdittingModel);
await OpenEditDialog();
}
public async Task <IActionResult> Create([Bind("PermisionId,PermisionName,PermisionAction")] Permision permisions)
{
/*Check Session */
var page = "28";
var typeofuser = "";
var PermisionAction = "";
// CheckSession
if (string.IsNullOrEmpty(HttpContext.Session.GetString("Username")))
{
Alert("คุณไม่มีสิทธิ์ใช้งานหน้าดังกล่าว", NotificationType.error);
return(RedirectToAction("Index", "Home"));
}
else
{
typeofuser = HttpContext.Session.GetString("TypeOfUserId");
PermisionAction = HttpContext.Session.GetString("PermisionAction");
if (PermisionHelper.CheckPermision(typeofuser, PermisionAction, page) == false)
{
Alert("คุณไม่มีสิทธิ์ใช้งานหน้าดังกล่าว", NotificationType.error);
return(RedirectToAction("Index", "Home"));
}
}
/*Check Session */
if (ModelState.IsValid)
{
_context.Add(permisions);
await _context.SaveChangesAsync();
return(RedirectToAction(nameof(Index)));
}
return(View(permisions));
}
private void btnSubmit_Click(object sender, EventArgs e)
{
//tea01Entities2 db = new tea01Entities2();
/*
* for (int i = 0; i < checkedListBox1.Items.Count; i++)
* {
* if (checkedListBox1.GetItemCheckState(i) == CheckState.Checked)
* {
* MessageBox.Show(checkedListBox1.Items[i].ToString());
*
* // var permision = db.Permisions.Where(u=>u.PermisionName == checkedListBox1.Items[i].ToString()).Select(u=>u).First();
* using (var context = new tea01Entities2())
* {
* Staff userCurrent = context.Staffs.Find(gridView.CurrentRow.Cells[1].Value.ToString());
* userCurrent.Permisions.Add(new Permision()
* {
* PermisionID = (++count).ToString(),
* PermisionName = checkedListBox1.Items[i].ToString()
* });
*
* context.SaveChanges();
*
* }
* }
* }
*/
tea01Entities2 db = new tea01Entities2();
Staff userCurrent = db.Staffs.Find(gridView.CurrentRow.Cells[1].Value.ToString());
for (int i = 0; i < userCurrent.Permisions.Count; i++)
{
var rm = db.Permisions.Find(userCurrent.Permisions.ToList()[i].PermisionID);
userCurrent.Permisions.Remove(userCurrent.Permisions.ToList()[i]);
// db.Permisions.Remove(rm);
}
string permisionName = "";
if (checkFull.Checked)
{
permisionName = "Full";
}
else if (checkCreate.Checked)
{
permisionName = "Create";
}
else if (checkEdit.Checked)
{
permisionName = "Edit";
}
else if (checkView.Checked)
{
permisionName = "View";
}
else if (checkAdmin.Checked)
{
permisionName = "Admin";
}
else
{
permisionName = "Custom";
}
Permision permision = new Permision()
{
PermisionID = (++count).ToString(),
PermisionName = permisionName
};
userCurrent.Permisions.Add(permision);
db.SaveChanges();
if (checkXem.Checked)
{
int count = db.PermisionDetails.ToList().Count;
permision.PermisionDetails.Add(new PermisionDetail()
{
PermisionDetailId = (++count).ToString(),
ActionName = "V"
});
}
db.SaveChanges();
if (checkXoa.Checked)
{
int count = db.PermisionDetails.ToList().Count;
permision.PermisionDetails.Add(new PermisionDetail()
{
PermisionDetailId = (++count).ToString(),
ActionName = "D"
});
}
db.SaveChanges();
if (checkSua.Checked)
{
int count = db.PermisionDetails.ToList().Count;
permision.PermisionDetails.Add(new PermisionDetail()
{
PermisionDetailId = (++count).ToString(),
ActionName = "E"
});
}
db.SaveChanges();
if (checkThem.Checked)
{
int count = db.PermisionDetails.ToList().Count;
permision.PermisionDetails.Add(new PermisionDetail()
{
PermisionDetailId = (++count).ToString(),
ActionName = "C"
});
}
db.SaveChanges();
/*
* var listPer = userCurrent.Permisions.ToList();
*
* foreach (var i in listPer)
* {
* i.PermisionDetails.remove();
* }
*/
db.SaveChanges();
MessageBox.Show("Đã cập nhật quyền cho nhân viên này");
}
protected override async void OnAppearing()
{
base.OnAppearing();
listView.ScrollTo(listView.SelectedItem, ScrollToPosition.Center, true);
await Permision.CheckPermission();
}
protected override async void OnAppearing()
{
base.OnAppearing();
await Permision.CheckPermission();
}
