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 MyPatchStoredProcedureAdapter(); 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 MyPatchStoredProcedureAdapter(); 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 MyPatchStoredProcedureAdapter(); 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)); }