HRM-10/HRM.DA/DA/Common/FileAttachmentDA.cs

75 lines
3.9 KiB
C#
Raw Permalink Normal View History

2026-11-03 13:06:00 +06:00
using Ease.Core.DataAccess;
using HRM.BO;
using Microsoft.Data.SqlClient;
using System;
using System.Configuration;
using System.Data;
namespace HRM.DA
{
internal class FileAttachmentDA
{
//internal static void Insert(TransactionContext tc, FileAttachment item)
//{
// tc.ExecuteNonQuery("INSERT INTO FileAttachment(ReferenceID, FileData, OriginalFileName,FileType)" +
// " VALUES(%n,%s,%s,%n)", item.ReferenceID, item.FileTobase64, item.OriginalFileName,(int)item.FileType);
//}
public static void Insert(FileAttachment item, TransactionContext tc)
{
// string ConnString = ConfigurationSettings.AppSettings["default"];
// var ConnString = System.Configuration.ConfigurationManager.GetSection("dbSettings");
// string ConnString=ConfigurationManager.ConnectionStrings[connectionString].ConnectionString;
string strQuery = @"INSERT INTO FileAttachment(ReferenceID, FileData, OriginalFileName,FileType,RefChildId)
Values (@ReferenceID,@FileData,@OriginalFileName,@FileType,@RefChildId)";
SqlCommand cmd = new SqlCommand(strQuery, (SqlConnection)tc.Connection);
cmd.Transaction = (SqlTransaction)tc.Transaction;
//cmd.Parameters.Add("@empFileuploadID", SqlDbType.Int).Value = item.ID;
cmd.Parameters.Add("@ReferenceID", SqlDbType.Int).Value = item.ReferenceID;
cmd.Parameters.Add("@fileData", SqlDbType.Binary).Value = item.FileAsByteArray;
cmd.Parameters.Add("@OriginalFileName", SqlDbType.VarChar).Value = item.OriginalFileName;
cmd.Parameters.Add("@fileType", SqlDbType.Int).Value = item.FileType;
cmd.Parameters.Add("@RefChildId", SqlDbType.Int).Value = item.RefchildID;
//cmd.Parameters.Add("@createdBy", SqlDbType.VarChar).Value = item.CreatedBy;
//cmd.Parameters.Add("@createdDate", SqlDbType.Binary).Value = item.CreatedDate;
//SqlConnection con = new SqlConnection(tc.Connection.ConnectionString);
//cmd.CommandType = CommandType.Text;
//cmd.Connection = con;
cmd.ExecuteNonQuery();
}
internal static IDataReader GetByReferenceId(TransactionContext tc, int refId,EnumFileType fileType)
{
return tc.ExecuteReader("SELECT * FROM FileAttachment where referenceId= %n and fileType=%n ", refId,(int)fileType);
}
internal static IDataReader GetByRefChildId(TransactionContext tc, int refId, EnumFileType fileType,int refChildId)
{
return tc.ExecuteReader("SELECT * FROM FileAttachment where referenceId= %n and fileType=%n and RefChildId=%n", refId, (int)fileType, refChildId);
}
internal static IDataReader GetByReferenceandFileId(TransactionContext tc, int refId, EnumFileType fileType, int id)
{
return tc.ExecuteReader("SELECT * FROM FileAttachment where referenceId= %n and fileType=%n and FILEATTACHMENTID=%n", refId, (int)fileType,id);
}
internal static void Delete(TransactionContext tc, int refID, EnumFileType type)
{
string sql = SQLParser.MakeSQL(@"DELETE FROM FILEATTACHMENT WHERE REFERENCEID = %n AND FILETYPE = %n", refID, type);
tc.ExecuteNonQuery(sql);
}
internal static IDataReader GetCv(TransactionContext tc, int refId)
{
return tc.ExecuteReader("SELECT * FROM FileAttachment where referenceId= %n and FILETYPE in (%n,%n)", refId, (int)EnumFileType.CV, (int)EnumFileType.CVProfilePhoto);
}
internal static IDataReader GetErCv(TransactionContext tc, int refId)
{
return tc.ExecuteReader("SELECT * FROM FileAttachment where referenceId= %n and FILETYPE in (%n,%n)", refId, (int)EnumFileType.ErCV, (int)EnumFileType.ErCVProfilePhoto);
}
}
}