public bool Export(OXODoc documentToExport, string comment, string PACN) { var retVal = false; XLWorkbook workbook = ClosedXmlExcelGenerator.GenerateExcelOXO(documentToExport.ProgrammeId, documentToExport.Id, CDSID, true); OXOProgrammeFile file = new OXOProgrammeFile(); file.ProgrammeId = documentToExport.ProgrammeId; file.FileCategory = ProgrammFileCategory.Publish.ToString(); file.FileComment = comment; file.PACN = PACN; file.FileName = String.Format("{0} {1} {2} {3} v{4}.{5} {6}.xlsx", documentToExport.VehicleName, documentToExport.VehicleAKA, documentToExport.ModelYear, documentToExport.Gateway, documentToExport.VersionMajor, documentToExport.VersionMinor, documentToExport.Status); file.FileType = "application/vnd.open"; file.FileExt = "xlsx"; file.Gateway = documentToExport.Gateway; MemoryStream m = new MemoryStream(); workbook.SaveAs(m); file.FileContent = m.ToArray(); file.FileSize = file.FileContent.Length; _programmeFileDataStore.OXOProgrammeFileSave(file); retVal = true; return(retVal); }
public bool OXOProgrammeFileSave(OXOProgrammeFile obj) { bool retVal = true; string procName = (obj.Id == 0 ? "dbo.OXO_Programme_File_New" : "dbo.OXO_Programme_File_Edit"); using (IDbConnection conn = DbHelper.GetDBConnection()) { try { obj.Save(this.CurrentCDSID); var para = new DynamicParameters(); para.Add("@p_Programme_Id", obj.ProgrammeId, dbType: DbType.Int32); para.Add("@p_File_Category", obj.FileCategory, dbType: DbType.String, size: 100); para.Add("@p_File_Comment", obj.FileComment, dbType: DbType.String, size: 2000); para.Add("@p_File_Name", obj.FileName, dbType: DbType.String, size: 100); para.Add("@p_File_Ext", obj.FileExt, dbType: DbType.String, size: 4); para.Add("@p_File_Type", obj.FileType, dbType: DbType.String, size: 20); para.Add("@p_File_Size", obj.FileSize, dbType: DbType.Int32); para.Add("@p_gateway", obj.Gateway, dbType: DbType.String, size: 100); para.Add("@p_PACN", obj.PACN, dbType: DbType.String, size: 10); para.Add("@p_File_Content", obj.FileContent, dbType: DbType.Binary); para.Add("@p_Created_By", obj.CreatedBy, dbType: DbType.String, size: 8); para.Add("@p_Created_On", obj.CreatedOn, dbType: DbType.DateTime); para.Add("@p_Updated_By", obj.UpdatedBy, dbType: DbType.String, size: 8); para.Add("@p_Last_Updated", obj.LastUpdated, dbType: DbType.DateTime); if (obj.Id == 0) { para.Add("@p_Id", dbType: DbType.Int32, direction: ParameterDirection.Output); } else { para.Add("@p_Id", obj.Id, dbType: DbType.Int32); } conn.Execute(procName, para, commandType: CommandType.StoredProcedure); if (obj.Id == 0) { obj.Id = para.Get <int>("@p_Id"); } } catch (Exception ex) { Log.Error(ex); throw; } } return(retVal); }
public OXOProgrammeFile OXOProgrammeFileGet(int id) { OXOProgrammeFile retVal = null; using (IDbConnection conn = DbHelper.GetDBConnection()) { try { var para = new DynamicParameters(); para.Add("@p_Id", id, dbType: DbType.Int32); retVal = conn.Query <OXOProgrammeFile>("dbo.OXO_Programme_File_Get", para, commandType: CommandType.StoredProcedure).FirstOrDefault(); } catch (Exception ex) { Log.Error(ex); throw; } } return(retVal); }