public HttpResponseMessage AddUserIPAddress(Entities.MstUserIPAddress objUserIPAddress)
{
try
{
var currentUser = from d in db.MstUsers
where d.UserId == User.Identity.GetUserId()
select d;
if (currentUser.Any())
{
var currentUserId = currentUser.FirstOrDefault().Id;
var userForms = from d in db.MstUserForms
where d.UserId == currentUserId &&
d.SysForm.FormName.Equals("UserDetail")
select d;
if (userForms.Any())
{
if (userForms.FirstOrDefault().CanAdd)
{
Data.MstUserIPAddress newUserIPAddress = new Data.MstUserIPAddress
{
UserId = objUserIPAddress.UserId,
IPAddress = objUserIPAddress.IPAddress,
Remarks = objUserIPAddress.Remarks
};
db.MstUserIPAddresses.InsertOnSubmit(newUserIPAddress);
db.SubmitChanges();
String newObject = at.GetObjectString(newUserIPAddress);
at.InsertAuditTrail(currentUser.FirstOrDefault().Id, GetType().Name, MethodBase.GetCurrentMethod().Name, "NA", newObject);
return(Request.CreateResponse(HttpStatusCode.OK, newUserIPAddress.Id));
}
else
{
return(Request.CreateResponse(HttpStatusCode.BadRequest, "Sorry. You have no rights to add IP Address."));
}
}
else
{
return(Request.CreateResponse(HttpStatusCode.BadRequest, "Sorry. You have no access for this user detail page."));
}
}
else
{
return(Request.CreateResponse(HttpStatusCode.BadRequest, "Theres no current user logged in."));
}
}
catch (Exception e)
{
Debug.WriteLine(e);
return(Request.CreateResponse(HttpStatusCode.InternalServerError, "Something's went wrong from the server."));
}
}
public HttpResponseMessage UpdateUserIPAddress(Entities.MstUserIPAddress objUserIPAddress, String id)
{
try
{
var currentUser = from d in db.MstUsers
where d.UserId == User.Identity.GetUserId()
select d;
if (currentUser.Any())
{
var currentUserId = currentUser.FirstOrDefault().Id;
var userForms = from d in db.MstUserForms
where d.UserId == currentUserId &&
d.SysForm.FormName.Equals("UserDetail")
select d;
if (userForms.Any())
{
if (userForms.FirstOrDefault().CanEdit)
{
var userIPAddress = from d in db.MstUserIPAddresses
where d.Id == Convert.ToInt32(id)
select d;
if (userIPAddress.Any())
{
String oldObject = at.GetObjectString(userIPAddress.FirstOrDefault());
var updateUserIPAddress = userIPAddress.FirstOrDefault();
updateUserIPAddress.UserId = objUserIPAddress.UserId;
updateUserIPAddress.IPAddress = objUserIPAddress.IPAddress;
updateUserIPAddress.Remarks = objUserIPAddress.Remarks;
db.SubmitChanges();
String newObject = at.GetObjectString(userIPAddress.FirstOrDefault());
at.InsertAuditTrail(currentUser.FirstOrDefault().Id, GetType().Name, MethodBase.GetCurrentMethod().Name, oldObject, newObject);
return(Request.CreateResponse(HttpStatusCode.OK));
}
else
{
return(Request.CreateResponse(HttpStatusCode.NotFound, "Data not found. These IP Address details are not found in the server."));
}
}
else
{
return(Request.CreateResponse(HttpStatusCode.BadRequest, "Sorry. You have no rights to edit and update IP Address."));
}
}
else
{
return(Request.CreateResponse(HttpStatusCode.BadRequest, "Sorry. You have no access for this user detail page."));
}
}
else
{
return(Request.CreateResponse(HttpStatusCode.BadRequest, "Theres no current user logged in."));
}
}
catch (Exception e)
{
Debug.WriteLine(e);
return(Request.CreateResponse(HttpStatusCode.InternalServerError, "Something's went wrong from the server."));
}
}
