public async Task <IHttpActionResult> AddUploadLog(AddUploadLogParameter param) { var adapter = new MyPatchSGStoredProcedureAdapter(); var procParam = new AddUploadLogParams { Upload_Date = param.UploadDate, Login_ID = param.LoginID, Status = param.Status, File_Path = param.FilePath, Total_Time = float.Parse(param.TotalTime), App_Version = param.AppVersion, OS_Type = param.OSType, OS_Version = param.OSVersion, MacAddr = param.MacAddr }; var result = adapter.ExecuteStoredProcedure <int>(procParam.StoredProcedureName, procParam).SingleOrDefault(); if (result > 0) { return(Ok()); } return(BadRequest()); }
public bool InsertUploadLog(string UploadDate, string LoginID, string Status, string FilePath, int ElapsedTime, string AppVersion, string OSType, string OSVersion, string MacAddr) { var procParam = new AddUploadLogParams { Upload_Date = UploadDate, Login_ID = LoginID, Status = Status, File_Path = FilePath, Total_Time = (float)ElapsedTime, App_Version = AppVersion, OS_Type = OSType, OS_Version = OSVersion, MacAddr = MacAddr }; var adapter = new MyPatchSGStoredProcedureAdapter(); var procResult = adapter.ExecuteStoredProcedure <int>(procParam.StoredProcedureName, procParam).SingleOrDefault(); if (procResult > 0) { return(true); } return(false); }
public async Task <IHttpActionResult> VerifyLogin(VerifyLoginParameter param) { var adapter = new MyPatchSGStoredProcedureAdapter(); var procParam = new VerifyLoginParams { UserID = param.UserID, Password = param.Password, MacAddr = param.MacAddr }; var dbLogins = adapter.ExecuteStoredProcedure <VerifyLoginModel>(procParam.StoredProcedureName, procParam); var Logins = dbLogins.ToList <VerifyLoginModel>(); if (Logins.Count > 0) { return(Ok(Logins[0])); } return(NotFound()); }
public async Task <IHttpActionResult> GetFileName(GetFileNameParameter param) { string userName = param.UserName; var outputModel = new ResourceFileNameModel(); outputModel.UserName = userName; var adapter = new MyPatchSGStoredProcedureAdapter(); var procParam = new GetDBFileParams { UserID = userName, AppID = param.AppID, OS = param.OS }; var dbFileNames = adapter.ExecuteStoredProcedure <DBFileNameModel>(procParam.StoredProcedureName, procParam); outputModel.DbFileNames = dbFileNames.ToList <DBFileNameModel>(); return(Ok(outputModel)); }