public ActionResult AboutUs() { List <CustomerMessage> customer = new List <CustomerMessage>(); PDBC db = new PDBC("DBConnectionString", true); db.Connect(); DataTable dt = db.Select( "SELECT [name],[Job],[message],[star],[ImagePath],[ImageValue]FROM [TSHP_PortalCMS].[dbo].[CustomersMessge_tbl]"); for (int i = 0; i < dt.Rows.Count; i++) { var cust = new CustomerMessage() { Name = dt.Rows[i]["name"].ToString(), Job = dt.Rows[i]["Job"].ToString(), Message = dt.Rows[i]["message"].ToString(), Stars = (int)dt.Rows[i]["star"] }; customer.Add(cust); } List <TeamMembers> members = new List <TeamMembers>(); DataTable dt2 = db.Select( "SELECT[Name],[Job],[Tozihat],[github],[Linkedin],[Instagram],[ImagePath],[ImageValue]FROM [TSHP_PortalCMS].[dbo].[TeamMembers_tbl]"); for (int i = 0; i < dt2.Rows.Count; i++) { var member = new TeamMembers() { name = dt2.Rows[i]["Name"].ToString(), Job = dt2.Rows[i]["Job"].ToString(), Tozihat = dt2.Rows[i]["Tozihat"].ToString(), Github = dt2.Rows[i]["github"].ToString(), linkedin = dt2.Rows[i]["Linkedin"].ToString(), Instagram = dt2.Rows[i]["Instagram"].ToString(), ImagePath = dt2.Rows[i]["ImagePath"].ToString(), // ImageValue = dt2.Rows[i]["ImageValue"].ToString() }; members.Add(member); } var About__Us = new AboutUsModelView() { customerMessages = customer, teamMemberses = members }; return(View(About__Us)); }
public ActionResult AboutUs() { D_APIModelFiller DMF = new D_APIModelFiller(); var model = new AboutUsModelView() { CompanyCustomers = DMF.CompanyCustomers(), TeamMembers = DMF.TeamMembers() }; return(View(model)); }
public ActionResult AboutUs() { CustomerModelFiller modelFiller = new CustomerModelFiller(); var ModelView = new AboutUsModelView() { CustomerMessages = modelFiller.CompanyCustomers(), TeamMembers = modelFiller.TeamMembers() }; return(View(ModelView)); }