public override int UpdateUserCategory(UserCategoryProperty objUserCategoryProperty, int modifiedBy, out string errmsg)
{
_objDataWrapper = new DbWrapper(Common.CnnString, CommandType.StoredProcedure);
errmsg = "";
try
{
_objDataWrapper.AddParameter("@UserCategoryId", objUserCategoryProperty.UserCategoryId);
_objDataWrapper.AddParameter("@UserCategoryName", objUserCategoryProperty.UserCategoryName);
_objDataWrapper.AddParameter("@UserCategoryDashBoardUrl", objUserCategoryProperty.UserCategoryDashboard);
_objDataWrapper.AddParameter("@UserCategoryCanCreateUser", objUserCategoryProperty.CanCreateUser);
_objDataWrapper.AddParameter("@UserCategoryStatus", objUserCategoryProperty.UserCategoryStatus);
_objDataWrapper.AddParameter("@CreatedBy", modifiedBy);
var objerrMsg
= (SqlParameter)(_objDataWrapper.AddParameter("@ErrMsg", "", SqlDbType.VarChar, ParameterDirection.Output, 128));
_i = _objDataWrapper.ExecuteNonQuery("Aj_Proc_InsertUpdateUserCategoryDetails");
if (objerrMsg != null && objerrMsg.Value != null)
{
errmsg = Convert.ToString(objerrMsg.Value);
}
}
catch (Exception ex)
{
var err = ex.Message;
if (ex.InnerException != null)
{
err = err + " :: Inner Exception :- " + ex.ToString();
}
const string addInfo = "Error while executing UpdateUserCategory in UserManager.cs :: -> ";
var objPub = new ClsExceptionPublisher();
objPub.Publish(err, addInfo);
}
return(_i);
}
protected void BtnSaveClick(object sender, EventArgs e)
{
_objUserCategoryProperty = new UserCategoryProperty
{
UserCategoryDashboard = txtDashBoardUrl.Text.Trim(),
UserCategoryName = txtUserName.Text.Trim(),
UserCategoryStatus = chkStatus.Checked,
CanCreateUser = rbtCreateUser.SelectedValue == "0" ? true : false
};
switch (btnSave.Text)
{
case "Save":
InsertUserCategory();
break;
case "Update":
UpdateUsereCategory();
break;
}
BindUser();
}
// Private Method to Bind The user Category object List
private List <UserCategoryProperty> BindUserCategoryListObject(DataTable datatable)
{
var userCategoryListObject = new List <UserCategoryProperty>();
try
{
if (datatable.Rows.Count > 0)
{
for (var j = 0; j < datatable.Rows.Count; j++)
{
var objUserCategoryProperty = new UserCategoryProperty
{
CanCreateUser = Convert.ToBoolean(datatable.Rows[j]["AjUserCategoryCanCreateUser"]),
UserCategoryDashboard = Convert.ToString(datatable.Rows[j]["AjUserCategoryDashBoardUrl"]),
UserCategoryId = Convert.ToInt32(datatable.Rows[j]["AjUserCategoryId"]),
UserCategoryName = Convert.ToString(datatable.Rows[j]["AjUserCategoryName"]),
UserCategoryStatus = Convert.ToBoolean(datatable.Rows[j]["AjUserCategoryStatus"])
};
userCategoryListObject.Add(objUserCategoryProperty);
}
}
}
catch (Exception ex)
{
var err = ex.Message;
if (ex.InnerException != null)
{
err = err + " :: Inner Exception :- " + ex.ToString();
}
const string addInfo = "Error while executing BindUserCategoryListObject in UserManager.cs :: -> ";
var objPub = new ClsExceptionPublisher();
objPub.Publish(err, addInfo);
}
return(userCategoryListObject);
}
public abstract int UpdateUserCategory(UserCategoryProperty objUserCategoryProperty, int modifiedBy, out string errmsg);
public abstract int InsertUserCategory(UserCategoryProperty objUserCategoryProperty, int createdBy, out string errmsg);
