public async Task <HttpResponseMessage> GetByIdAsync(SysFunctionModel _params)
{
var Res = Request.CreateResponse();
var Result = new Res();
try
{
var data = await Task.Run(() => _sysFunctionService.GetById(_params));
if (data != null)
{
Result.Data = data;
Result.Status = true;
Result.Message = "Call API Success";
Result.StatusCode = HttpStatusCode.OK;
}
else
{
Result.Data = null;
Result.Status = false;
Result.Message = "Không tìm thấy dữ liệu";
Result.StatusCode = HttpStatusCode.InternalServerError;
}
Res.Content = new StringContent(JsonConvert.SerializeObject(Result));
return(Res);
}
catch (Exception ex)
{
throw new Exception(ex.Message);
}
}
public async Task <HttpResponseMessage> DeleteAsync(SysFunctionModel _param)
{
var Res = Request.CreateResponse();
var Result = new Res();
try
{
if (_param != null)
{
await Task.Run(() => _sysFunctionService.Delete(_param));
Result.Status = true;
Result.Message = "Xóa thành công";
Result.StatusCode = HttpStatusCode.OK;
}
else
{
Result.Status = false;
Result.Message = "Xóa thất bại";
Result.StatusCode = HttpStatusCode.BadRequest;
}
Res.Content = new StringContent(JsonConvert.SerializeObject(Result));
return(Res);
}
catch (Exception ex)
{
Result.Status = false;
Result.Message = "Có lỗi xảy ra trong quá trình xóa " + ex.Message;
Result.StatusCode = HttpStatusCode.BadRequest;
throw new Exception(ex.Message);
}
}
/// <summary>
/// DataTable To List<SysFunctionModel>
/// </summary>
/// <param name="dt"></param>
/// <returns></returns>
private List <SysFunctionModel> dataTableToList(DataTable dt)
{
List <SysFunctionModel> list = new List <SysFunctionModel>();
foreach (DataRow row in dt.Rows)
{
SysFunctionModel model = new SysFunctionModel();
if (row["Id"] != DBNull.Value && !string.IsNullOrEmpty(row["Id"].ToString()))
{
model.Id = Convert.ToInt32(row["Id"]);
}
if (row["MenuName"] != DBNull.Value && !string.IsNullOrEmpty(row["MenuName"].ToString()))
{
model.MenuName = row["MenuName"].ToString();
}
if (row["Url"] != DBNull.Value && !string.IsNullOrEmpty(row["Url"].ToString()))
{
model.Url = row["Url"].ToString();
}
if (row["IsStop"] != DBNull.Value && !string.IsNullOrEmpty(row["IsStop"].ToString()))
{
model.IsStop = Convert.ToInt32(row["IsStop"]);
}
if (row["SortNo"] != DBNull.Value && !string.IsNullOrEmpty(row["SortNo"].ToString()))
{
model.SortNo = Convert.ToInt32(row["SortNo"]);
}
list.Add(model);
}
return(list);
}
/*==GetAllById ==*/
public SysFunctionModel GetById(SysFunctionModel _params)
{
var data = _uow.SysFunctionRepo.SQLQuery <SysFunctionModel>("sp_SysFunction_GetById "
+ "@FunctionId",
new SqlParameter("FunctionId", SqlDbType.Int)
{
Value = _params.FunctionId
}).FirstOrDefault();
return(data);
}
public async Task <HttpResponseMessage> CreateAsync(SysFunctionModel _param)
{
var Res = Request.CreateResponse();
var Result = new Res();
try
{
if (_param != null)
{
if (_param.SysFunctionGroupId < 0 || _param.SysFunctionGroupId == null)
{
Result.Status = false;
Result.Message = "Nhóm chức năng không được trống" + _param.SysFunctionGroupId;
Result.StatusCode = HttpStatusCode.BadRequest;
}
else if (string.IsNullOrEmpty(_param.FunctionName))
{
Result.Status = false;
Result.Message = "Tên chức năng không được trống" + _param.FunctionName;
Result.StatusCode = HttpStatusCode.BadRequest;
}
else
{
await Task.Run(() => _sysFunctionService.Insert(_param));
Result.Status = true;
Result.Message = "Thêm mới thành công";
Result.StatusCode = HttpStatusCode.OK;
}
}
else
{
Result.Status = false;
Result.Message = "Thêm mới thất bại";
Result.StatusCode = HttpStatusCode.BadRequest;
}
Res.Content = new StringContent(JsonConvert.SerializeObject(Result));
return(Res);
}
catch (Exception ex)
{
Result.Status = false;
Result.Message = "Có lỗi xảy ra trong quá trình thêm mới " + ex.Message;
Result.StatusCode = HttpStatusCode.BadRequest;
throw new Exception(ex.Message);
}
}
/*===Delete===*/
public void Delete(SysFunctionModel _params)
{
try
{
_uow.SysFunctionRepo.ExcQuery("exec sp_SysFunction_Delete " +
"@FunctionId",
new SqlParameter("FunctionId", SqlDbType.Int)
{
Value = _params.FunctionId
}
);
}
catch (Exception ex)
{
throw new Exception("Có lỗi xãy ra trong quá trình xóa " + ex.Message);
}
}
/*===Insert===*/
public void Insert(SysFunctionModel _params)
{
try
{
_uow.SysFunctionRepo.ExcQuery("exec sp_SysFunction_Insert " +
"@TreePanelId," +
"@SysFunctionGroupId," +
"@FunctionCode," +
"@FunctionName," +
"@ButtonId," +
"@Display_Order," +
"@Is_Active," +
"@CreateDate," +
"@CreateBy," +
"@UpdateDate," +
"@UpdateBy",
new SqlParameter("TreePanelId", SqlDbType.Int)
{
Value = _params.TreePanelId ?? 1
},
new SqlParameter("SysFunctionGroupId", SqlDbType.Int)
{
Value = _params.SysFunctionGroupId
},
new SqlParameter("FunctionCode", SqlDbType.VarChar, (50))
{
Value = _params.FunctionCode ?? DBNull.Value.ToString()
},
new SqlParameter("FunctionName", SqlDbType.NVarChar, (50))
{
Value = _params.FunctionName
},
new SqlParameter("ButtonId", SqlDbType.VarChar, (50))
{
Value = _params.ButtonId ?? DBNull.Value.ToString()
},
new SqlParameter("Display_Order", SqlDbType.Int)
{
Value = _params.Display_Order ?? 1
},
new SqlParameter("Is_Active", SqlDbType.Bit)
{
Value = _params.Is_Active == null ? true : _params.Is_Active
},
new SqlParameter("CreateDate", SqlDbType.Date)
{
Value = _params.CreateDate == null ? DateTime.Now : _params.CreateDate
},
new SqlParameter("CreateBy", SqlDbType.Int)
{
Value = _params.CreateBy == null ? 1 : _params.CreateBy
},
new SqlParameter("UpdateDate", SqlDbType.Date)
{
Value = _params.UpdateDate == null ? DateTime.Now : _params.UpdateDate
},
new SqlParameter("UpdateBy", SqlDbType.Int)
{
Value = _params.UpdateBy == null ? 1 : _params.UpdateBy
}
);
}
catch (Exception ex)
{
throw new Exception("Có lỗi xãy ra trong quá trình thêm mới " + ex.Message);
}
}
