protected void Application_Start()
{
AreaRegistration.RegisterAllAreas();
FilterConfig.RegisterGlobalFilters(GlobalFilters.Filters);
RouteConfig.RegisterRoutes(RouteTable.Routes);
BundleConfig.RegisterBundles(BundleTable.Bundles);
NinjectModule clientModule = new ClientModule();
NinjectModule usertModule = new UserModule();
NinjectModule categoryModule = new CategoryModule();
NinjectModule priceCategoryModule = new PriceCategoryModule();
NinjectModule roomModule = new RoomModule();
NinjectModule reservationModule = new ReservationModule();
NinjectModule dependencyModule = new DependencyModule("HotelModel");
var kernel = new StandardKernel(dependencyModule, usertModule, clientModule,
categoryModule, priceCategoryModule, roomModule, reservationModule);
DependencyResolver.SetResolver(new NinjectDependencyResolver(kernel));
ControllerBuilder.Current.SetControllerFactory(new NinjectControllerFactory(kernel));
//var kernel = new StandardKernel(clientModule, usertModule, categoryModule,
// priceCategoryModule, roomModule, reservationModule, dependencyModule);
//kernel.Bind<DefaultFilterProviders>().ToSelf().WithConstructorArgument(GlobalConfiguration.Configuration.Services.GetFilterProviders());
//kernel.Bind<DefaultModelValidatorProviders>().ToConstant(new DefaultModelValidatorProviders(GlobalConfiguration.Configuration.Services.GetModelValidatorProviders()));
//GlobalConfiguration.Configuration.DependencyResolver = new Ninject.Web.WebApi.NinjectDependencyResolver(kernel);
}
public IHttpActionResult GetProductPrice(int id)
{
try
{
return(Ok(CategoryModule.GetAllSubCategory(id)));
}
catch (Exception)
{
return(InternalServerError());
}
}
protected void Application_Start()
{
AreaRegistration.RegisterAllAreas();
FilterConfig.RegisterGlobalFilters(GlobalFilters.Filters);
RouteConfig.RegisterRoutes(RouteTable.Routes);
BundleConfig.RegisterBundles(BundleTable.Bundles);
NinjectModule categoryModule = new CategoryModule();
NinjectModule serviceModule = new ServiceModule("1");
var kernel = new StandardKernel(categoryModule, serviceModule);
DependencyResolver.SetResolver(new NinjectDependencyResolver(kernel));
}
protected void Application_Start()
{
AreaRegistration.RegisterAllAreas();
GlobalConfiguration.Configure(WebApiConfig.Register);
FilterConfig.RegisterGlobalFilters(GlobalFilters.Filters);
RouteConfig.RegisterRoutes(RouteTable.Routes);
BundleConfig.RegisterBundles(BundleTable.Bundles);
NinjectModule categoryModule = new CategoryModule();
NinjectModule lotModule = new LotModule();
NinjectModule serviceModule = new ServiceModule("DefaultConnection");
var kernel = new StandardKernel(categoryModule, lotModule, serviceModule);
GlobalConfiguration.Configuration.DependencyResolver = new NinjectResolver(kernel);
}
protected void Application_Start()
{
AreaRegistration.RegisterAllAreas();
FilterConfig.RegisterGlobalFilters(GlobalFilters.Filters);
RouteConfig.RegisterRoutes(RouteTable.Routes);
BundleConfig.RegisterBundles(BundleTable.Bundles);
// dependency injection
NinjectModule bookModule = new BookModule();
NinjectModule categoryModule = new CategoryModule();
NinjectModule serviceModule = new ServiceModule();
var kernel = new Ninject.StandardKernel(bookModule, categoryModule, serviceModule);
//you just unbind ninject validator and there should be no collision with default validator.
kernel.Unbind <ModelValidatorProvider>();
DependencyResolver.SetResolver(new Ninject.Web.Mvc.NinjectDependencyResolver(kernel));
}
protected void Application_Start()
{
AreaRegistration.RegisterAllAreas();
GlobalConfiguration.Configure(WebApiConfig.Register);
FilterConfig.RegisterGlobalFilters(GlobalFilters.Filters);
RouteConfig.RegisterRoutes(RouteTable.Routes);
BundleConfig.RegisterBundles(BundleTable.Bundles);
NinjectModule guestModule = new GuestModule();
NinjectModule roomModule = new RoomModule();
NinjectModule categoryModule = new CategoryModule();
NinjectModule bookingModule = new BookingModule();
NinjectModule dependencyModule = new DependencyModule("HotelModel");
var kernel = new StandardKernel(guestModule, roomModule, categoryModule, bookingModule, dependencyModule);
kernel.Bind <DefaultFilterProviders>().ToSelf().WithConstructorArgument(GlobalConfiguration.Configuration.Services.GetFilterProviders());
kernel.Bind <DefaultModelValidatorProviders>().ToConstant(new DefaultModelValidatorProviders(GlobalConfiguration.Configuration.Services.GetModelValidatorProviders()));
GlobalConfiguration.Configuration.DependencyResolver = new Ninject.Web.WebApi.NinjectDependencyResolver(kernel);
}
public CategoryRepository()
{
_dateCategoryModule = new CategoryModule();
_allCateData = new Dictionary <string, List <FrontCategoryInfo> >();
}
public CustomController()
{
// List<CustomersModule> customerlist = new List<CustomersModule>();
IList <CustomersModule> customerlist = new List <CustomersModule>();
IList <Staff> stafflist = new List <Staff>();
IList <ProjectModule> projectlist = new List <ProjectModule>();
IList <ProjectModule> projectlist2 = new List <ProjectModule>();
IList <TaskManModule> taskmode = new List <TaskManModule>();
IList <CategoryModule> categorylist = new List <CategoryModule>();
IList <TaskManModule> tasklist = new List <TaskManModule>();
IList <TaskManModule> timesheet = new List <TaskManModule>();
IList <TaskManModule> taskplanner = new List <TaskManModule>();
string conString = ConfigurationManager.ConnectionStrings["myConnectionString"].ConnectionString;
using (SqlConnection con = new SqlConnection(conString))
{
con.Open();
//-------------------------------
string query = "Select * from [dbo].[customers]";
SqlCommand cmd = new SqlCommand(query, con);
SqlDataReader dataReader = cmd.ExecuteReader();
while (dataReader.Read())
{
CustomersModule sitems = new CustomersModule();
sitems.id = Convert.ToString(dataReader["id"]);
sitems.name = Convert.ToString(dataReader["name"]);
sitems.code = Convert.ToString(dataReader["code"]);
customerlist.Add(sitems);
}
// sitems.File_file = termsList.ToArray();
//-------------------------------
query = "Select * from [dbo].[staff]";
SqlCommand cmd2 = new SqlCommand(query, con);
SqlDataReader dataReader2 = cmd2.ExecuteReader();
while (dataReader2.Read())
{
Staff sitems = new Staff();
sitems.id = Convert.ToString(dataReader2["id"]);
sitems.fullname = Convert.ToString(dataReader2["fullname"]) + " " + Convert.ToString(dataReader2["lastname"]);
sitems.alias = Convert.ToString(dataReader2["alias"]);
stafflist.Add(sitems);
}
//-------------------------------
query = "Select * from [dbo].[project]";
SqlCommand cmd3 = new SqlCommand(query, con);
SqlDataReader dataReader3 = cmd3.ExecuteReader();
while (dataReader3.Read())
{
ProjectModule sitems = new ProjectModule();
sitems.id = Convert.ToString(dataReader3["id"]);
sitems.name = Convert.ToString(dataReader3["name"]);
sitems.code = Convert.ToString(dataReader3["code"]);
sitems.custid = Convert.ToString(dataReader3["custid"]);
projectlist.Add(sitems);
}
//------------------------------------------------
//string query2 = "Select * from [dbo].[project] WHERE custid=" + Request.QueryString["customerid"].ToString();
//SqlCommand cmd9 = new SqlCommand(query2, con);
//SqlDataReader dataReader9 = cmd9.ExecuteReader();
//while (dataReader9.Read())
//{
// ProjectModule sitems = new ProjectModule();
// sitems.id = Convert.ToString(dataReader9["id"]);
// sitems.name = Convert.ToString(dataReader9["name"]);
// sitems.code = Convert.ToString(dataReader9["code"]);
// sitems.custid = Convert.ToString(dataReader9["custid"]);
// projectlist2.Add(sitems);
//}
//-------------------------------
query = "Select id, description from [dbo].[taskman]";
SqlCommand cmd5 = new SqlCommand(query, con);
SqlDataReader dataReader5 = cmd5.ExecuteReader();
while (dataReader5.Read())
{
TaskManModule sitems = new TaskManModule();
sitems.id = Convert.ToInt16(dataReader5["id"]);
sitems.description = Convert.ToString(dataReader5["description"]);
tasklist.Add(sitems);
}
query = "Select id, projectid, status, code, name, description, datecreated from [dbo].[categories]";
SqlCommand cmd6 = new SqlCommand(query, con);
SqlDataReader dataReader6 = cmd6.ExecuteReader();
while (dataReader6.Read())
{
CategoryModule cat = new CategoryModule();
cat.id = Convert.ToInt16(dataReader6["id"].ToString());
cat.projectid = Convert.ToInt16(dataReader6["projectid"].ToString());
cat.code = Convert.ToString(dataReader6["code"]);
cat.name = Convert.ToString(dataReader6["name"]);
cat.description = Convert.ToString(dataReader6["description"]);
cat.status = Convert.ToString(dataReader6["status"]);
cat.datecreated = Convert.ToDateTime(dataReader6["datecreated"]);
categorylist.Add(cat);
}
//--------------------------------------------------------------------------------
query = " SELECT T.id as id, C.code as cust,P.code as proj, T.description as descr, T.dev as dev, T.note as note, (Select fullname from[timesheet].[dbo].[staff] where id = T.resource) as resc, T.pr as pr,T.start as start,T.finish as finish, T.stat as stat, T.esthours as est,T.ddate as ddate from[timesheet].[dbo].[taskman] as T,[timesheet].[dbo].[customers] as C,[timesheet].[dbo].[project] as P,[timesheet].[dbo].[staff] as S WHERE C.id=T.customerid AND P.id=T.projectid AND T.resource=S.id ORDER BY T.id DESC";
SqlCommand cmd4 = new SqlCommand(query, con);
SqlDataReader dataReader4 = cmd4.ExecuteReader();
if (dataReader4.HasRows)
{
while (dataReader4.Read())
{
TaskManModule sitems = new TaskManModule();
sitems.id = Convert.ToInt16(dataReader4["id"]);
sitems.cust = Convert.ToString(dataReader4["cust"]);
sitems.proj = Convert.ToString(dataReader4["proj"]);
sitems.description = Convert.ToString(dataReader4["descr"]);
taskmode.Add(sitems);
}
}
else
{
TaskManModule sitems = new TaskManModule();
sitems.id = Convert.ToInt16("0");
sitems.cust = Convert.ToString("no");
sitems.proj = Convert.ToString("no");
sitems.description = Convert.ToString("no");
taskmode.Add(sitems);
}
string queryday = "Select * from [dbo].[tasklist]";
SqlCommand cmdd = new SqlCommand(queryday, con);
SqlDataReader dataReaderd = cmdd.ExecuteReader();
while (dataReaderd.Read())
{
TaskManModule sitems = new TaskManModule();
string edate = Convert.ToString(dataReaderd["edate"]);
sitems.ddate = String.Format("{0:MM/dd/yyyy}", edate);
timesheet.Add(sitems);
}
con.Close();
}
// Now store it in your model
ViewData["CustomerList"] = customerlist;
ViewData["CustomerList2"] = customerlist;
ViewData["StaffList"] = stafflist;
ViewData["ProjectList"] = projectlist;
// ViewData["ProjectList2"] = projectlist2;
ViewData["Taskman"] = taskmode;
ViewData["CategoryList"] = categorylist;
ViewData["TaskList"] = tasklist;
ViewData["SystemDate"] = DateTime.Now.ToString("MM/dd/yyyy");
ViewData["dataDates"] = timesheet;
// date range -------------- here
DayOfWeek firstWeekDay = System.Globalization.CultureInfo.CurrentCulture.DateTimeFormat.FirstDayOfWeek;
DateTime startDateOfWeek = DateTime.Now;
while (startDateOfWeek.DayOfWeek != firstWeekDay)
{
startDateOfWeek = startDateOfWeek.AddDays(-1d);
}
DateTime endDateOfWeek = startDateOfWeek.AddDays(6d);
//return checkDate >= startDateOfWeek && checkDate <= endDateOfWeek;
ViewData["begin"] = startDateOfWeek.ToString("MM/dd/yyyy");
ViewData["end"] = endDateOfWeek.ToString("MM/dd/yyyy");
// end of date range
}
public CategoryDetails GetCategoryById(int id)
{
return(CategoryModule.GetCategoryDetailsById(id));
}
public List <CATEGORIES_DTO> GetAllCategories()
{
return(CategoryModule.GetAllCategories());
}