public static bool checkPivot(string pname) { PivotCard1DataContext db = new PivotCard1DataContext(); int userExists = (int)db.GetCheckPivot(pname).ReturnValue; return(Convert.ToBoolean(userExists)); }
public static bool checkUser(string identifier) { PivotCard1DataContext db = new PivotCard1DataContext(); int userExists = (int)db.GetCheckUser(identifier).ReturnValue; return(Convert.ToBoolean(userExists)); }
public static bool savePivot(string pName, PivotData p) { int pivData = 0; PivotCard1DataContext db = new PivotCard1DataContext(); try { pivData = (int)db.SetSavePivot(pName, p.PivotCode, Convert.ToInt32(p.PivotId), p.PivotContent, Convert.ToInt32(p.PivotType), Convert.ToBoolean(p.PivotDefault)).ReturnValue; } catch { return(false); } return(Convert.ToBoolean(pivData)); }
public static bool deletePivot(string pname, string pid) { PivotCard1DataContext db = new PivotCard1DataContext(); IEnumerable <Pivot> pivData = db.SetDeletePivot(pname, Convert.ToInt32(pid)); List <Pivot> returnval = pivData.ToList(); if (returnval.Count > 0) { return(true); } return(false); }
public static string getPivotName(string uname) { string pname = null; PivotCard1DataContext db = new PivotCard1DataContext(); List <GetPivotNameResult> pivotName = db.GetPivotName(uname).ToList(); if (pivotName.Count > 0) { pname = pivotName[0].PivotName.ToString(); } return(pname); }
//public static bool loginUser(string UserName, string Password, string PivotName, string FirstName) //{ // PivotCard1DataContext db = new PivotCard1DataContext(); // int userLogin = (int)db.SetLoginUser(UserName,Password,PivotName,FirstName).ReturnValue; // return Convert.ToBoolean(userLogin); //} public static bool addUserToDB(string UserName, string FirstName, string PivotName, string Password) { try { Membership.CreateUser(UserName, Password); PivotCard1DataContext db = new PivotCard1DataContext(); int userLogin = (int)db.SetUpdateUser(PivotName, UserName, FirstName); return(true); } catch (Exception ex) { return(false); } }
public static PivotData getPivotRedir(string pname, string pcode, bool bdefault) { PivotCard1DataContext db = new PivotCard1DataContext(); IEnumerable <Pivot> pivData = db.GetPivotRedir(pname, pcode, bdefault); List <Pivot> returnval = pivData.ToList(); return(new PivotData { PivotCode = returnval[0].PivotCode, PivotId = returnval[0].ID.ToString(), PivotContent = returnval[0].PivotContent, PivotType = returnval[0].Type.ToString(), PivotDefault = returnval[0].IsDefault.ToString() }); }
//public static bool loginUser(string UserName, string Password, string PivotName, string FirstName) //{ // PivotCard1DataContext db = new PivotCard1DataContext(); // int userLogin = (int)db.SetLoginUser(UserName,Password,PivotName,FirstName).ReturnValue; // return Convert.ToBoolean(userLogin); //} public static bool addUserToDB(string UserName, string FirstName, string PivotName, string Password) { try { MembershipCreateStatus foo = new MembershipCreateStatus(); Membership.Providers["SqlProvider"].CreateUser(UserName, Password, null, null, null, true, null, out foo); PivotCard1DataContext db = new PivotCard1DataContext(); int userLogin = (int)db.SetUpdateUser(PivotName, UserName, FirstName); return(true); } catch (Exception ex) { return(false); } }
public static IEnumerable <PivotData> getPivots(string pname) { //XDocument pivotDoc = UserFile.getPivotFile(pname); PivotCard1DataContext db = new PivotCard1DataContext(); IEnumerable <Pivot> pivData = db.GetPivots(pname); foreach (Pivot piv in pivData) { yield return(new PivotData { PivotCode = piv.PivotCode, PivotId = piv.ID.ToString(), PivotContent = piv.PivotContent, PivotType = piv.Type.ToString(), PivotDefault = piv.IsDefault.ToString() }); } }
public static IEnumerable <PivotData> getPivot(string pname, string pid) { PivotCard1DataContext db = new PivotCard1DataContext(); IEnumerable <Pivot> pivData = db.GetPivot(pname, Convert.ToInt32(pid)); List <Pivot> returnval = pivData.ToList(); if (returnval.Count < 1) { yield break; } yield return(new PivotData { PivotCode = returnval[0].PivotCode, PivotId = returnval[0].ID.ToString(), PivotContent = returnval[0].PivotContent, PivotType = returnval[0].Type.ToString(), PivotDefault = returnval[0].IsDefault.ToString() }); }
/// <summary> /// Updates user password and/or PivotName. Username is required. Other fields can contain null. /// </summary> /// <param name="UserName"></param> /// <param name="oldPassword"></param> /// <param name="newPassWord"></param> /// <param name="pivotName"></param> /// <returns></returns> public static bool updateUserInfo(string UserName, string oldPassword, string newPassWord, string pivotName) { PivotCard1DataContext db = new PivotCard1DataContext(); MembershipUser u; u = Membership.GetUser(UserName); if (u != null && (oldPassword != null && newPassWord != null)) { try { u.ChangePassword(oldPassword, newPassWord); } catch { return(false); } } if (pivotName != null) { try { int retVal = db.SetUpdatePivot(pivotName, UserName); if (retVal == 0) { return(false); } } catch { return(false); } } return(true); }