public static DataBase GetInstance()
{
if (instance == null)
instance = new DataBase();
return instance;
}
public static DataTable GetLotteryUser(string sPhoneNumber)
{
DataBase dataBase = new DataBase();
string sql = "select * from Players where CellPhoneNo = @CellPhoneNo";
SqlParameter[] sqlparameter = new SqlParameter[1];
sqlparameter[0] = new SqlParameter("@CellPhoneNo", sPhoneNumber);
return dataBase.ExcuteSqlReturnDataTable(sql, sqlparameter);
}
public static DataTable GetUserDownloadInfo(string sPhoneNumber)
{
DataBase dataBase = new DataBase();
string sql = "select * from DownloadHistory where CellPhoneNo = @CellPhoneNo";
SqlParameter[] sqlparameter = new SqlParameter[1];
sqlparameter[0] = new SqlParameter("@CellPhoneNo", sPhoneNumber);
return dataBase.ExcuteSqlReturnDataTable(sql, sqlparameter);
}
public static void DownloadGame2(string sPhoneNumber)
{
DataBase dataBase = new DataBase();
string sql = "exec spDownloadGame2 @CellPhoneNo = @CellPhone";
SqlParameter[] sqlparameter = new SqlParameter[1];
sqlparameter[0] = new SqlParameter("@CellPhone", sPhoneNumber);
dataBase.ExcuteSqlReturnInt(sql, sqlparameter);
}
public void DataAccessUpdateTest()
{
var data = new DataAccess.DataBase(Path.Combine(Path.GetTempPath(), Guid.NewGuid().ToString()));
var storedId = data.StoreFile("www.sample.com", "file.txt", @"//Storage/file1.txt", 100, string.Empty, string.Empty, DateTime.Now);
var file = data.GetFullFile(storedId);
file.Should().NotBeNull();
file.Should().BeOfType <FullFile>();
}
public static DataTable GetLotteryHistory(string sPhoneNumber)
{
DataBase dataBase = new DataBase();
string sql = "select a.cellphoneno,a.lotterytime,b.awardname,a.cardcode from LotteryHistory a join Awards b on a.AwardId = b.AwardId";
if (!string.IsNullOrWhiteSpace(sPhoneNumber))
{
sql += "where CellPhoneNo = " + sPhoneNumber;
}
return dataBase.ExcuteSqlReturnDataTable(sql);
}
public void DataAccessStoreAndGetTest()
{
var data = new DataAccess.DataBase(Path.Combine(Path.GetTempPath(), Guid.NewGuid().ToString()));
data.StoreFile("www.sample.com", "file.txt", @"//Storage/file1.txt", 100, string.Empty, string.Empty, DateTime.Now);
data.StoreFile("www.sample.com", "file2.txt", @"//Storage/file2.txt", 100, string.Empty, string.Empty, DateTime.Now);
var files = data.GetFiles(0, 1).ToArray();
files.Should().NotBeNull();
files.Count().Should().Be(1);
var file = files.First();
file.Should().NotBeNull();
file.Should().BeOfType <FullFile>();
file.Name.Should().Be("file.txt");
}
public Administrador GetNameAdmin(string rut_admin, string pass_admin)
{
DataAccess.DataBase bd = new DataAccess.DataBase();
bd.connect();
string sql = "SELECT NOM_ADMIN FROM ADMINISTRADOR WHERE RUT_ADMIN='" + rut_admin + "' AND PASS_ADMIN= '" + pass_admin + "'";
bd.CreateCommand(sql);
Administrador llocal = new Administrador();
Administrador a = null;
DbDataReader result = bd.Query();
result.Read();
a = new Administrador(result.GetString(0));
result.Close();
bd.Close();
return(a);
}
public Restaurant ReturnNombre(string email_rest, string pass_rest)
{
DataAccess.DataBase bd = new DataAccess.DataBase();
bd.connect();
string sql = "SELECT NOMBRE_REST FROM RESTAURANT WHERE EMAIL_REST='" + email_rest + "' AND PASS_REST= '" + pass_rest + "'";
bd.CreateCommand(sql);
Restaurant llocal = new Restaurant();
Restaurant a = null;
DbDataReader result = bd.Query();
result.Read();
a = new Restaurant(result.GetString(0));
result.Close();
bd.Close();
return(a);
}
public bool LoginAdmin(string rut_admin, string pass_admin)
{
bool ok = false;
DataAccess.DataBase bd = new DataAccess.DataBase();
bd.connect();
string sql = "SELECT * FROM ADMINISTRADOR WHERE RUT_ADMIN='" + rut_admin + "' AND PASS_ADMIN= '" + pass_admin + "'";
bd.CreateCommand(sql);
DbDataReader result = bd.Query();
if (result.Read())
{
ok = true;
}
//Administrador c = new Administrador(result.GetString(0), result.GetString(1));
result.Close();
bd.Close();
return(ok);
}
public bool LoginUsuario(string rut_usuario, string pass_usuario)
{
bool ok = false;
DataAccess.DataBase bd = new DataAccess.DataBase();
bd.connect();
string sql = "SELECT * FROM USUARIO WHERE RUT_USUARIO='" + rut_usuario + "' AND PASS_USUARIO= '" + pass_usuario + "'";
bd.CreateCommand(sql);
DbDataReader result = bd.Query();
if (result.Read())
{
ok = true;
}
//Administrador c = new Administrador(result.GetString(0), result.GetString(1));
result.Close();
bd.Close();
return(ok);
}
public List <Restaurant> getCodeRest()
{
DataAccess.DataBase bd = new DataAccess.DataBase();
bd.connect(); //método conectar
List <Restaurant> rest = new List <Restaurant>();
string sql = "SELECT COD_REST,NOMBRE_REST FROM RESTAURANT";
bd.CreateCommand(sql);
DbDataReader readed = bd.Query();//resultado de la consulta
while (readed.Read())
{
Restaurant r = new Restaurant(readed.GetInt32(0), readed.GetString(1));
rest.Add(r);
}
readed.Close();
bd.Close();
return(rest);
}
public bool LoginRest(string email_rest, string pass_rest)
{
bool ok = false;
DataAccess.DataBase bd = new DataAccess.DataBase();
bd.connect();
string sql = "SELECT * FROM RESTAURANT WHERE EMAIL_REST='" + email_rest + "' AND PASS_REST= '" + pass_rest + "'";
bd.CreateCommand(sql);
DbDataReader result = bd.Query();
if (result.Read())
{
ok = true;
}
//Administrador c = new Administrador(result.GetString(0), result.GetString(1));
result.Close();
bd.Close();
return(ok);
}
public EstadisticaDAO()
{
db = DataBase.GetInstance();
}
public ClienteDAO()
{
db = DataBase.GetInstance();
}
public ProductoDAO()
{
db = DataBase.GetInstance();
}
public ViajeDAO()
{
db = DataBase.GetInstance();
}
public static void StoreLotteryUser(string sPhoneNumber)
{
DataBase dataBase = new DataBase();
string sql = "exec spNewPlayer @CellPhoneNo = @CellPhone";
SqlParameter[] sqlparameter = new SqlParameter[1];
sqlparameter[0] = new SqlParameter("@CellPhone", sPhoneNumber);
dataBase.ExcuteSqlReturnInt(sql, sqlparameter);
}
public static DataTable ReduceCountAndSaveHistory(string sPhoneNumber, string sAwardId)
{
DataBase dataBase = new DataBase();
string sql = "exec spLotteryProcess @CellPhoneNo = @CellPhone , @AwardID = @Award ";
SqlParameter[] sqlparameter = new SqlParameter[2];
sqlparameter[0] = new SqlParameter("@CellPhone", sPhoneNumber);
sqlparameter[1] = new SqlParameter("@Award", sAwardId);
return dataBase.ExcuteSqlReturnDataTableTransaction(sql, sqlparameter);
}
public MillaDAO()
{
db = DataBase.GetInstance();
}
public AeronaveDAO()
{
db = DataBase.GetInstance();
}
public FabricanteDAO()
{
db = DataBase.GetInstance();
}
public static DataTable GetLotteryAllUser()
{
DataBase dataBase = new DataBase();
string sql = "select * from Players ";
return dataBase.ExcuteSqlReturnDataTable(sql);
}
public ServicioDAO()
{
db = DataBase.GetInstance();
}
public static bool UpdateAward(string sAwardId,string sAwardName, string sRate, string sTotalCount, string sSurplusCount)
{
DataBase dataBase = new DataBase();
string sql = "update Awards set AwardName = @AwardName ,Rate = @Rate, TotalCount = @TotalCount,SurplusCount = @SurplusCount where AwardId = @AwardId ";
SqlParameter[] sqlparameter = new SqlParameter[5];
sqlparameter[0] = new SqlParameter("@AwardName", sAwardName);
sqlparameter[1] = new SqlParameter("@Rate", sRate);
sqlparameter[2] = new SqlParameter("@TotalCount", sTotalCount);
sqlparameter[3] = new SqlParameter("@SurplusCount", sSurplusCount);
sqlparameter[4] = new SqlParameter("@AwardId", sAwardId);
return dataBase.ExcuteSqlReturnInt(sql, sqlparameter) > 0;
}
public ButacaDAO()
{
db = DataBase.GetInstance();
}
public static DataTable GetAllLotteryAwards()
{
DataBase dataBase = new DataBase();
string sql = "select * from Awards";
return dataBase.ExcuteSqlReturnDataTable(sql);
}
public static DataTable GetGame2DownTime()
{
DataBase dataBase = new DataBase();
string sql = "select * from DownloadHistory where Game2 = 1";
return dataBase.ExcuteSqlReturnDataTable(sql);
}
public RolDAO()
{
db = DataBase.GetInstance();
}
public CiudadDAO()
{
db = DataBase.GetInstance();
}