public IHttpActionResult Post([FromBody] MasterOrganizationRole masterOrganizationRole)
{
var userCtx = base.GetUserContext();
_masterOrganizationRoleService.Save(masterOrganizationRole, userCtx);
return(Ok());
}
public void Save(MasterOrganizationRole masterOrganizationRole, UserContext userCtx)
{
if (masterOrganizationRole.Id == 0)
{
_masterOrganizationRoleRepository.SaveMasterOrganizationRole(masterOrganizationRole, userCtx);
}
else
{
_masterOrganizationRoleRepository.UpdateMasterOrganizationRole(masterOrganizationRole, userCtx);
}
}
public void InsertMasterOrganizationRole(MasterOrganizationRole masterOrganizationRole)
{
var sqlParam = new MySqlSpParam();
sqlParam.StoreProcedureName = AppConstants.StoreProcedure.spMasterOrganizationRole_Insert;
sqlParam.StoreProcedureParam = new MySqlParameter[] {
new MySqlParameter("@role", masterOrganizationRole.Role),
new MySqlParameter("@isValid", masterOrganizationRole.IsValid),
new MySqlParameter("@createdBy", masterOrganizationRole.CreatedBy),
new MySqlParameter("@createdOn", masterOrganizationRole.CreatedOn)
};
DataAccessHelper.ExecuteNonQuery(sqlParam.ToSqlCommand(),
sqlParam.StoreProcedureParam);
}
public void UpdateMasterOrganizationRole(MasterOrganizationRole masterOrganizationRole, UserContext userCtx)
{
masterOrganizationRole.UpdatedBy = userCtx.UserId;
masterOrganizationRole.UpdatedOn = DateTime.Now.ToMySqlDateString();
_masterOrganizationRoleDataAccess.UpdateMasterOrganizationRole(masterOrganizationRole);
}
