public ActionResult Register()
{
SLW_DatabaseInfo db = new SLW_DatabaseInfo();
List <ClientCompany> companies = db.GetClientDetails("");
return(View(companies));
}
public HttpResponseMessage ForTypeApprovals([FromBody] Message message)
{
SLW_DatabaseInfo db = new SLW_DatabaseInfo();
db.NotifySpecific(message.message, message.target_user, Constants.notifyTypeApproval);
return(Request.CreateResponse(HttpStatusCode.OK, ""));
}
public HttpResponseMessage NewOngoingTask([FromBody] dynamic data)
{
SLW_DatabaseInfo db = new SLW_DatabaseInfo();
KeyDetail detail = db.GetKeyDetail((string)data.access_key);
if (detail.data_present)
{
UnassignedTask unassigned = db.GetSingleUnassignedTask((string)data.application_id);
db.DeleteUnassignedTask((string)data.application_id);
UserDetails userDetailsAdmin = db.GetUserDetails(detail.username);
db.NewOngoingTask((string)data.application_id, (string)data.assigned_to, unassigned.username, (string)data.status, unassigned.created_date_raw, userDetailsAdmin.fullname, userDetailsAdmin.username);
db.UpdateApplicationStatus((string)data.application_id, Commons.Constants.PENDING_TYPE, DateTime.Now);
OngoingTask ongoing = db.GetSingleOngoingTask((string)data.application_id);
UserDetails userDetails = db.GetUserDetails(ongoing.assigned_to);
ongoing.assigned_to = userDetails.fullname;
db.SaveActivity(new UserActivity(detail.username, Commons.Constants.ACTIVITY_NEW_ONGOING, (string)data.application_id, (string)data.assigned_to, 1));
Form form = db.GetApplication((string)data.application_id);
Email.Send(userDetails.email, "New Type Approval Application", "Type approval application " + form.application_id + " for Device with Model number " + form.product_identification + " from " + ongoing.submitted_by + " is assigned to you for processing.");
return(Request.CreateResponse(HttpStatusCode.OK, ongoing));
}
else
{
return(Request.CreateResponse(HttpStatusCode.Forbidden, "invalid key"));
}
}
public HttpResponseMessage TypeApprovalDetails([FromUri] string Dealer = "", [FromUri] string Model = "", [FromUri] string make = "", [FromUri] string remarks = "")
{
SLW_DatabaseInfo db = new SLW_DatabaseInfo();
if (Dealer == null)
{
Dealer = "";
}
if (Model == null)
{
Model = "";
}
if (make == null)
{
make = "";
}
if (remarks == null)
{
remarks = "";
}
List <TypeApprovalDetails> data = db.GetTypeApprovalInfo(Dealer, Model, make, remarks);
return(Request.CreateResponse(HttpStatusCode.OK, data));
}
public HttpResponseMessage ReassignTask([FromBody] dynamic data)
{
SLW_DatabaseInfo db = new SLW_DatabaseInfo();
KeyDetail detail = db.GetKeyDetail((string)data.access_key);
if (detail.data_present)
{
OngoingTask prev_ongoing = db.GetSingleOngoingTask((string)data.application_id);
db.ReassignTask((string)data.application_id, (string)data.assign_to);
OngoingTask ongoing = db.GetSingleOngoingTask((string)data.application_id);
UserDetails prevUserDetails = db.GetUserDetails(prev_ongoing.assigned_to);
UserDetails userDetails = db.GetUserDetails(ongoing.assigned_to);
Form form = db.GetApplication((string)data.application_id);
ongoing.assigned_to = userDetails.fullname;
db.SaveActivity(new UserActivity(detail.username, Commons.Constants.ACTIVITY_REASSIGN_TASK, (string)data.application_id, (string)data.assign_to, 1));
Email.Send(userDetails.email, "New Type Approval Application", "Type approval application " + form.application_id + " for Device with Model number " + form.product_identification + " from " + ongoing.submitted_by + " is assigned to you for processing.");
Email.Send(prevUserDetails.email, "Assigned Type Approval Application", "Application " + form.application_id + " that had been assigned to you has been reassigned.");
return(Request.CreateResponse(HttpStatusCode.OK, ongoing));
}
else
{
return(Request.CreateResponse(HttpStatusCode.Unauthorized, "invalid key"));
}
}
public HttpResponseMessage GetSmaCertificate([FromBody] dynamic data)
{
SLW_DatabaseInfo db = new SLW_DatabaseInfo();
Certificate certificate = db.GetSMACertificate((string)data.approval_id);
return(Request.CreateResponse(HttpStatusCode.OK, certificate));
}
public HttpResponseMessage ResetPassword([FromBody] dynamic data)
{
SLW_DatabaseInfo db = new SLW_DatabaseInfo();
Utilities.PasswordManager manager = new Utilities.PasswordManager();
string password = "";
if ((string)data.new_password == "" || (string)data.new_password == null)
{
password = Utilities.Generator.GeneratePassword();
}
else
{
password = (string)data.new_password;
}
manager.ResetPassword((string)data.username, password);
UserDetails userDetails = db.GetUserDetails((string)data.username);
if (userDetails == null)
{
return(Request.CreateResponse(HttpStatusCode.Unauthorized, "user not found"));
}
else
{
Utilities.Email.Send(userDetails.email, "Password reset", "Your password has been reset. New password: "******"");
return(Request.CreateResponse(HttpStatusCode.OK, "password reset"));
}
}
public HttpResponseMessage Delete([FromBody] Delete delete)
{
SLW_DatabaseInfo db = new SLW_DatabaseInfo();
KeyDetail key_detail = db.GetKeyDetail(delete.key);
if (IsKeyValid(key_detail))
{
int user_type_requirement = 9;
Utilities.PasswordManager mgr = new Utilities.PasswordManager();
if (db.GetUserType(delete.key) == user_type_requirement)
{
if (db.CheckUserExist(delete.user))
{
db.DeleteUser(delete.user);
db.SaveActivity(new UserActivity(delete.user, Commons.Constants.ACTIVITY_DELETE_ACCOUNT, delete.user, "", 0));
return(Request.CreateResponse(HttpStatusCode.OK, "user_deleted"));
}
else
{
return(Request.CreateResponse(HttpStatusCode.Unauthorized, "invalid_user"));
}
}
else
{
return(Request.CreateResponse(HttpStatusCode.Unauthorized, "unauthorized"));
}
}
else
{
return(Request.CreateResponse(HttpStatusCode.Unauthorized, "access_key_invalid"));
}
}
public HttpResponseMessage CreateApplication([FromBody] Form data)
{
if (data.application_id != null && data.application_id != "")
{
SLW_DatabaseInfo db = new SLW_DatabaseInfo();
data.category = Commons.Constants.TYPE_APPROVAL;
data.status = Commons.Constants.INCOMPLETE_TYPE;
db.SaveApplication(data);
db.SaveActivity(new UserActivity(data.username, Commons.Constants.ACTIVITY_UPDATE, data.application_id, "", 1));
return(Request.CreateResponse(HttpStatusCode.OK, "updated"));
}
else
{
string application_id = Generator.application_id();
SLW_DatabaseInfo db = new SLW_DatabaseInfo();
data.application_id = application_id;
data.category = Commons.Constants.TYPE_APPROVAL;
data.status = Commons.Constants.INCOMPLETE_TYPE;
db.SaveApplication(data);
db.SaveActivity(new UserActivity(data.username, Commons.Constants.ACTIVITY_NEW_APPLICATION_TYPE, data.application_id, "", 1));
return(Request.CreateResponse(HttpStatusCode.OK, application_id));
}
}
public static void Record(Models.UserActivity userActivity)
{
switch (userActivity.type)
{
case Constants.ACTIVITY_ACCOUNT_TYPE:
userActivity.priority = 0;
break;
case Constants.ACTIVITY_APPROVAL_TYPE:
userActivity.priority = 1;
break;
case Constants.ACTIVITY_CANCELLATION_TYPE:
userActivity.priority = 1;
break;
case Constants.ACTIVITY_NEW_APPLICATION_TYPE:
userActivity.priority = 1;
break;
case Constants.ACTIVITY_SUBMISSION_TYPE:
userActivity.priority = 1;
break;
case Constants.ACTIVITY_UPDATE:
userActivity.priority = 1;
break;
}
SLW_DatabaseInfo db = new SLW_DatabaseInfo();
db.SaveActivity(userActivity);
}
public HttpResponseMessage Update([FromBody] Form form)
{
SLW_DatabaseInfo db = new SLW_DatabaseInfo();
KeyDetail keyDetail = db.GetKeyDetail(form.access_key);
//db.SaveApplication(form);
return(Request.CreateResponse(HttpStatusCode.OK, "updated"));;
}
public HttpResponseMessage RegisterCompanyUser([FromBody] CompanyUser user)
{
if (user != null)
{
//can be used to call client functions
var connection = GlobalHost.ConnectionManager.GetHubContext <CrossDomainHub>();
Utilities.PasswordManager mgr = new Utilities.PasswordManager();
SLW_DatabaseInfo db = new SLW_DatabaseInfo();
bool valid_user_type = false;
List <UserType> user_types = db.GetUserTypes();
for (int i = 0; i < user_types.Count; i++)
{
if (user_types[i].user_type == user.user_role)
{
valid_user_type = true;
break;
}
}
if (valid_user_type)
{
if (!db.CheckUserExist(user.username))
{
string source = "";
if (db.CheckLocalClientExist(user.clientId))
{
source = Commons.Constants.LOCAL_SOURCE;
}
else
{
source = Commons.Constants.ASMS_SOURCE;
}
string hash = mgr.GetHash(user.password);
user.user_type = "company";
int id = db.NewCompanyUser(user.username, user.first_name, user.last_name, DateTime.Now, user.user_role, user.user_type, DateTime.Now, (DateTime)System.Data.SqlTypes.SqlDateTime.MinValue, hash, false, user.email, user.company, user.clientId, source);
db.SaveActivity(new UserActivity(user.username, Commons.Constants.ACTIVITY_CREATE_ACCOUNT, "", "", 0));
//Utilities.Email.Send(user.email, "New Account", "Your account was created sucessfully. Username: "******"");
return(Request.CreateResponse(HttpStatusCode.OK, id));
}
else
{
return(Request.CreateResponse(HttpStatusCode.Unauthorized, "user exists"));
}
}
else
{
return(Request.CreateResponse(HttpStatusCode.Unauthorized, "invalid user type"));
}
}
else
{
return(Request.CreateResponse(HttpStatusCode.BadRequest, "bad request"));
}
}
public HttpResponseMessage AllCategories([FromUri] string q)
{
if (q == null)
{
q = "";
}
SLW_DatabaseInfo db = new SLW_DatabaseInfo();
return(Request.CreateResponse(HttpStatusCode.OK, db.GetMultiSearchApplicationResults(q)));
}
public HttpResponseMessage ClientCompanyList([FromUri] string q)
{
SLW_DatabaseInfo db = new SLW_DatabaseInfo();
List <ClientCompany> clientCompanies = db.GetClientDetails(q);
List <ClientCompany> localClientCompanies = db.GetLocalClientCompanies(q);
clientCompanies.AddRange(localClientCompanies);
List <ClientCompany> combinedCompanies = clientCompanies.OrderBy(i => i.name).ToList();
return(Request.CreateResponse(HttpStatusCode.OK, combinedCompanies));
}
public HttpResponseMessage Remarks([FromUri] string q)
{
if (q == null)
{
q = "";
}
SLW_DatabaseInfo db = new SLW_DatabaseInfo();
List <string> remarks = db.GetRemarks(q);
return(Request.CreateResponse(HttpStatusCode.OK, remarks));
}
public HttpResponseMessage New([FromBody] Form form)
{
SLW_DatabaseInfo db = new SLW_DatabaseInfo();
KeyDetail keyDetail = db.GetKeyDetail(form.access_key);
string applicationId = string.Format("{0}_{1:N}", "ta", Guid.NewGuid());
form.application_id = applicationId;
//db.SaveApplication(form);
return(Request.CreateResponse(HttpStatusCode.OK, "saved: " + applicationId));;
}
public HttpResponseMessage Make([FromUri] string q)
{
if (q == null)
{
q = "";
}
SLW_DatabaseInfo db = new SLW_DatabaseInfo();
List <string> make = db.GetMake(q);
return(Request.CreateResponse(HttpStatusCode.OK, make));
}
public HttpResponseMessage Manufacturers([FromUri] string q)
{
if (q == null)
{
q = "";
}
SLW_DatabaseInfo db = new SLW_DatabaseInfo();
List <string> data = db.GetManufacturersByName(q);
return(Request.CreateResponse(HttpStatusCode.OK, data));
}
public HttpResponseMessage GetApplicationIDsForClient([FromBody] dynamic data)
{
SLW_DatabaseInfo db = new SLW_DatabaseInfo();
KeyDetail detail = db.GetKeyDetail((string)data.access_key);
if (detail.data_present)
{
return(Request.CreateResponse(HttpStatusCode.OK, db.GetApplicationIDsForUser((string)data.username)));
}
else
{
return(Request.CreateResponse(HttpStatusCode.Unauthorized, "invalid key"));
}
}
public HttpResponseMessage NewCompany([FromBody] ClientCompany data)
{
SLW_DatabaseInfo db = new SLW_DatabaseInfo();
try
{
int client_id = db.NewLocalClientCompany(data);
return(Request.CreateResponse(HttpStatusCode.OK, client_id));
}
catch (Exception e)
{
return(Request.CreateResponse(HttpStatusCode.InternalServerError, "something went wrong"));
}
}
public HttpResponseMessage NewGrantee([FromBody] Grantee data)
{
SLW_DatabaseInfo db = new SLW_DatabaseInfo();
try
{
Grantee grantee = db.NewLocalGrantee(data);
return(Request.CreateResponse(HttpStatusCode.OK, grantee));
}
catch (Exception e)
{
return(Request.CreateResponse(HttpStatusCode.InternalServerError, "something went wrong"));
}
}
public HttpResponseMessage GetUsersList([FromBody] string access_key)
{
SLW_DatabaseInfo db = new SLW_DatabaseInfo();
KeyDetail key_detail = db.GetKeyDetail(access_key);
if (IsKeyValid(key_detail))
{
List <UserDetails> userDetails = db.GetAllUsersDetails();
return(Request.CreateResponse(HttpStatusCode.OK, userDetails));
}
else
{
return(Request.CreateResponse(HttpStatusCode.Unauthorized, "invalid_key"));
}
}
public HttpResponseMessage GetSavedApplications([FromBody] dynamic data)
{
string access_key = (string)data;
SLW_DatabaseInfo db = new SLW_DatabaseInfo();
KeyDetail detail = db.GetKeyDetail(access_key);
if (detail.data_present)
{
List <SavedApplications> savedApplications = db.GetSavedApplications(detail.username);
return(Request.CreateResponse(HttpStatusCode.OK, savedApplications));
}
else
{
return(Request.CreateResponse(HttpStatusCode.Forbidden, "invalid key"));
}
}
public HttpResponseMessage GetCertificate([FromBody] dynamic data)
{
SLW_DatabaseInfo db = new SLW_DatabaseInfo();
Dashboard dashboard = new Dashboard();
KeyDetail detail = db.GetKeyDetail((string)data.access_key);
if (detail.data_present)
{
Certificate certificate = db.GetPersonalSMACertificate((string)data.application_id);
return(Request.CreateResponse(HttpStatusCode.OK, certificate));
}
else
{
return(Request.CreateResponse(HttpStatusCode.Forbidden, "invalid key"));
}
}
public HttpResponseMessage GetUnassignedTask([FromBody] string access_key)
{
SLW_DatabaseInfo db = new SLW_DatabaseInfo();
KeyDetail detail = db.GetKeyDetail(access_key);
if (detail.data_present)
{
db.CheckForApplicationUpdatesAllUsers();
List <UnassignedTask> unassignedTasks = db.GetUnassignedTasks();
return(Request.CreateResponse(HttpStatusCode.OK, unassignedTasks));
}
else
{
return(Request.CreateResponse(HttpStatusCode.Forbidden, "invalid key"));
}
}
public HttpResponseMessage GetRecentDocuments([FromBody] string access_key)
{
SLW_DatabaseInfo db = new SLW_DatabaseInfo();
List <RecentDocuments> recentDocuments = new List <RecentDocuments>();
KeyDetail detail = db.GetKeyDetail(access_key);
if (detail.data_present)
{
recentDocuments = db.GetRecentDocuments(detail.username);
return(Request.CreateResponse(HttpStatusCode.OK, recentDocuments));
}
else
{
return(Request.CreateResponse(HttpStatusCode.Forbidden, "invalid key"));
}
}
public HttpResponseMessage GetUserActivities([FromBody] string access_key)
{
SLW_DatabaseInfo db = new SLW_DatabaseInfo();
List <UserActivity> userActivities = new List <UserActivity>();
KeyDetail detail = db.GetKeyDetail(access_key);
if (detail.data_present)
{
userActivities = db.GetUserActivities("*preview");
return(Request.CreateResponse(HttpStatusCode.OK, userActivities));
}
else
{
return(Request.CreateResponse(HttpStatusCode.Forbidden, "invalid key"));
}
}
public HttpResponseMessage GetDashboardFeed([FromBody] string access_key)
{
SLW_DatabaseInfo db = new SLW_DatabaseInfo();
Dashboard dashboard = new Dashboard();
KeyDetail detail = db.GetKeyDetail(access_key);
if (detail.data_present)
{
db.CheckForApplicationUpdates(detail.username);
dashboard = db.GetDashboardData(detail.username);
return(Request.CreateResponse(HttpStatusCode.OK, dashboard));
}
else
{
return(Request.CreateResponse(HttpStatusCode.Forbidden, "invalid key"));
}
}
public HttpResponseMessage GetApplicationStatus([FromBody] dynamic data)
{
string access_key = (string)data.access_key;
string application_id = (string)data.application_id;
SLW_DatabaseInfo db = new SLW_DatabaseInfo();
KeyDetail detail = db.GetKeyDetail(access_key);
if (detail.data_present)
{
return(Request.CreateResponse(HttpStatusCode.OK, db.GetApplicationStatus(application_id)));
}
else
{
return(Request.CreateResponse(HttpStatusCode.Unauthorized, "invalid key"));
}
}
public HttpResponseMessage ClientResubmission([FromBody] dynamic data)
{
SLW_DatabaseInfo db = new SLW_DatabaseInfo();
KeyDetail keyDetail = db.GetKeyDetail((string)data.access_key);
if (keyDetail.data_present)
{
db.UpdateApplicationStatus((string)data.application_id, Commons.Constants.PENDING_RESUBMISSION, DateTime.Now);
Utilities.FileManager.DeleteFiles((string)data.application_id);
db.DeleteOngoingTask((string)data.application_id);
db.DeleteUnassignedTask((string)data.application_id);
return(Request.CreateResponse(HttpStatusCode.OK, "status updated"));
}
else
{
return(Request.CreateResponse(HttpStatusCode.Unauthorized, "invalid key"));
}
}
