void BindData()
{
string sql = "SELECT * FROM tbl_status_working";
MySqlDataAdapter da = dbScript.getDataSelect(sql);
DataSet ds = new DataSet();
da.Fill(ds);
StatusGridView.DataSource = ds.Tables[0];
StatusGridView.DataBind();
lbStatusNull.Text = "พบข้อมูลจำนวน " + ds.Tables[0].Rows.Count + " แถว";
}
protected void SaveChanges_Click(object sender, EventArgs e)
{
try
{
int Group_Id = int.Parse(ddlGroups.SelectedValue.ToString());
// Save Group Permission
var Permision_Ids = PermissionGroupGridView.GetSelectedFieldValues("Permission_Id");
db.Database.ExecuteSqlCommand("Delete Permission_Group where Group_Id = " + Group_Id);
for (int i = 0; i < Permision_Ids.Count; i++)
{
Permission_Group per_group = db.Permission_Group.Create();
per_group.Group_Id = Group_Id;
per_group.Permission_Id = int.Parse(Permision_Ids[i].ToString());
db.Permission_Group.Add(per_group);
}
db.SaveChanges();
//Save Status
var Status_Ids = StatusGridView.GetSelectedFieldValues("Status_Id");
db.Database.ExecuteSqlCommand("Delete Group_Status where Group_Id = " + Group_Id);
for (int i = 0; i < Status_Ids.Count; i++)
{
Group_Status per_groupStatus = db.Group_Status.Create();
per_groupStatus.Group_Id = Group_Id;
per_groupStatus.Status_Id = int.Parse(Status_Ids[i].ToString());
db.Group_Status.Add(per_groupStatus);
db.SaveChanges();
}
/* Add it to log file */
LogData = "data:" + JsonConvert.SerializeObject(Group_Id, logFileModule.settings);
logFileModule.logfile(10, "تعديل صلاحيات المجموعة", "update group permissions", LogData);
}
catch (Exception er) { }
}
