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.")); } }