public static List <MyFileInfo> Insert(ArrayList list)
{
List <MyFileInfo> duplicateList = new List <MyFileInfo>();
duplicateList.Clear();
string sql1 = "insert cd values (getdate())";
string sql2 = "delete from cd where cdid=(select max(cdID) from [cd])";
DBHelper.ExecuteSql(sql1);
foreach (MyFileInfo fi in list)
{
//if(Validate(fi))
//if (!Check(fi))
//{
// //sql = "insert into files values('" + fi.FileName + "','1" + fi.Extension + "','" + fi.DirectoryName + "','" + fi.DirectoryName + "'," + fi.Length / 1024 / 1024 + ",'" + fi.LastAccessTime + "','" + fi.LastWriteTime + "')";
//}
//else
if (Check(fi))
{
duplicateList.Add(fi);
//DBHelper.ExecuteSql(sql2);
}
cdNo = DBHelper.ExecuteInsert_SP("dbo.sp_InsertCD", fi);
}
return(duplicateList);
}
public static List <MyFileInfo> Insert(ArrayList list)
{
List <MyFileInfo> duplicateList = new List <MyFileInfo>();
foreach (MyFileInfo fi in list)
{
if (Check(fi))
{
duplicateList.Add(fi);
}
cdNo = DBHelper.ExecuteInsert_SP("dbo.sp_InsertCD", fi);
}
return(duplicateList);
}
