Example #1
0
 public static FileBE GetElementById(int intFileId)
 {
     FileBE objFile = new FileBE();
     List<GenralizeParametre> objListFileParam = new List<GenralizeParametre>();
     objListFileParam.Add(new GenralizeParametre("FileId", intFileId, DbType.Int32));
     IDataRecord dr = GenralizeStoredProcedure.GetIDataRecord(spFileGetElementById, objListFileParam);
     objFile = FillDataRecord(dr);
     return objFile;
 }
Example #2
0
 public static int Save(FileBE objFile)
 {
     List<GenralizeParametre> objListFileParam = new List<GenralizeParametre>();
     objListFileParam.Add(new GenralizeParametre("FileId", objFile.FileId, DbType.Int32));
     objListFileParam.Add(new GenralizeParametre("FileName", objFile.FileName, DbType.String));
     objListFileParam.Add(new GenralizeParametre("FilePath", objFile.FilePath, DbType.String));
     objListFileParam.Add(new GenralizeParametre("AddedDateTime", objFile.AddedDateTime, DbType.DateTime));
     objFile.FileId = GenralizeStoredProcedure.GetInt(spFileSave, objListFileParam);
     return objFile.FileId;
 }
Example #3
0
 private static FileBE FillDataRecord(IDataRecord dr)
 {
     FileBE objFile = new FileBE();
     if (!dr.IsDBNull(dr.GetOrdinal("FileId")))
     {
         objFile.FileId = dr.GetInt32(dr.GetOrdinal("FileId"));
     }
     if (!dr.IsDBNull(dr.GetOrdinal("FileName")))
     {
         objFile.FileName = dr.GetString(dr.GetOrdinal("FileName"));
     }
     if (!dr.IsDBNull(dr.GetOrdinal("FilePath")))
     {
         objFile.FilePath = dr.GetString(dr.GetOrdinal("FilePath"));
     }
     if (!dr.IsDBNull(dr.GetOrdinal("AddedDateTime")))
     {
         objFile.AddedDateTime = dr.GetDateTime(dr.GetOrdinal("AddedDateTime"));
     }
     return objFile;
 }