public IHttpActionResult PosttblUserManagement(tblUserManagement tblUserManagement)
{
if (!ModelState.IsValid)
{
return(BadRequest(ModelState));
}
bool traceID = db.tblEmployeesInfoes.Any(k => k.EmpId == tblUserManagement.UsersId);
var preuser = db.tblEmployeesInfoes.ToList();
var exist = db.tblUserManagements.Where(u => u.UsersId == tblUserManagement.UsersId);
if (preuser.Count() <= 0 || !traceID)
{
return(Json("no user"));
}
if (exist.Count() > 0)
{
return(Json("exist"));
}
else
{
tblUserManagement.CreatedBy = "CRTBY";
tblUserManagement.DateCreated = DateTime.Now;
tblUserManagement.Status = 0;
var data = db.tblEmployeesInfoes.Where(e => e.EmpId == tblUserManagement.UsersId).FirstOrDefault();
data.Status = 1;
var aRole = db.tblUserManagements.Add(tblUserManagement);
db.SaveChanges();
return(Json("good"));
}
//return CreatedAtRoute("DefaultApi", new { id = tblUserManagement.recNo }, tblUserManagement);
}
public IHttpActionResult PuttblUserManagement(int id, tblUserManagement tblUserManagement)
{
if (!ModelState.IsValid)
{
return(BadRequest(ModelState));
}
if (id != tblUserManagement.recNo)
{
return(BadRequest());
}
db.Entry(tblUserManagement).State = EntityState.Modified;
try
{
db.SaveChanges();
}
catch (DbUpdateConcurrencyException)
{
if (!tblUserManagementExists(id))
{
return(NotFound());
}
else
{
throw;
}
}
return(StatusCode(HttpStatusCode.NoContent));
}
public IHttpActionResult PostAddCompany(Company comp)
{
//checking sa username
var userExist = db.tblUserManagements.Where(u => u.UserName == comp.Username);
if (userExist.Count() > 0)
{
return(BadRequest());
}
else
{
tblUserManagement user = new tblUserManagement();
user.UserName = comp.Username;
user.Password = comp.Password;
user.RoleId = "2";
user.UsersId = Guid.NewGuid().ToString("N").Substring(0, 5).ToUpper();
user.DateCreated = DateTime.Now;
user.Status = 1;
db.Entry(user).State = EntityState.Added;
tblBranchShop branch = new tblBranchShop();
branch.BranchName = comp.BranchName;
branch.EmailAddress = comp.EmailAddress;
branch.Address = comp.Address;
branch.userID = user.UsersId;
branch.BranchId = Guid.NewGuid().ToString("N").Substring(0, 5).ToUpper();
db.Entry(branch).State = EntityState.Added;
db.SaveChanges();
return(Ok());
}
}
public IHttpActionResult PutuRolechangeName(tblUserManagement tblUserManagement)
{
tblUserManagement.UpdatedBy = "UPDBY";
tblUserManagement.DateUpdated = DateTime.Now;
db.Entry(tblUserManagement).State = EntityState.Modified;
db.SaveChanges();
return(Json("success"));
}
public IHttpActionResult GettblUserManagement(int id)
{
tblUserManagement tblUserManagement = db.tblUserManagements.Find(id);
if (tblUserManagement == null)
{
return(NotFound());
}
return(Ok(tblUserManagement));
}
public IHttpActionResult DeletetblUserManagement(int id)
{
tblUserManagement tblUserManagement = db.tblUserManagements.Find(id);
if (tblUserManagement == null)
{
return(NotFound());
}
db.tblUserManagements.Remove(tblUserManagement);
db.SaveChanges();
return(Ok(tblUserManagement));
}
public IHttpActionResult PutsStatus(tblUserManagement tblUserManagement)
{
if (tblUserManagement.Status != 1)
{
tblUserManagement.Status = 1;
}
else
{
tblUserManagement.Status = 0;
}
tblUserManagement.UpdatedBy = "UPDBY";
tblUserManagement.DateUpdated = DateTime.Now;
var switchery = db.Entry(tblUserManagement).State = EntityState.Modified;
db.SaveChanges();
return(Json("success"));
}
