public void Setup()
{
injector = new RobotlegsInjector();
injector.Map(typeof(RobotlegsInjector)).ToValue(injector);
viewProcessorMap = new ViewProcessorMap(new ViewProcessorFactory(injector));
trackingProcessor = new TrackingProcessor();
trackingProcessor2 = new TrackingProcessor();
matchingView = new SupportView();
nonMatchingView = new ObjectB();
guardObject = new GuardObject();
matchingView2 = new SupportViewWithWidthAndHeight();
}
public void Setup()
{
injector = new RobotlegsInjector();
injector.Map(typeof(RobotlegsInjector)).ToValue(injector);
viewProcessorMap = new ViewProcessorMap(new ViewProcessorFactory(injector));
trackingProcessor = new TrackingProcessor();
trackingProcessor2 = new TrackingProcessor();
matchingView = new SupportView();
nonMatchingView = new ObjectB();
guardObject = new GuardObject();
matchingView2 = new SupportViewWithWidthAndHeight();
}
public bool Activate(GuardObject guard)
{
SqlParameter[] params_ = new SqlParameter[] {
new SqlParameter("@id", guard.Id),
new SqlParameter("@Code", guard.code),
new SqlParameter("@IP", Helpers.CustomHelper.GetLocalIPAddress()),
new SqlParameter("@MAC", Helpers.CustomHelper.GetMACAddress()),
new SqlParameter("@DateAdded", DateTime.Now),
new SqlParameter("@AddedBy", Convert.ToInt32(HttpContext.Current.Session["userId_local"])),
new SqlParameter("@table", "tblUsers"),
new SqlParameter("@Module", "GUARD")
};
return(Library.ConnectionString.returnCon.executeQuery("spActivateItem", params_, CommandType.StoredProcedure));
}
public bool Add(GuardObject guard)
{
SqlParameter[] params_ = new SqlParameter[] {
new SqlParameter("@username", guard.username),
new SqlParameter("@password", guard.password),
new SqlParameter("@givenname", guard.givenName),
new SqlParameter("@lastname", guard.lastName),
new SqlParameter("@IP", Helpers.CustomHelper.GetLocalIPAddress()),
new SqlParameter("@MAC", Helpers.CustomHelper.GetMACAddress()),
new SqlParameter("@DateAdded", DateTime.Now),
new SqlParameter("@AddedBy", Convert.ToInt32(HttpContext.Current.Session["userId_local"]))
};
return(Library.ConnectionString.returnCon.executeQuery("spAddGuardProfile", params_, CommandType.StoredProcedure));
}
//desc : inactive department record | date : 06/06/2017 | author : avillena | version :1.0
public bool Activate(GuardObject department)
{
var @params = new SqlParameter[] {
new SqlParameter(parameterName: "@id", value: department.Id),
new SqlParameter(parameterName: "@Code", value: department.code),
new SqlParameter(parameterName: "@IP", value: Helpers.CustomHelper.GetLocalIPAddress()),
new SqlParameter(parameterName: "@MAC", value: Helpers.CustomHelper.GetMACAddress()),
new SqlParameter(parameterName: "@DateAdded", value: DateTime.Now),
new SqlParameter(parameterName: "@AddedBy", value: Convert.ToInt32(HttpContext.Current.Session["userId_local"])),
new SqlParameter(parameterName: "@table", value: "tblDepartments"),
new SqlParameter(parameterName: "@Module", value: "Department")
};
return(Library.ConnectionString.returnCon.executeQuery(strQuery: "spActivateDepartmentList", params_: @params, type_: CommandType.StoredProcedure));
}
//desc : adding of new department record | date : 06/06/2017 | author : avillena | version :1.0
public bool Add(GuardObject department)
{
var @params = new SqlParameter[] {
new SqlParameter(parameterName: "@departmentname", value: department.deptname),
new SqlParameter(parameterName: "@description", value: department.description),
new SqlParameter(parameterName: "@IsActive", value: true),
new SqlParameter(parameterName: "@Source", value: "Manual"),
new SqlParameter(parameterName: "@IP", value: Helpers.CustomHelper.GetLocalIPAddress()),
new SqlParameter(parameterName: "@MAC", value: Helpers.CustomHelper.GetMACAddress()),
new SqlParameter(parameterName: "@DateAdded", value: DateTime.Now),
new SqlParameter(parameterName: "@AddedBy", value: Convert.ToInt32(HttpContext.Current.Session["userId_local"]))
};
return(Library.ConnectionString.returnCon.executeQuery(strQuery: "spAddNewDepartment", params_: @params, type_: CommandType.StoredProcedure));
}
//desc : deactive department record | date : 06/06/2017 | author : avillena | version :1.0
public bool Deactivate(GuardObject department)
{
SqlParameter[] params_ = new SqlParameter[] {
new SqlParameter(parameterName: "@id", value: department.Id),
new SqlParameter(parameterName: "@Code", value: department.code),
new SqlParameter(parameterName: "@IsActive", value: department.IsActive),
new SqlParameter(parameterName: "@table", value: "tblDepartments"),
new SqlParameter(parameterName: "@AddedBy", value: department.AddedBy),
new SqlParameter(parameterName: "@DateAdded", value: department.DateAdded),
new SqlParameter(parameterName: "@Module", value: "DEPARTMENT"),
new SqlParameter(parameterName: "@IP", value: Helpers.CustomHelper.GetLocalIPAddress()),
new SqlParameter(parameterName: "@MAC", value: Helpers.CustomHelper.GetMACAddress())
};
return(Library.ConnectionString.returnCon.executeQuery(strQuery: "spDeactivateDepartmentList", params_: params_, type_: CommandType.StoredProcedure));
}
