public async Task <IHttpActionResult> Post(AU_NGUOIDUNG instance)
{
var result = new TransferObj <AU_NGUOIDUNG>();
var unitCode = _service.GetCurrentUnitCode();
var parentUnitCode = _service.GetParentUnitCode();
var exist = _service.Repository.DbSet.FirstOrDefault(x => x.Username == instance.Username);
if (exist != null)
{
result.Status = false;
return(Ok(result));
}
else
{
try
{
instance.Password = MD5Encrypt.MD5Hash(instance.Password);
instance.MaNhanVien = _service.SaveCodeByParent(parentUnitCode);
instance.ParentUnitcode = parentUnitCode;
var item = _service.Insert(instance);
_service.UnitOfWork.Save();
result.Status = true;
result.Data = item;
}
catch (Exception e)
{
result.Status = false;
result.Message = e.Message;
return(Ok(result));
}
}
return(CreatedAtRoute("DefaultApi", new { controller = this, id = instance.Id }, result));
}
//[CustomAuthorize(Method = "SUA", State = "sys_User")]
public async Task <IHttpActionResult> Put(string id, AU_NGUOIDUNG instance)
{
var result = new TransferObj <AU_NGUOIDUNG>();
if (id != instance.Id)
{
result.Status = false;
result.Message = "Id không hợp lệ";
return(Ok(result));
}
try
{
var item = _service.Update(instance);
_service.UnitOfWork.Save();
result.Status = true;
result.Data = item;
return(Ok(result));
}
catch (Exception e)
{
result.Status = false;
result.Message = e.Message;
return(Ok(result));
}
}
public List <MTA.SERVICE.BuildQuery.IQueryFilter> GetFilters()
{
var result = new List <IQueryFilter>();
var refObj = new AU_NGUOIDUNG();
if (!string.IsNullOrEmpty(this.Username))
{
result.Add(new QueryFilterLinQ
{
Property = ClassHelper.GetProperty(() => refObj.Username),
Value = this.Username,
Method = FilterMethod.Like
});
}
if (!string.IsNullOrEmpty(this.TenNhanVien))
{
result.Add(new QueryFilterLinQ
{
Property = ClassHelper.GetProperty(() => refObj.TenNhanVien),
Value = this.TenNhanVien,
Method = FilterMethod.Like
});
}
return(result);
}
public NvNgayHetHanHangHoaVm.ReportModel CreateReport(string id)
{
string _ParentUnitCode = GetParentUnitCode();
NvNgayHetHanHangHoaVm.ReportModel result = new NvNgayHetHanHangHoaVm.ReportModel();
NvNgayHetHanHangHoa exsit = FindById(id);
if (exsit != null)
{
result = Mapper.Map <NvNgayHetHanHangHoa, NvNgayHetHanHangHoaVm.ReportModel>(exsit);
AU_NGUOIDUNG nhanvien = UnitOfWork.Repository <AU_NGUOIDUNG>().DbSet.Where(x => x.Username == exsit.ICreateBy).FirstOrDefault();
if (nhanvien != null)
{
result.NameNhanVienCreate = nhanvien.TenNhanVien != null ? nhanvien.TenNhanVien : "";
}
var detailData = UnitOfWork.Repository <NvNgayHetHanHangHoaChiTiet>().DbSet.Where(x => x.MaPhieuPk == exsit.MaPhieuPk).ToList();
result.DataReportDetails = Mapper.Map <List <NvNgayHetHanHangHoaChiTiet>, List <NvNgayHetHanHangHoaVm.ReportDetailModel> >(detailData);
List <NvNgayHetHanHangHoaVm.DtoDetail> listDetails = new List <NvNgayHetHanHangHoaVm.DtoDetail>();
}
string unitCode = GetCurrentUnitCode();
DateTime createDate = DateTime.Now;
result.CreateDay = createDate.Day;
result.CreateMonth = createDate.Month;
result.CreateYear = createDate.Year;
//GetNhanVien
if (HttpContext.Current != null && HttpContext.Current.User is ClaimsPrincipal)
{
ClaimsPrincipal currentUser = (HttpContext.Current.User as ClaimsPrincipal);
string name = currentUser.Identity.Name;
AU_NGUOIDUNG nhanVien = UnitOfWork.Repository <AU_NGUOIDUNG>().DbSet.Where(x => x.Username == name).FirstOrDefault();
}
return(result);
}
public async Task <IHttpActionResult> Register(AU_NGUOIDUNG userModel)
{
if (!ModelState.IsValid)
{
return(BadRequest(ModelState));
}
try
{
//_repo.InsertGraph(userModel);
}
catch (Exception) {
return(BadRequest());
}
return(Ok());
}
public async Task <IHttpActionResult> Delete(string id)
{
AU_NGUOIDUNG instance = await _service.Repository.FindAsync(id);
if (instance == null)
{
return(NotFound());
}
try
{
_service.Delete(instance.Id);
await _service.UnitOfWork.SaveAsync();
return(Ok(instance));
}
catch (Exception)
{
return(InternalServerError());
}
}
public override async Task GrantResourceOwnerCredentials(OAuthGrantResourceOwnerCredentialsContext context)
{
int level = 0;
try
{
var user = new AU_NGUOIDUNG();
using (var connection = new OracleConnection(ConfigurationManager.ConnectionStrings["Database.Connection"].ConnectionString))
{
await connection.OpenAsync();
using (var command = connection.CreateCommand())
{
command.CommandType = CommandType.Text;
command.CommandText =
"SELECT * FROM AU_NGUOIDUNG WHERE USERNAME='******' AND PASSWORD='******' AND TRANGTHAI = 10 ";
using (var oracleDataReader = command.ExecuteReaderAsync(CommandBehavior.CloseConnection))
{
if (!oracleDataReader.Result.HasRows)
{
user = null;
}
else
{
while (oracleDataReader.Result.Read())
{
user.Username = oracleDataReader.Result["USERNAME"]?.ToString();
user.TenNhanVien = oracleDataReader.Result["TENNHANVIEN"]?.ToString();
user.SoDienThoai = oracleDataReader.Result["SODIENTHOAI"]?.ToString();
user.ChungMinhThu = oracleDataReader.Result["SOCHUNGMINHTHU"]?.ToString();
user.UnitCode = oracleDataReader.Result["UNITCODE"]?.ToString();
user.ParentUnitcode = oracleDataReader.Result["PARENT_UNITCODE"]?.ToString();
int.TryParse(oracleDataReader.Result["LEVEL"]?.ToString(), out level);
user.Level = level;
}
}
}
}
}
if (user == null)
{
context.SetError("invalid_grant", "The user name or password is incorrect.");
return;
}
Action <ClaimsIdentity, string> addClaim = (ClaimsIdentity obj, string username) => { return; };
var identity = new ClaimsIdentity(context.Options.AuthenticationType);
identity.AddClaim(new Claim(ClaimTypes.Name, context.UserName));
addClaim.Invoke(identity, user.Username);
identity.AddClaim(new Claim(ClaimTypes.Role, "MEMBER"));
identity.AddClaim(new Claim("unitCode", user.UnitCode));
identity.AddClaim(new Claim("parentUnitCode", user.ParentUnitcode));
AuthenticationProperties properties = new AuthenticationProperties(new Dictionary <string, string>
{
{
"userName", string.IsNullOrEmpty(user.Username)?string.Empty:user.Username
},
{
"fullName", string.IsNullOrEmpty(user.TenNhanVien)?string.Empty:user.TenNhanVien
},
{
"code", string.IsNullOrEmpty(user.MaNhanVien)?string.Empty:user.MaNhanVien
},
{
"phone", string.IsNullOrEmpty(user.SoDienThoai)?string.Empty:user.SoDienThoai
},
{
"chungMinhThu", string.IsNullOrEmpty(user.ChungMinhThu)?string.Empty:user.ChungMinhThu
},
{
"unitCode", string.IsNullOrEmpty(user.UnitCode)?string.Empty:user.UnitCode
},
{
"parentUnitCode", string.IsNullOrEmpty(user.ParentUnitcode)?string.Empty:user.ParentUnitcode
},
{
"level", level.ToString()
}
});
AuthenticationTicket ticket = new AuthenticationTicket(identity, properties);
context.Validated(ticket);
context.Request.Context.Authentication.SignIn(identity);
}
catch (Exception e)
{
context.SetError("invalid_grant", e.Message);
return;
}
}
