public uc_GroupUserDetail(uc_GroupUser _parent, SYS_tblGroupUserDTO item)
{
InitializeComponent();
Initialize();
parentForm = _parent;
LoadDataToEdit(item);
SetPermission();
}
private void btnUpdate_ItemClick(object sender, DevExpress.XtraBars.ItemClickEventArgs e)
{
if (curRow != null)
{
SYS_tblGroupUserDTO item = busGroupUser.GetDataByID(curRow["GroupID"] + "", User.UserInfo.Username, User.UserInfo.LanguageID);
if (item != null)
{
Commons.OpenInputForm(new uc_GroupUserDetail(this, item), "Cập Nhật Nhóm Người Dùng", "Update Group User", new Size(450, 290));
}
}
}
public uc_GroupUserDetail(uc_GroupUser _parent_form, SYS_tblGroupUserDTO item = null)
{
CommonEngine.ShowWaitForm(this);
InitializeComponent();
Initialize();
parent_form = _parent_form;
if (item != null)
{
LoadDataToEdit(item);
}
CommonEngine.LoadUserPermission("9", txtGroupID, btnSaveClose, btnSaveInsert);
}
private void LoadDataToEdit(SYS_tblGroupUserDTO item)
{
txtGroupID.EditValue = (item == null) ? null : item.GroupID;
txtGroupCode.EditValue = (item == null) ? null : item.GroupCode;
txtGroupName.EditValue = (item == null) ? null : item.GroupName;
mmoNote.EditValue = (item == null) ? null : item.Note;
chkIsDefault.EditValue = (item == null) ? false : item.IsDefault;
chkActive.EditValue = (item == null) ? true : item.Active;
if (item == null)
{
depError.ClearErrors();
this.ParentForm.Text = (User.UserInfo.LanguageID.Equals("VN")) ? "Thêm Mới Nhóm Người Dùng" : "Insert New Group User";
}
txtGroupCode.Focus();
}
private void LoadDataToEdit(SYS_tblGroupUserDTO item)
{
txtGroupID.EditValue = (item == null) ? null : item.GroupID;
txtGroupCode.EditValue = (item == null) ? null : item.GroupCode;
//txtGroupCode.Properties.ReadOnly = (item == null) ? false : true;
txtVNName.EditValue = (item == null) ? null : item.VNName;
txtENName.EditValue = (item == null) ? null : item.ENName;
mmoNote.EditValue = (item == null) ? null : item.Note;
chkIsDefault.Checked = (item == null) ? false : item.IsDefault;
chkActive.Checked = (item == null) ? true : item.Active;
if (item == null)
{
depError.ClearErrors();
this.ParentForm.Text = LanguageEngine.GetOpenFormText(this.Name, ConfigEngine.Language, false);
txtGroupCode.Focus();
}
}
public SYS_tblGroupUserDTO GetDataByID(string group_id, string username, string language_id)
{
DataRow dr = db.GetDataRow("SYS_spfrmGroupUser", new string[] { "Activity", "Username", "LanguageID", "GroupID" }, new object[] { "GetDataByID", username, language_id, group_id });
SYS_tblGroupUserDTO result = new SYS_tblGroupUserDTO();
if (dr != null)
{
result.GroupID = dr["GroupID"] + "";
result.GroupCode = dr["GroupCode"] + "";
result.GroupName = dr["GroupName"] + "";
result.Note = dr["Note"] + "";
result.IsDefault = Convert.ToBoolean(dr["IsDefault"]);
result.Active = Convert.ToBoolean(dr["Active"]);
result.IsRoot = Convert.ToBoolean(dr["IsRoot"]);
return(result);
}
return(null);
}
public string InsertGroupUser(SYS_tblGroupUserDTO item)
{
string strError = "";
strError = db.sExecuteSQL("SYS_spfrmGroupUser", new string[] { "Activity", "Username", "LanguageID", "GroupCode", "GroupName", "Note", "Active", "IsDefault", "IsRoot" }, new object[] { item.Activity, item.Username, item.LanguageID, item.GroupCode, item.GroupName, item.Note, item.Active, item.IsDefault, item.IsRoot });
if (strError.Equals(""))
{
SYS_tblActionLogDTO log = new SYS_tblActionLogDTO();
log.Activity = item.Activity;
log.Username = item.Username;
log.LanguageID = item.LanguageID;
log.ActionVN = "Thêm Mới";
log.ActionEN = "Insert";
log.FunctionID = "9";
log.DescriptionVN = string.Format("Tài khoản '{0}' vừa thêm mới thành công nhóm người dùng có mã '{1}'.", item.Username, item.GroupCode);
log.DescriptionEN = string.Format("Account '{0}' has inserted new group user successfully with group code is '{1}'.", item.Username, item.GroupCode);
strError = this.InsertActionLog(log);
}
return(strError);
}
public async static Task <SYS_tblGroupUserDRO> InsertUpdateGroupUser(SYS_tblGroupUserDTO item, SYS_tblActionLogDTO actionLog)
{
SYS_tblGroupUserDRO result = new SYS_tblGroupUserDRO();
try
{
string url = string.Format(@"{0}/InsertUpdateGroupUser", GetBaseUrl());
var postData = new SYS_tblGroupUserDCO
{
GroupID = string.IsNullOrEmpty(item.GroupID) ? "0" : item.GroupID,
GroupCode = item.GroupCode,
VNName = item.VNName,
ENName = item.ENName,
Note = item.Note,
IsDefault = item.IsDefault,
Active = item.Active,
Activity = item.Activity,
UserID = item.UserID,
LanguageID = item.LanguageID
};
var json_data = "{\"groupUser\":" + JsonConvert.SerializeObject(postData, new JsonSerializerSettings
{
DateFormatHandling = DateFormatHandling.MicrosoftDateFormat
}) + "}";
result = await SYS_tblGroupUserDAO.InsertUpdateGroupUser(url, json_data);
if (string.IsNullOrEmpty(result.ResponseItem.Message))
{
result.ResponseItem = await SYS_tblActionLogBUS.InsertUpdateLog(actionLog);
}
}
catch (Exception ex)
{
logger.Error(ex);
result.ResponseItem.Message = ex.Message;
}
return(result);
}
public SYS_tblGroupUserDTO GetDataByID(string group_user_id, string username, string language_id)
{
SYS_tblGroupUserDTO result = new SYS_tblGroupUserDTO();
try
{
DataRow dr = db.GetDataRow("SYS_spfrmGroupUser", new string[] { "Activity", "Username", "LanguageID", "GroupID" }, new object[] { BaseConstant.COMMAND_GET_DATA_BY_ID_EN, username, language_id, group_user_id });
if (dr != null)
{
result = new SYS_tblGroupUserDTO
{
GroupID = Convert.ToInt32(dr["GroupID"]),
GroupCode = dr["GroupCode"] + "",
VNName = dr["VNName"] + "",
ENName = dr["ENName"] + "",
Note = dr["Note"] + "",
Active = Convert.ToBoolean(dr["Active"]),
IsDefault = Convert.ToBoolean(dr["IsDefault"]),
IsRoot = Convert.ToBoolean(dr["IsRoot"]),
Activity = BaseConstant.COMMAND_GET_DATA_BY_ID_EN,
UserID = username,
LanguageID = language_id,
Visible = Convert.ToBoolean(dr["Visible"]),
Creater = dr["Creater"] + "",
CreateTime = Convert.ToDateTime(dr["CreateTime"]),
Editer = dr["Editer"] + "",
EditTime = (dr["EditTime"] == DBNull.Value) ? (DateTime?)null : (DateTime)dr["EditTime"]
};
return(result);
}
}
catch (Exception ex)
{
logger.Error(ex);
}
return(result);
}
private bool SaveGroupUser(bool isEdit)
{
string strError = "";
try
{
SYS_tblGroupUserDTO item = new SYS_tblGroupUserDTO
{
GroupID = txtGroupID.Text,
GroupCode = txtGroupCode.Text,
GroupName = txtGroupName.Text,
Note = mmoNote.Text,
IsDefault = chkIsDefault.Checked,
Active = chkActive.Checked,
Activity = (isEdit) ? "Update" : "Insert",
Username = User.UserInfo.Username,
LanguageID = User.UserInfo.LanguageID
};
strError = (isEdit) ? busGroupUser.UpdateGroupUser(item) : busGroupUser.InsertGroupUser(item);
if (strError != "")
{
Commons.ShowMessage(strError, 0);
txtGroupCode.Focus();
return(false);
}
else
{
parentForm.LoadAllData();
}
}
catch (Exception ex)
{
Commons.ShowExceptionMessage(ex);
txtGroupCode.Focus();
return(false);
}
return(true);
}
public string UpdateGroupUser(SYS_tblGroupUserDTO item)
{
string result = "";
try
{
result = db.sExecuteSQL("SYS_spfrmGroupUser", new string[] { "Activity", "Username", "LanguageID", "GroupID", "GroupCode", "VNName", "ENName", "Note", "Active", "IsDefault", "IsRoot" }, new object[] { BaseConstant.COMMAND_UPDATE_EN, item.UserID, item.LanguageID, item.GroupID, item.GroupCode, item.VNName, item.ENName, item.Note, item.Active, item.IsDefault, item.IsRoot });
if (!string.IsNullOrEmpty(result))
{
logger.Error(result);
}
return(result);
}
catch (Exception ex)
{
result = ex.Message;
logger.Error(ex);
}
return(result);
}
public string UpdateGroupUser(SYS_tblGroupUserDTO item)
{
return(daoGroupUser.UpdateGroupUser(item));
}
public string InsertGroupUser(SYS_tblGroupUserDTO item)
{
return(daoGroupUser.InsertGroupUser(item));
}
