public void ColumnDisplayData()
{
TVViewModel v = GenerateNewViewModel_DatabaseWithOneSchemaOneTableTwoColumnTestLoader();
List <ColumnDisplayData> data = v.ColumnDisplayData;
Assert.IsNotNull(data);
Assert.AreEqual(2, data.Count);
ColumnDisplayData c1 = data[0];
Assert.AreEqual("Column.aspx?conn=CONN ID&sch=DatabaseWithOneSchemaOneTableTwoColumnTestLoader SCHEMA ID" +
"&tv=DatabaseWithOneSchemaOneTableTwoColumnTestLoader TV ID" +
"&col=DatabaseWithOneSchemaOneTableTwoColumnTestLoader COLUMN1 ID", c1.ColumnLink);
Assert.AreEqual("DatabaseWithOneSchemaOneTableTwoColumnTestLoader COLUMN1 NAME", c1.ColumnName);
Assert.AreEqual("int", c1.ColumnTypeName);
Assert.AreEqual("Req'd", c1.Nullability);
Assert.AreEqual("PK", c1.PK);
c1 = null; //Prevent copy paste errors when asserting on another column
ColumnDisplayData c2 = data[1];
Assert.AreEqual("Column.aspx?conn=CONN ID&sch=DatabaseWithOneSchemaOneTableTwoColumnTestLoader SCHEMA ID" +
"&tv=DatabaseWithOneSchemaOneTableTwoColumnTestLoader TV ID" +
"&col=DatabaseWithOneSchemaOneTableTwoColumnTestLoader COLUMN2 ID", c2.ColumnLink);
Assert.AreEqual("DatabaseWithOneSchemaOneTableTwoColumnTestLoader COLUMN2 NAME", c2.ColumnName);
Assert.AreEqual("varchar(50)", c2.ColumnTypeName);
Assert.AreEqual("Null", c2.Nullability);
Assert.IsTrue(String.IsNullOrEmpty(c2.PK));
}
public void ColumnDisplayData_DatabaseWithOneSchemaOneTableTestLoader()
{
TVViewModel v = GenerateNewViewModel_DatabaseWithOneSchemaOneTableTestLoader();
List <ColumnDisplayData> data = v.ColumnDisplayData;
Assert.IsNotNull(data);
Assert.AreEqual(0, data.Count);
}
protected void Page_Load(object sender, EventArgs e)
{
vm = new TVViewModel(GetMetaLoader(), conn_id, schema_id, tableview_id);
if (!IsPostBack)
{
reload();
}
}
// GET: TV
public ActionResult Index()
{
TVViewModel mymodel = new TVViewModel(); //to add more than 1 models in view
mymodel.TV = getNew();
mymodel.Genres = getGenreList();
return(View(mymodel));
}
public ActionResult UpdateTVCust(TVViewModel tvVM)
{
var mapper = new MapperConfiguration(cfg => cfg.CreateMap <TVViewModel, TVDTO>()).CreateMapper();
TVDTO tvDto = mapper.Map <TVViewModel, TVDTO>(tvVM);
service.UpdateTV(tvDto);
return(View("Index"));
}
public ActionResult GetTV(int tvIdDto)
{
TVDTO tvDTO = service.GetTV(tvIdDto);
var mapper = new MapperConfiguration(cfg => cfg.CreateMap <TVDTO, TVViewModel>()).CreateMapper();
TVViewModel tvVM = mapper.Map <TVDTO, TVViewModel>(tvDTO);
var mapper1 = new MapperConfiguration(cfg => cfg.CreateMap <ImageDTO, Image>()).CreateMapper();
IEnumerable <Image> images = mapper1.Map <IEnumerable <ImageDTO>, IEnumerable <Image> >(service.GetImages());
tvVM.Images.AddRange(images.Where(i => i.ProductId == tvVM.Id));
var mapper2 = new MapperConfiguration(cfg => cfg.CreateMap <OrderSellerDTO, OrderSeller>()).CreateMapper();
OrderSeller seller = mapper2.Map <OrderSellerDTO, OrderSeller>(service.GetOrderSeller(tvVM.OrderSellerId));
tvVM.OrderSeller = seller;
return(View(tvVM));
}
public ActionResult Title()
{
string TVID;
try
{
TVID = Url.RequestContext.RouteData.Values["id"].ToString();
TVViewModel mymodel = new TVViewModel(); //to add more than 1 models in view
mymodel.Title = getTitle(TVID);
mymodel.Credit = getCredit(TVID);
mymodel.Video = getVideo(TVID);
mymodel.Image = getImage(TVID);
mymodel.Similar = getSimilar(TVID);
mymodel.Review = getReview(TVID);
return(View(mymodel));
}
catch (Exception)
{
return(View());
}
}
public void TVTypeName()
{
TVViewModel v = GenerateNewViewModel_DatabaseWithOneSchemaOneTableTwoColumnTestLoader();
Assert.AreEqual("Table", v.TVTypeName);
}
public void ColumnId()
{
TVViewModel v = GenerateNewViewModel_DatabaseWithOneSchemaOneTableTwoColumnTestLoader();
Assert.IsTrue(String.IsNullOrEmpty(v.ColumnId));
}
public void TVId()
{
TVViewModel v = GenerateNewViewModel_DatabaseWithOneSchemaOneTableTwoColumnTestLoader();
Assert.AreEqual("DatabaseWithOneSchemaOneTableTwoColumnTestLoader TV ID", v.TVId);
}
public void ColumnDisplayData_DatabaseWithNoSchemasTestLoader()
{
TVViewModel v = GenerateNewViewModel_DatabaseWithNoSchemasTestLoader();
List <ColumnDisplayData> data = v.ColumnDisplayData; //No schemas, so this blows up
}
public TVPage()
{
InitializeComponent();
BindingContext = viewModel = new TVViewModel();
}
public ActionResult CreateOrderCustomer(OrderCustomerViewModel customerVM)
{
if (ModelState.IsValid)
{
var mapper = new MapperConfiguration(cfg => cfg.CreateMap <OrderCustomerViewModel,
OrderCustomerDTO>()).CreateMapper();
OrderCustomerDTO customerDto = mapper.Map <OrderCustomerViewModel, OrderCustomerDTO>(customerVM);
service.CreateOrderCustomer(customerDto);
string category = service.GetProduct(customerVM.ProdId);
if (category == "Phone")
{
PhoneDTO phoneDTO = service.GetPhone(customerVM.ProdId);
if (phoneDTO.QtyEnd == 0)
{
return(View("ProductEnded"));
}
phoneDTO.QtyEnd--;
phoneDTO.PriceNow = Price(phoneDTO.PriceStart, phoneDTO.PriceEnd, phoneDTO.QtyEnd);
var mapper1 = new MapperConfiguration(cfg => cfg.CreateMap <PhoneDTO,
PhoneViewModel>()).CreateMapper();
PhoneViewModel phoneVM = mapper1.Map <PhoneDTO, PhoneViewModel>(phoneDTO);
return(View("ThanksPagePhone", phoneVM));
}
if (category == "TV")
{
TVDTO tvDTO = service.GetTV(customerVM.ProdId);
if (tvDTO.QtyEnd == 0)
{
return(View("ProductEnded"));
}
tvDTO.QtyEnd--;
tvDTO.PriceNow = Price(tvDTO.PriceStart, tvDTO.PriceEnd, tvDTO.QtyEnd);
var mapper1 = new MapperConfiguration(cfg => cfg.CreateMap <TVDTO,
TVViewModel>()).CreateMapper();
TVViewModel tvVM = mapper1.Map <TVDTO, TVViewModel>(tvDTO);
return(View("ThanksPageTV", tvVM));
}
if (category == "Laptop")
{
LaptopDTO laptopDTO = service.GetLaptop(customerVM.ProdId);
if (laptopDTO.QtyEnd == 0)
{
return(View("ProductEnded"));
}
laptopDTO.QtyEnd--;
laptopDTO.PriceNow = Price(laptopDTO.PriceStart, laptopDTO.PriceEnd, laptopDTO.QtyEnd);
var mapper1 = new MapperConfiguration(cfg => cfg.CreateMap <LaptopDTO,
LaptopViewModel>()).CreateMapper();
LaptopViewModel laptopVM = mapper1.Map <LaptopDTO, LaptopViewModel>(laptopDTO);
return(View("ThanksPageLaptop", laptopVM));
}
return(View("ThanksPagePhone"));
}
return(View("ThanksPagePhone"));
}
public StartTVCommand(TVViewModel viewModel)
{
_viewModel = viewModel;
}
public TVView()
{
InitializeComponent();
DataContext = new TVViewModel(this);
}
