public async Task <IActionResult> LoginMember([FromForm] Users user)
{
try
{
if (user.RoleName == null)
{
return(Unauthorized());
}
user = await userService.Authenticate(
password : user.Password,
employeecode : user.EmployeeCode,
role : user.RoleName);
List <P> parameters = new List <P> {
new P {
Key = "RoldName", Value = user.RoleName
}
};
user.Menu = dbServices.SpCaller(name: "[dbo].[PB_GetMneuByRoldID]", parameters: parameters)?.Tables?[0];
return(Ok(user));
}
catch (Exception ex)
{
return(Unauthorized(ex.Message));
}
}
public async Task <IActionResult> UploadCommRate([FromForm] FileUpload model)
{
if (model.File.Length == 0)
{
return(BadRequest());
}
var dataSet = await SharedServices.ExcelToDataSet(model);
List <P> parameters = new List <P>
{
new P {
Key = "Data_PB_CommRatesImport", Value = SharedServices.StringAllColumns(dataSet.Tables[0])
},
new P {
Key = "AddBy", Value = Current.UserID
}
};
var ds = dbServices.SpCaller(name: "dbo.PB_CommRatesImport", parameters: parameters);
return(Ok(ds.Tables[0]));
}
