public bool UserValidatonWithFacebook(string email, bool facebook)
{
bool result = false;
if (facebook)
{
using (BaseDB.BaseDataAccess baseDataAccess = new BaseDB.BaseDataAccess())
{
using (BaseDB.BaseAdapter adapter = new BaseDB.BaseAdapter())
{
BaseCommand cmd = new BaseCommand(baseDataAccess.MsConn);
cmd.CommandType = System.Data.CommandType.Text;
cmd.CommandText = "Select * From gnl_kullanicilar Where email=@email";
adapter.SelectCommand = cmd.Command;
adapter.SelectCommand.Parameters.AddWithValue("email", email);
DataSet userDataSet = new DataSet();
adapter.Fill(userDataSet, "Table");
userTable = userDataSet.Tables[0];
if (userTable.Rows.Count == 1)
{
result = true;
}
}
}
}
return(result);
}
public bool UserValidatonWithAktivasyonKey(string email, string passWord, string key)
{
using (BaseDB.BaseDataAccess baseDataAccess = new BaseDB.BaseDataAccess())
{
using (BaseDB.BaseAdapter adapter = new BaseDB.BaseAdapter())
{
string encriptedPassword = this.EncriptText(passWord);
System.Text.Encoding enc = System.Text.Encoding.ASCII;
byte[] byteArray = enc.GetBytes(encriptedPassword);
BaseCommand cmd = new BaseCommand(baseDataAccess.MsConn);
cmd.CommandType = System.Data.CommandType.Text;
cmd.CommandText = "Select * From gnl_kullanicilar Where email=@email And sifre=@sifre And (aktif = 1 or aktif is null) and aktivasyon_key='" + key + "'";
adapter.SelectCommand = cmd.Command;
adapter.SelectCommand.Parameters.AddWithValue("email", email);
adapter.SelectCommand.Parameters.AddWithValue("sifre", byteArray);
DataSet userDataSet = new DataSet();
adapter.Fill(userDataSet, "Table");
userTable = userDataSet.Tables[0];
return(userTable.Rows.Count == 1);
}
}
}
public bool UserValidaton(string email, string passWord)
{
using (BaseDB.BaseDataAccess baseDataAccess = new BaseDB.BaseDataAccess())
{
using (BaseDB.BaseAdapter adapter = new BaseDB.BaseAdapter())
{
string encriptedPassword = this.EncriptText(passWord);
System.Text.Encoding enc = System.Text.Encoding.ASCII;
BaseCommand cmd = new BaseCommand(baseDataAccess.MsConn);
cmd.CommandType = System.Data.CommandType.Text;
cmd.CommandText = "Select * From gnl_users Where email=@email And password=@password And is_active = 1";
adapter.SelectCommand = cmd.Command;
adapter.SelectCommand.Parameters.AddWithValue("email", email);
adapter.SelectCommand.Parameters.AddWithValue("password", encriptedPassword);
DataSet userDataSet = new DataSet();
adapter.Fill(userDataSet, "Table");
userTable = userDataSet.Tables[0];
return(userTable.Rows.Count == 1);
}
}
}
public bool UserValidatonWithUserId(Guid user_id)
{
bool result = false;
using (BaseDB.BaseDataAccess baseDataAccess = new BaseDB.BaseDataAccess())
{
using (BaseDB.BaseAdapter adapter = new BaseDB.BaseAdapter())
{
BaseCommand cmd = new BaseCommand(baseDataAccess.MsConn);
cmd.CommandType = System.Data.CommandType.Text;
cmd.CommandText = "Select * From gnl_users Where user_id=@user_id";
adapter.SelectCommand = cmd.Command;
adapter.SelectCommand.Parameters.AddWithValue("user_id", user_id);
DataSet userDataSet = new DataSet();
adapter.Fill(userDataSet, "Table");
userTable = userDataSet.Tables[0];
if (userTable.Rows.Count == 1)
{
result = true;
}
}
}
return(result);
}
public DataSet SelectPartial(string from, string fields, string filter, int start, int limit, string orderBy, out int totalRecords)
{
BaseCommand cmn = new BaseCommand(MsConn);
cmn.CommandType = System.Data.CommandType.StoredProcedure;
cmn.CommandText = "GetPartialData";
cmn.Command.Parameters.AddWithValue("tableName", from);
cmn.Command.Parameters.AddWithValue("fields", fields);
cmn.Command.Parameters.AddWithValue("filter", filter);
cmn.Command.Parameters.AddWithValue("start", start);
cmn.Command.Parameters.AddWithValue("limit", limit);
cmn.Command.Parameters.AddWithValue("orderby", orderBy);
cmn.Command.Parameters.Add("totalRecords", SqlDbType.Int);
cmn.Command.Parameters["totalRecords"].Direction = ParameterDirection.Output;
cmn.Command.CommandType = CommandType.StoredProcedure;
if (baseClassAdapter != null)
{
baseClassAdapter.Dispose();
}
baseClassAdapter = new BaseAdapter();
baseClassAdapter.SelectCommand = cmn.Command;
baseClassAdapter.TableMappings(tableName, tableName);
DataSet Data = new DataSet();
baseClassAdapter.Fill(Data, tableName);
totalRecords = (int)cmn.Command.Parameters["totalRecords"].Value;
return(Data);
}
private void CreateAdapter()
{
baseClassAdapter = new BaseAdapter();
baseClassAdapter.TableMappings(tableName, tableName);
}
