public ActionResult New(string id = "") { long permissionid = default(long); var obj = new UserPermissionMaster(); try { if (!string.IsNullOrEmpty(id)) { long.TryParse(Encryption64.DecryptQueryString(id), out permissionid); } if (permissionid > default(long)) { obj = DBOperations <UserPermissionMaster> .GetSpecific(new UserPermissionMaster() { AccessID = permissionid, Opmode = 4 }, Constant.usp_UserPermissionMaster); } } catch (Exception) { } return(View("New", obj)); }
public JsonResult SaveData(UserPermissionMaster postData) { long accessid = default(long); try { if (postData == null) { throw new Exception("No data found for insert"); } long.TryParse(Encryption64.DecryptQueryString(postData.EncryptedAccessID), out accessid); postData.AccessID = accessid; postData.Opmode = accessid > default(int) ? 5 : 0; UserPermissionMaster obj = new UserPermissionMaster(); obj.UserID = postData.UserID; obj.OrgID = postData.OrgID; obj.LocationID = postData.LocationID; obj.SublocationID = postData.SublocationID; obj.DeptID = postData.DeptID; obj.ProjectID = postData.ProjectID; obj.SubTypeID = postData.SubTypeID; obj.AccessID = accessid; if (postData.Opmode == 0) //add { obj.Opmode = 1; } else { obj.Opmode = 6; // edit } // var countid = default(long); if (postData.Opmode == 0) // add { var objcount = new UserPermissionMaster(); objcount = DBOperations <UserPermissionMaster> .GetSpecific(obj, Constant.usp_UserPermissionMaster); if (objcount.AccessID > default(long)) { throw new Exception("Permission already exist"); } else { var result = DBOperations <UserPermissionMaster> .DMLOperation(postData, Constant.usp_UserPermissionMaster); if (result > default(int)) { return(Json(new { Success = 1, Message = string.Format("Data have been {0} successfully", accessid > default(long) ? "updated" : "saved") }, JsonRequestBehavior.AllowGet)); } else { throw new Exception("Operation has been failed to execute"); } } } else // edit { var objcount = new UserPermissionMaster(); objcount = DBOperations <UserPermissionMaster> .GetSpecific(obj, Constant.usp_UserPermissionMaster); if (objcount.AccessID > default(long)) { throw new Exception("Permission already exist"); } else { var result = DBOperations <UserPermissionMaster> .DMLOperation(postData, Constant.usp_UserPermissionMaster); if (result > default(int)) { return(Json(new { Success = 1, Message = string.Format("Data have been {0} successfully", accessid > default(long) ? "updated" : "saved") }, JsonRequestBehavior.AllowGet)); } else { throw new Exception("Operation has been failed to execute"); } } } } catch (Exception ex) { return(Json(new { Success = default(int), Message = ex.Message }, JsonRequestBehavior.AllowGet)); } }