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