public bool DeleteFileUploadDetByRequisitionNo(SqlCommand cmd, FileUploadDetail det)
{
string sql = "";
bool retflag = true;
sql = "Delete from [FileUploadDetail] where ReferenceNo= '" + det.ReferenceNo + "'";
if (!DataProcess.ExecuteSqlCommand(cmd, sql))
{
retflag = false;
goto errorhand;
}
errorhand:
return(retflag);
}
public static bool SqlInsertFileDet(SqlCommand cmd, FileUploadDetail filedett, List <FileUploadDetail> lstfileDet)
{
string sql = "";
bool retflag = true;
foreach (FileUploadDetail file in lstfileDet)
{
sql = "INSERT INTO [FileUploadDetail] ([CompanyID],[BranchID],[FileID],[ReferenceNo],[FileType],[UserDefinedFileName],[OriginalFileName],[UploadedFilename],[FileLength],[UploadBy],[UploadDatetime],[RelativePath],[AbsolutePath],[DownloadLink]) VALUES (" + file.CompanyID + "," + file.BranchID + ",'" + file.FileID + "','" + file.ReferenceNo + "','" + file.FileType + "','" + file.UserDefinedFileName + "','" + file.OriginalFileName + "','" + file.UploadedFilename + "'," + file.FileLength + ",'" + file.UploadBy + "',convert(datetime,'" + file.UploadDateTime + "',103),'" + file.RelativePath + "','" + file.AbsolutePath + "','" + file.DownloadLink + "')";
if (!DataProcess.ExecuteSqlCommand(cmd, sql))
{
retflag = false;
goto errorhand;
}
}
errorhand:
return(retflag);
}
