public IHttpActionResult DelTempAccessPermissionTbl(AccessPermissionTbl accessPermission)
{
try
{
AccessPermissionTbl accessPermissiontbl = new AccessPermissionTbl();
int userId = accessPermission.UserId;
int accessId = accessPermission.AccessId;
int permissionId = accessPermission.PermissionId;
AccessPermissionTbl accessPermissionTbl1 = db.AccessPermissionTbls.Find(userId, accessId, permissionId);
db.AccessPermissionTbls.Remove(accessPermissionTbl1);
db.SaveChanges();
return(Ok(accessPermissionTbl1));
}
catch (Exception)
{
return(Content(HttpStatusCode.NotFound, "userId, accessId, permissionId these type of combination is not there..."));
}
}
public IHttpActionResult DeleteTempAccessPermissionTblBasedOnUserId(int id)
{
try
{
int uid = id;
var result = (from a in db.AccessPermissionTbls
where a.UserId.Equals(uid)
select new
{
a.UserId,
a.AccessId,
a.PermissionId
}).ToList();
if (result.Count() > 0)
{
for (int i = 0; i < result.Count(); i++)
{
AccessPermissionTbl accessPermissionTbl = new AccessPermissionTbl();
int userid1 = result.ToList()[i].UserId;
int access = result.ToList()[i].AccessId;
int permission = result.ToList()[i].PermissionId;
AccessPermissionTbl accessPermissionTbl1 = db.AccessPermissionTbls.Find(userid1, access, permission);
db.AccessPermissionTbls.Remove(accessPermissionTbl1);
}
db.SaveChanges();
}
else
{
Console.WriteLine("Error");
return(Content(HttpStatusCode.NotFound, "User with id = " + uid.ToString() + " not found"));
}
return(Ok("Userid " + uid + " Successfully deleted"));
}
catch (Exception)
{
return(Content(HttpStatusCode.BadRequest, "User should give data in proper format"));
}
}
public IHttpActionResult UpdateAccessPermissionTbl(UserDataModel userDataModal)
{
try
{
int role = userDataModal.role;
int userId = userDataModal.UserId;
var result = (from a in db.AccessPermissionTbls
where a.UserId.Equals(userId)
select new
{
a.AccessId,
a.PermissionId,
a.UserId
}).ToList();
var result1 = (from a in db.RoleAccessPermissionTbls
where a.RoleId.Equals(role)
select new
{
a.RoleId,
a.AccessId,
a.PermissionId
}).ToList();
if (result.Count() > 0)
{
if (result1.Count() > 0)
{
for (int j = 0; j < result1.Count(); j++)
{
for (int i = 0; i < result.Count(); i++)
{
if (result.ToList()[i].AccessId == result1.ToList()[j].AccessId && result.ToList()[i].PermissionId == result1.ToList()[j].PermissionId)
{
AccessPermissionTbl accessPermissiontbl = new AccessPermissionTbl();
int userid1 = userId;
int access = result1.ToList()[j].AccessId;
int permission = result1.ToList()[j].PermissionId;
AccessPermissionTbl accessPermissionTbl1 = db.AccessPermissionTbls.Find(userid1, access, permission);
db.AccessPermissionTbls.Remove(accessPermissionTbl1);
db.SaveChanges();
return(Ok("RoleId, AccessId and PermissionId these combination is already there " +
"and click save again if you have given morethen one Accessname and Permission name..."));
}
}
}
}
}
if (result1.Count() > 0)
{
for (int i = 0; i < result1.Count(); i++)
{
AccessPermissionTbl accessPermissionTbl = new AccessPermissionTbl();
accessPermissionTbl.AccessId = result1.ToList()[i].AccessId;
accessPermissionTbl.PermissionId = result1.ToList()[i].PermissionId;
accessPermissionTbl.UserId = userId;
db.AccessPermissionTbls.Add(accessPermissionTbl);
}
db.SaveChanges();
}
else
{
return(Content(HttpStatusCode.NotFound, "RoleId & UserId is not there"));
}
var result10 = (from a in db.AccessPermissionTbls
where a.UserId == userId
select new { a.AccessId, a.PermissionId }).ToList();
var result2 = (from b in db.AccessPermissionTbls
where b.UserId.Equals(userId)
select new
{
b.UserId,
b.AccessId,
b.PermissionId
}).ToList();
if (result1.Count() > 0)
{
for (int i = 0; i < result1.Count(); i++)
{
RoleAccessPermissionTbl roleAccessPermissionTbl = new RoleAccessPermissionTbl();
int roleid = result1.ToList()[i].RoleId;
int accessid = result1.ToList()[i].AccessId;
int permissionid = result1.ToList()[i].PermissionId;
RoleAccessPermissionTbl roleAccessPermissionTbl1 = db.RoleAccessPermissionTbls.Find(roleid, accessid, permissionid);
db.RoleAccessPermissionTbls.Remove(roleAccessPermissionTbl1);
}
db.SaveChanges();
}
if (result2.Count() > 0)
{
for (int i = 0; i < result2.Count(); i++)
{
RoleAccessPermissionTbl roleAccessPermissionTbl = new RoleAccessPermissionTbl();
roleAccessPermissionTbl.RoleId = role;
roleAccessPermissionTbl.AccessId = result2.ToList()[i].AccessId;
roleAccessPermissionTbl.PermissionId = result2.ToList()[i].PermissionId;
db.RoleAccessPermissionTbls.Add(roleAccessPermissionTbl);
}
db.SaveChanges();
}
if (result2.Count() > 0)
{
for (int i = 0; i < result2.Count(); i++)
{
AccessPermissionTbl accessPermissionTbl = new AccessPermissionTbl();
int access = result2.ToList()[i].AccessId;
int permission = result2.ToList()[i].PermissionId;
int userid = userId;
AccessPermissionTbl accessPermissionTbl1 = db.AccessPermissionTbls.Find(userid, access, permission);
db.AccessPermissionTbls.Remove(accessPermissionTbl1);
}
db.SaveChanges();
}
return(Ok(result10));
}
catch (Exception)
{
return(Content(HttpStatusCode.NotFound, "RoleId & UserId already exists"));
}
}
public IHttpActionResult AddRoleTblAndAccessPermissionTbl(UserDataModel userDataModel)
{
int latestRoleId = 0;
try
{
string rolename = userDataModel.RoleName;
var result3 = (from a in db.RoleTbls
where a.RoleName.Equals(userDataModel.RoleName)
select new
{
a.RoleName,
a.RoleId
});
if (result3.Count() > 0)
{
for (int i = 0; i < result3.Count(); i++)
{
latestRoleId = result3.ToList()[i].RoleId;
}
}
else
{
RoleTbl roleTbl = new RoleTbl();
roleTbl.RoleName = userDataModel.RoleName;
db.RoleTbls.Add(roleTbl);
db.SaveChanges();
latestRoleId = roleTbl.RoleId;
}
int userId = 0;
var result4 = (from a in db.UserTbls
where a.UserId.Equals(userDataModel.UserId)
select new
{
a.UserId,
a.DeletedDate
});
if (result4.Count() > 0)
{
for (int i = 0; i < result4.Count(); i++)
{
if (result4.ToList()[i].DeletedDate == null && result4.ToList()[i].UserId == userDataModel.UserId)
{
userId = result4.ToList()[i].UserId;
}
else
{
return(Content(HttpStatusCode.NotFound, "This user account is not null else not there in UserTbl"));
}
}
}
else if (result4.Count() == 0)
{
return(Content(HttpStatusCode.NotFound, "Userid is not exists"));
}
var result = (from a in db.AccessPermissionTbls
where a.UserId.Equals(userId)
select new
{
a.AccessId,
a.PermissionId,
a.UserId
}).ToList();
var result1 = (from a in db.RoleAccessPermissionTbls
where a.RoleId.Equals(latestRoleId)
select new
{
a.RoleId,
a.AccessId,
a.PermissionId
}).ToList();
if (result.Count() > 0)
{
if (result1.Count() > 0)
{
for (int j = 0; j < result1.Count(); j++)
{
for (int i = 0; i < result.Count(); i++)
{
if (result.ToList()[i].AccessId == result1.ToList()[j].AccessId && result.ToList()[i].PermissionId == result1.ToList()[j].PermissionId)
{
AccessPermissionTbl accessPermissiontbl = new AccessPermissionTbl();
int userid1 = userId;
int access = result1.ToList()[j].AccessId;
int permission = result1.ToList()[j].PermissionId;
AccessPermissionTbl accessPermissionTbl1 = db.AccessPermissionTbls.Find(userid1, access, permission);
db.AccessPermissionTbls.Remove(accessPermissionTbl1);
db.SaveChanges();
return(Ok("RoleId, AccessId and PermissionId these combination are already there " +
"and click save again if you have given morethen one Accessname and Permission name..."));
}
}
}
}
}
if (result.Count() > 0)
{
for (int i = 0; i < result.Count(); i++)
{
RoleAccessPermissionTbl roleAccessPermissionTbl = new RoleAccessPermissionTbl();
roleAccessPermissionTbl.AccessId = result.ToList()[i].AccessId;
roleAccessPermissionTbl.PermissionId = result.ToList()[i].PermissionId;
roleAccessPermissionTbl.RoleId = latestRoleId;
db.RoleAccessPermissionTbls.Add(roleAccessPermissionTbl);
}
db.SaveChanges();
}
if (result.Count() > 0)
{
for (int j = 0; j < result.Count(); j++)
{
AccessPermissionTbl accessPermissiontbl = new AccessPermissionTbl();
int userid1 = result.ToList()[j].UserId;
int access = result.ToList()[j].AccessId;
int permission = result.ToList()[j].PermissionId;
AccessPermissionTbl accessPermissionTbl1 = db.AccessPermissionTbls.Find(userid1, access, permission);
db.AccessPermissionTbls.Remove(accessPermissionTbl1);
}
db.SaveChanges();
}
else
{
return(Content(HttpStatusCode.BadRequest, "insert record first in AccessPermissionTbl"));
}
//db.SaveChanges();
return(Ok("Successfully Added"));
}
catch (Exception ex)
{
return(Content(HttpStatusCode.BadRequest, ex));
}
}
public IHttpActionResult AddTempAccessPermissionTbl(AccessPermissionTbl accessPermission)
{
try
{
int userId = 0;
var result4 = (from a in db.UserTbls
where a.UserId.Equals(accessPermission.UserId)
select new
{
a.UserId,
a.DeletedDate
});
if (result4.Count() > 0)
{
for (int i = 0; i < result4.Count(); i++)
{
if (result4.ToList()[i].DeletedDate == null && result4.ToList()[i].UserId == accessPermission.UserId)
{
userId = result4.ToList()[i].UserId;
}
else
{
return(Content(HttpStatusCode.NotFound, "This user account is not null else not there in UserTbl"));
}
}
}
else if (result4.Count() == 0)
{
return(Content(HttpStatusCode.NotFound, "Userid is not exists"));
}
if (userId == accessPermission.UserId)
{
db.AccessPermissionTbls.Add(accessPermission);
db.SaveChanges();
var result = (from a in db.AccessPermissionTbls
where a.UserId.Equals(accessPermission.UserId) &&
a.PermissionId.Equals(accessPermission.PermissionId) &&
a.AccessId.Equals(accessPermission.AccessId)
select new
{
a.UserId,
a.AccessId,
a.PermissionId
});
if (result.Count() > 0)
{
for (int i = 0; i < result.Count(); i++)
{
return(Ok(result));
}
}
}
return(Content(HttpStatusCode.BadRequest, "table is empty based on UserId"));
}
catch (Exception)
{
return(Content(HttpStatusCode.BadRequest, "UserId, AccessId and PermissionId this sequence is already exists"));
}
}
