public void TestDeleteMethod()
{
// create collection instance
clsBrandCollection AllBrands = new clsBrandCollection();
// create the test brand
clsBrand Brand = new clsBrand();
//PK Var
Int32 PK = 0;
//set brand's fields
Brand.BrandName = "Nike";
Brand.TopProduct = 1;
Brand.LatestProduct = 2;
Brand.LastRestock = DateTime.Now.Date;
Brand.AvgPrice = 0.00;
// set the collection's thisbrand to the test item.
AllBrands.ThisBrand = Brand;
// add record to database
PK = AllBrands.Add();
// set brand PK
Brand.BrandID = PK;
// find record
AllBrands.ThisBrand.Find(PK);
//invoke delete
AllBrands.Delete();
Boolean Found = AllBrands.ThisBrand.Find(PK);
Assert.IsFalse(Found);
}
public void TestAddMethod()
{
// create collection instance
clsBrandCollection AllBrands = new clsBrandCollection();
//create brand item
clsBrand Brand = new clsBrand();
// PK variable
Int32 PK = 0;
// set properties
Brand.BrandID = 1;
Brand.BrandName = "TestBrandInc";
Brand.TopProduct = 2;
Brand.LatestProduct = 2;
Brand.LastRestock = DateTime.Now.Date;
Brand.AvgPrice = 0.00;
Brand.IsListed = false;
// set ThisAddress to Brand object
AllBrands.ThisBrand = Brand;
//add record
PK = AllBrands.Add();
// set primary key
Brand.BrandID = PK;
// find the record
AllBrands.ThisBrand.Find(PK);
// test objects are equal
Assert.AreEqual(AllBrands.ThisBrand, Brand);
}
public void SetDetails(clsBrand prBrand)
{
_Brand = prBrand;
UpdateDisplay();
UpdateForm();
Show();
}
protected void Page_Load(object sender, EventArgs e)
{
clsBrand Brand = new clsBrand();
Brand = (clsBrand)Session["Brand"];
Response.Write(Brand.BrandName);
}
public void TestValidMethod()
{
clsBrand brand = new clsBrand();
String ErrorMsg = "";
ErrorMsg = brand.Valid(BrandName, TopProduct, LatestProduct, LastRestock);
}
protected void btnSubmit_Click(object sender, EventArgs e)
{
// create brand instance
clsBrand Brand = new clsBrand();
// retreive field values
string BrandName = tbName.Text;
string TopProduct = dropTop.SelectedValue;
string LatestProduct = dropLatest.SelectedValue;
string LastRestock = cdrRestock.SelectedDate.ToString();
// avgPrice property needs to be calculated from a mean of a brand's products
//store Brand in session object
// if valid passes
string ErrorMsg = "";
ErrorMsg = Brand.Valid(BrandName, TopProduct, LatestProduct, LastRestock);
if (ErrorMsg == "")
{
// capture brand id
Brand.BrandID = BrandID;
Brand.BrandName = BrandName;
Brand.TopProduct = int.Parse(TopProduct);
Brand.LatestProduct = int.Parse(LatestProduct);
Brand.LastRestock = Convert.ToDateTime(LastRestock);
Brand.IsListed = cbList.Checked;
// create a collection instance
clsBrandCollection BrandList = new clsBrandCollection();
//add
if (Brand.BrandID == -1)
{
// set ThisBrand
BrandList.ThisBrand = Brand;
// add record
BrandList.Add();
}
// otherwise we update
else
{
BrandList.ThisBrand.Find(BrandID);
// set ThisAddress
BrandList.ThisBrand = Brand;
// update
BrandList.Update();
}
// redirect back to list
Response.Redirect("BrandsList.aspx");
}
else
{
lblValidateError.Visible = true;
lblValidateError.Text = ErrorMsg;
}
}
public void InstanceOK()
{
clsBrand notABrand = new clsBrand();
Assert.IsNotNull(notABrand);
// test full constructor
Assert.IsNotNull(Brand);
}
protected override void OnNavigatedTo(NavigationEventArgs e)
{
base.OnNavigatedTo(e);
string lcBrandName;
if (NavigationContext.QueryString.TryGetValue("brand", out lcBrandName))
pgMain.SvcClient.GetBrandAsync(lcBrandName);
else // no suitable querystring -> new brand!
_Brand = new clsBrand();
}
public void PrimaryKeyOK()
{
// a brand obtains an ID when its added to DB (since the
// table header is denoted by the DB and not the middle layer
clsBrand Brand = new clsBrand();
Int32 TestData = 1395;
Brand.BrandID = TestData;
Assert.AreEqual(Brand.BrandID, TestData);
}
public void TestFindMethod()
{
clsBrand ABrand = new clsBrand();
Boolean Found = false;
Int32 Id = 1395;
Found = ABrand.Find(Id);
Assert.IsTrue(Found);
}
public void TestValidBrandNameMinLessOne()
{
clsBrand brand = new clsBrand();
String ErrorMsg = "";
// invoke Valid() with 1 character for BrandName
ErrorMsg = brand.Valid("", TopProduct, LatestProduct, LastRestock);
// Check the error message matches expected result (error)
Assert.AreEqual(ErrorMsg, "You must enter a brand name.<br />");
}
public void TestValidLastRestockMinLessOne()
{
clsBrand brand = new clsBrand();
String ErrorMsg = "";
string MinMinusOne = "30/12/2000";
ErrorMsg = brand.Valid(BrandName, TopProduct, LatestProduct, MinMinusOne);
Assert.AreEqual(ErrorMsg, "Please enter a more recent date (after 31-12-2000).<br />");
}
public void TestValidLastRestockMin()
{
clsBrand brand = new clsBrand();
String ErrorMsg = "";
string Min = "31/12/2000";
ErrorMsg = brand.Valid(BrandName, TopProduct, LatestProduct, Min);
// should accept min value
Assert.AreEqual(ErrorMsg, "");
}
public void TestValidLastRestockMinPlusOne()
{
clsBrand brand = new clsBrand();
String ErrorMsg = "";
string MinPlusOne = "01/01/2001";
ErrorMsg = brand.Valid(BrandName, TopProduct, LatestProduct, MinPlusOne);
Assert.AreEqual(ErrorMsg, "");
}
private void SvcClient_GetBrandCompleted(object sender, GetBrandCompletedEventArgs e)
{
try
{
_Brand = e.Result;
UpdateDisplay();
}
catch (Exception ex)
{
txbMessage.Text = ex.Message;
}
}
public void TestValidBrandNameMid()
{
clsBrand brand = new clsBrand();
String ErrorMsg = "";
// invoke Valid() with 1 character for BrandName
string mid = "this one is 25 chars(mid)";
ErrorMsg = brand.Valid(mid, TopProduct, LatestProduct, LastRestock);
// Check the error message matches expected result (no error)
Assert.AreEqual(ErrorMsg, "");
}
public void TestValidBrandNameMaxAddOne()
{
clsBrand brand = new clsBrand();
String ErrorMsg = "";
// invoke Valid() with 1 character for BrandName
string maxAddOne = "heres a str that should be exactly 51 characters...";
ErrorMsg = brand.Valid(maxAddOne, TopProduct, LatestProduct, LastRestock);
// Check the error message matches expected result (no error)
Assert.AreEqual(ErrorMsg, "Your brand name is too long. Must be fewer than 50 characters long.<br />");
}
public void TestIsListed()
{
// create default Brand, no properties set...
clsBrand notABrand = new clsBrand();
// also create test data, and assign test data to global Brand
bool TestData = true;
Brand.IsListed = TestData;
// test global Brand
Assert.AreEqual(Brand.IsListed, TestData);
//also test notABRand
Assert.AreEqual(notABrand.IsListed, false);
}
public void TestValidBrandNameMax()
{
clsBrand brand = new clsBrand();
String ErrorMsg = "";
// invoke Valid() with 1 character for BrandName
string max = "heres a str that should be exactly 50 characters..";
ErrorMsg = brand.Valid(max, TopProduct, LatestProduct, LastRestock);
// Check the error message matches expected result (no error)
Assert.AreEqual(ErrorMsg, "");
}
public void TestLastRestockFound()
{
clsBrand ABrand = new clsBrand();
Boolean Found = false;
Boolean OK = true;
Int32 Id = 1395;
Found = ABrand.Find(Id);
if (ABrand.LastRestock != Convert.ToDateTime("06/05/2021"))
{
OK = false;
}
Assert.IsTrue(OK);
}
public void TestLatestProductFound()
{
clsBrand ABrand = new clsBrand();
Boolean Found = false;
Boolean OK = true;
Int32 Id = 1395;
Found = ABrand.Find(Id);
if (ABrand.LatestProduct != 2)
{
OK = false;
}
Assert.IsTrue(OK);
}
public void TestIsListedFound()
{
clsBrand ABrand = new clsBrand();
Boolean Found = false;
Boolean OK = true;
Int32 Id = 1395;
Found = ABrand.Find(Id);
if (ABrand.IsListed != false)
{
OK = false;
}
Assert.IsTrue(OK);
}
public void TestValidLastRestockMaxPlusOne()
{
clsBrand brand = new clsBrand();
String ErrorMsg = "";
DateTime TestDate = DateTime.Today.AddDays(1); // tomorrow
string MaxPlusOne = TestDate.ToString();
ErrorMsg = brand.Valid(BrandName, TopProduct, LatestProduct, MaxPlusOne);
// Error message expected
Assert.AreEqual(ErrorMsg, "Date cannot be in the future.<br />");
}
public void TestValidLastRestockExtremeMax()
{
clsBrand brand = new clsBrand();
String ErrorMsg = "";
DateTime TestDate = DateTime.Today.AddYears(50); // extreme test data
string ExtremeMax = TestDate.ToString();
ErrorMsg = brand.Valid(BrandName, TopProduct, LatestProduct, ExtremeMax);
// Error message expected
Assert.AreEqual(ErrorMsg, "Date cannot be in the future.<br />");
}
public void TestValidLastRestockMaxLessOne()
{
clsBrand brand = new clsBrand();
String ErrorMsg = "";
DateTime TestDate = DateTime.Today.AddDays(-1); // yesterday
string MaxLessOne = TestDate.ToString();
ErrorMsg = brand.Valid(BrandName, TopProduct, LatestProduct, MaxLessOne);
// no error msg
Assert.AreEqual(ErrorMsg, "");
}
public void TestValidLastRestockMax()
{
clsBrand brand = new clsBrand();
String ErrorMsg = "";
DateTime TestDate = DateTime.Today; // today
string Max = TestDate.ToString();
ErrorMsg = brand.Valid(BrandName, TopProduct, LatestProduct, Max);
// no error msg
Assert.AreEqual(ErrorMsg, "");
}
public void TestBrandNameFound()
{
clsBrand ABrand = new clsBrand();
Boolean Found = false;
Boolean OK = true;
Int32 Id = 1395;
Found = ABrand.Find(Id);
if (ABrand.BrandName != "TestBrandInc")
{
OK = false;
}
Assert.IsTrue(OK);
}
public void TestAvgPriceFound()
{
clsBrand ABrand = new clsBrand();
Boolean Found = false;
Boolean OK = true;
Int32 Id = 3;
Found = ABrand.Find(Id);
if (ABrand.AvgPrice != 0.00)
{
OK = false;
}
Assert.IsTrue(OK);
}
public void TestValidLastRestockExtremeMin()
{
clsBrand brand = new clsBrand();
String ErrorMsg = "";
DateTime TestDate = DateTime.Today.AddYears(-50);
string ExtremeMin = TestDate.ToString();
ErrorMsg = brand.Valid(BrandName, TopProduct, LatestProduct, ExtremeMin);
Assert.AreEqual(ErrorMsg, "Please enter a more recent date (after 31-12-2000).<br />");
}
public static List <clsBrand> EditData(clsBrand Obj)
{
List <clsBrand> details = new List <clsBrand>();
DataTable dt = new DataTable();
SqlParameter[] p = new SqlParameter[1];
p[0] = new SqlParameter("@BrandID", Obj.BrandID);
dt = clsCURD.GetData("[IMIS_ProBrandSelectByID]", p);
foreach (DataRow dtrow in dt.Rows)
{
clsBrand obj = new clsBrand();
obj.BrandID = int.Parse(dtrow["BrandID"].ToString());
obj.BrandName = dtrow["BrandName"].ToString();
details.Add(obj);
}
return(details);
}
public void TestValidBrandNameExtremeMax()
{
clsBrand brand = new clsBrand();
String ErrorMsg = "";
// invoke Valid() with 1 character for BrandName
string extremeMax = "Extreme Max String (200) Extreme Max String (200) Extreme Max String (200) " +
"Extreme Max String (200) Extreme Max String (200) Extreme Max String (200) Extreme Max String (200) " +
"Extreme Max String (200) ";
ErrorMsg = brand.Valid(extremeMax, TopProduct, LatestProduct, LastRestock);
// Check the error message matches expected result (no error)
Assert.AreEqual(ErrorMsg, "Your brand name is too long. Must be fewer than 50 characters long.<br />");
}
public static void Insert(clsBrand Obj)
{
try
{
SqlParameter[] p = new SqlParameter[2];
p[0] = new SqlParameter("@BrandName", Obj.BrandName);
p[1] = new SqlParameter("@UserID", Obj.UserID);
clsCURD.ExecuteStoreProcedure("IMIS_ProBrandInsert", p);
}
catch (SqlException Sexp)
{
}
catch (Exception ex)
{
}
finally
{
}
}
public static void Update(clsBrand Obj)
{
try
{
SqlParameter[] p = new SqlParameter[3];
p[0] = new SqlParameter("@BrandName", Obj.BrandName);
p[1] = new SqlParameter("@BrandID", Obj.BrandID);
p[2] = new SqlParameter("@LastUpdatedBy", Obj.LastUpdatedBy);
clsCURD.ExecuteStoreProcedure("IMIS_ProBrandUpdate", p);
}
catch (SqlException Sexp)
{
}
catch (Exception ex)
{
}
finally
{
}
}
