public void CreateHostTest() { DataLayerBase target = DataLayerFactory.Instance.GetDataLayer(DataLayerType.SqlServer); string hostName = "LG"; target.CreateHost(hostName); string filePath = @"c:\LG\chamame.mp3"; string album = "Chamame"; string artist = "Tarrago Ross"; string title = "Curuzu Cuatia"; int year = 1966; string genre = "Folklore"; target.CreateOrUpdateMusicTrack(hostName, filePath, album, artist, title, year, genre); int totalHostCount = 0; if (target.GetAllHosts() != null) { totalHostCount = target.GetAllHosts().Rows.Count; } Assert.AreEqual(2, totalHostCount, "It should be 2 Host on the database."); }
public void TestConnectionTest() { DataLayerBase target = DataLayerFactory.Instance.GetDataLayer(DataLayerType.SqlServer); bool expected = true; bool actual; actual = target.TestConnection(); Assert.AreEqual(expected, actual, "Test connection fail."); }
public void HostExistsTest() { DataLayerBase target = DataLayerFactory.Instance.GetDataLayer(DataLayerType.SqlServer); string hostName = "Frostmourne"; bool actual; actual = target.HostExists(hostName); Assert.AreEqual(true, actual, "Host Frostmourne should exists."); }
public static DataTable GettblExpenses(DbTransaction tran, object expenseId) { DataTable retVal = new DataTable(); Database db = DatabaseFactory.CreateDatabase(); DbCommand cmd = db.GetStoredProcCommand("proc_GettblExpenses"); db.AddInParameter(cmd, "@expenseId", DbType.Double, expenseId); retVal = DataLayerBase.ExecuteDataSet(db, tran, cmd).Tables[0]; return(retVal); }
public static int DeletetblExpenses(DbTransaction tran, object expenseId) { int retVal = -1; Database db = DatabaseFactory.CreateDatabase(); DbCommand cmd = db.GetStoredProcCommand("proc_DeletetblExpenses"); db.AddInParameter(cmd, "@expenseId", DbType.Double, expenseId); retVal = DataLayerBase.ExecuteNonQuery(db, tran, cmd); return(retVal); }
public void CreateOrUpdateMusicTrackTest() { DataLayerBase target = DataLayerFactory.Instance.GetDataLayer(DataLayerType.SqlServer); string hostName = "Frostmourne"; target.CreateHost(hostName); string filePath = @"c:\Music\chamame.mp3"; string album = "Chamame"; string artist = "Tarrago Ross"; string title = "Curuzu Cuatia"; int year = 1966; string genre = "Folklore"; target.CreateOrUpdateMusicTrack(hostName, filePath, album, artist, title, year, genre); filePath = @"c:\Music\coco.mp3"; album = "Greatest Hits"; artist = "Roxette"; title = "Dangerous"; year = 2004; genre = "Rock"; target.CreateOrUpdateMusicTrack(hostName, filePath, album, artist, title, year, genre); filePath = @"c:\Music\Arjona\pinguinos en la cama.mp3"; album = "Arjona"; artist = "Ricardo Arjona"; title = "Pinguinos en la cama"; year = 2005; genre = "Melódico"; target.CreateOrUpdateMusicTrack(hostName, filePath, album, artist, title, year, genre); DataTable dt = target.Search(album, artist, title, year, genre); Assert.AreEqual(1, dt.Rows.Count, "Music Track creation fail."); if (dt.Rows.Count > 0) { Guid musicTrackId = new Guid(dt.Rows[0][DBConstants.MusicTrackId].ToString()); DataRow dr = target.GetMusicTrack(musicTrackId); if (dr != null) { Assert.AreEqual(artist, dr[DBConstants.Artist].ToString(), "GetMusicTrack fail."); } } }
public static int UpdatetblSupply(DbTransaction tran, DateTime createdDate, DateTime modifiedDate, string supplyDescription, double supplyId, string supplyName) { int retVal = -1; Database db = DatabaseFactory.CreateDatabase(); DbCommand cmd = db.GetStoredProcCommand("proc_UpdatetblSupply"); db.AddInParameter(cmd, "@createdDate", DbType.DateTime, createdDate); db.AddInParameter(cmd, "@modifiedDate", DbType.DateTime, modifiedDate); db.AddInParameter(cmd, "@supplyDescription", DbType.String, supplyDescription); db.AddInParameter(cmd, "@supplyId", DbType.Double, supplyId); db.AddInParameter(cmd, "@supplyName", DbType.String, supplyName); retVal = DataLayerBase.ExecuteNonQuery(db, tran, cmd); return(retVal); }
public static int InserttblExpenses(DbTransaction tran, DateTime createdDate, string expenseAmount, string expenseDescription, double expenseId, string expenseName, DateTime modifiedDate) { int retVal = -1; Database db = DatabaseFactory.CreateDatabase(); DbCommand cmd = db.GetStoredProcCommand("proc_InserttblExpenses"); db.AddInParameter(cmd, "@createdDate", DbType.DateTime, createdDate); db.AddInParameter(cmd, "@expenseAmount", DbType.String, expenseAmount); db.AddInParameter(cmd, "@expenseDescription", DbType.String, expenseDescription); db.AddInParameter(cmd, "@expenseId", DbType.Double, expenseId); db.AddInParameter(cmd, "@expenseName", DbType.String, expenseName); db.AddInParameter(cmd, "@modifiedDate", DbType.DateTime, modifiedDate); retVal = DataLayerBase.ExecuteNonQuery(db, tran, cmd); return(retVal); }
public static int InserttblProducts(DbTransaction tran, DateTime createdDate, DateTime modifiedDate, string productCode, string productDescription, double productId, string productName) { int retVal = -1; Database db = DatabaseFactory.CreateDatabase(); DbCommand cmd = db.GetStoredProcCommand("proc_InserttblProducts"); db.AddInParameter(cmd, "@createdDate", DbType.DateTime, createdDate); db.AddInParameter(cmd, "@modifiedDate", DbType.DateTime, modifiedDate); db.AddInParameter(cmd, "@productCode", DbType.String, productCode); db.AddInParameter(cmd, "@productDescription", DbType.String, productDescription); db.AddInParameter(cmd, "@productId", DbType.Double, productId); db.AddInParameter(cmd, "@productName", DbType.String, productName); retVal = DataLayerBase.ExecuteNonQuery(db, tran, cmd); return(retVal); }
public static int UpdatetblProductSupply(DbTransaction tran, string costPrice, DateTime createdDate, string maxSellingPrice, string minSellingPrice, DateTime modifiedDate, double productId, double productSupplyId, string quantityAtHand, string suppliedQuantity, double supplyId) { int retVal = -1; Database db = DatabaseFactory.CreateDatabase(); DbCommand cmd = db.GetStoredProcCommand("proc_UpdatetblProductSupply"); db.AddInParameter(cmd, "@costPrice", DbType.String, costPrice); db.AddInParameter(cmd, "@createdDate", DbType.DateTime, createdDate); db.AddInParameter(cmd, "@maxSellingPrice", DbType.String, maxSellingPrice); db.AddInParameter(cmd, "@minSellingPrice", DbType.String, minSellingPrice); db.AddInParameter(cmd, "@modifiedDate", DbType.DateTime, modifiedDate); db.AddInParameter(cmd, "@productId", DbType.Double, productId); db.AddInParameter(cmd, "@productSupplyId", DbType.Double, productSupplyId); db.AddInParameter(cmd, "@quantityAtHand", DbType.String, quantityAtHand); db.AddInParameter(cmd, "@suppliedQuantity", DbType.String, suppliedQuantity); db.AddInParameter(cmd, "@supplyId", DbType.Double, supplyId); retVal = DataLayerBase.ExecuteNonQuery(db, tran, cmd); return(retVal); }
public void SearchTest() { DataLayerBase target = DataLayerFactory.Instance.GetDataLayer(DataLayerType.SqlServer); DataTable actual; //all fields string album = "Greatest Hits"; string artist = "Roxette"; string title = "Dangerous"; int year = 2004; string genre = "Rock"; actual = target.Search(album, artist, title, year, genre); if (actual != null) { Assert.AreEqual(1, actual.Rows.Count, "Search all field failed."); Assert.AreEqual(@"c:\Music\coco.mp3", actual.Rows[0][DBConstants.Path].ToString(), "Search result path mismatch."); } else { Assert.IsTrue(true, "DataTable from search is null."); } }
public static int UpdatetblSales(DbTransaction tran, string actualSellingPrice, string costPrice, DateTime createdDate, DateTime modifiedDate, string packType, double productId, string profit, string quantity, double saleId, double supplyId) { int retVal = -1; Database db = DatabaseFactory.CreateDatabase(); DbCommand cmd = db.GetStoredProcCommand("proc_UpdatetblSales"); db.AddInParameter(cmd, "@actualSellingPrice", DbType.String, actualSellingPrice); db.AddInParameter(cmd, "@costPrice", DbType.String, costPrice); db.AddInParameter(cmd, "@createdDate", DbType.DateTime, createdDate); db.AddInParameter(cmd, "@modifiedDate", DbType.DateTime, modifiedDate); db.AddInParameter(cmd, "@packType", DbType.String, packType); db.AddInParameter(cmd, "@productId", DbType.Double, productId); db.AddInParameter(cmd, "@profit", DbType.String, profit); db.AddInParameter(cmd, "@quantity", DbType.String, quantity); db.AddInParameter(cmd, "@saleId", DbType.Double, saleId); db.AddInParameter(cmd, "@supplyId", DbType.Double, supplyId); retVal = DataLayerBase.ExecuteNonQuery(db, tran, cmd); return(retVal); }