public static byte[] GetLMAttachmentFile(int orgID, int libraryID, decimal lMaterialID)
{
object obj;
byte[] bytes;
try
{
obj = DLLLibraryMaterial.GetLMAttachmentFile(orgID, libraryID, lMaterialID);
if (obj == System.DBNull.Value || obj == null)
{
bytes = null;
}
else
{
bytes = (byte[])obj;
}
return(bytes);
}
catch (Exception ex)
{
throw ex;
}
}
public static long AddLibraryMaterial(ATTLibraryMaterial obj, Previlege pobj)
{
try
{
return(DLLLibraryMaterial.AddLibraryMaterial(obj, pobj));
}
catch (Exception ex)
{
throw ex;
}
}
public static bool AddLibraryMaterialCopy(List <ATTLibraryMaterialCopy> obj, long LMID)
{
try
{
return(DLLLibraryMaterial.AddLibraryMaterialCopy(obj, LMID));
}
catch (Exception)
{
throw;
}
}
public static List <ATTLibraryMaterial> GetSearchedLibraryMaterialList(ATTLibraryMaterial criteria, string keyCollection, string authorCollection, string action)
{
try
{
#region "Commented logic for merging material copy"
//List<ATTLibraryMaterial> lstLM = new List<ATTLibraryMaterial>();
//DataTable tblLM = DLLLibraryMaterial.GetSearchedLibraryMaterialTable();
//int orgID;
//int libraryID;
//long lMaterialID;
//long accessionID;
//ATTLibraryMaterial tempLib = new ATTLibraryMaterial();
//foreach (DataRow row in tblLM.Rows)
//{
// ATTLibraryMaterial lib = null;
// orgID = int.Parse(row["Org_ID"].ToString());
// libraryID = int.Parse(row["Library_ID"].ToString());
// lMaterialID = long.Parse(row["L_Material_ID"].ToString());
// accessionID = long.Parse(row["Accession_ID"].ToString());
// lib = lstLM.Find
// (
// delegate(ATTLibraryMaterial LM)
// {
// return LM.OrgID == orgID &&
// LM.LibraryID == libraryID &&
// LM.LMaterialID == lMaterialID;
// }
// );
// if (lib == null)
// {
// lib = new ATTLibraryMaterial();
// lib.OrgID = orgID;
// lib.LibraryID = libraryID;
// lib.LMaterialID = lMaterialID;
// tempLib = lib;
// lstLM.Add(tempLib);
// }
// ATTLibraryMaterialCopy libCopy = null;
// libCopy = tempLib.LstLMCopy.Find
// (
// delegate(ATTLibraryMaterialCopy copy)
// {
// return
// copy.OrgID == orgID &&
// copy.LibraryID == libraryID &&
// copy.LMaterialID == lMaterialID &&
// copy.AccessionID == accessionID;
// }
// );
// if (libCopy == null)
// {
// libCopy = new ATTLibraryMaterialCopy();
// libCopy.OrgID = orgID;
// libCopy.LibraryID = libraryID;
// libCopy.LMaterialID = lMaterialID;
// libCopy.AccessionID = accessionID;
// tempLib.LstLMCopy.Add(libCopy);
// }
//}
//return lstLM;
#endregion
DataTable tbl = DLLLibraryMaterial.GetSearchedLibraryMaterialTable(criteria, keyCollection, authorCollection);
List <ATTLibraryMaterial> lstLM = new List <ATTLibraryMaterial>();
int orgID;
int libraryID;
long lMaterialID;
long accessionID;
ATTLibraryMaterial tempLib = new ATTLibraryMaterial();
foreach (DataRow row in tbl.Rows)
{
ATTLibraryMaterial lib = null;
orgID = int.Parse(row["Org_ID"].ToString());
libraryID = int.Parse(row["Library_ID"].ToString());
lMaterialID = long.Parse(row["L_Material_ID"].ToString());
accessionID = long.Parse(row["Accession_ID"].ToString());
lib = lstLM.Find
(
delegate(ATTLibraryMaterial LM)
{
return(LM.OrgID == orgID &&
LM.LibraryID == libraryID &&
LM.LMaterialID == lMaterialID);
}
);
if (lib == null)
{
lib = new ATTLibraryMaterial();
lib.OrgID = orgID;
lib.LibraryID = libraryID;
lib.LMaterialID = lMaterialID;
lib.Title = row["Title"].ToString();
lib.LibraryMaterialType = int.Parse(row["MT_ID"].ToString());
lib.LibraryMaterialCategory = int.Parse(row["Category_ID"].ToString());
lib.CallNo = row["Call_NO"].ToString();
lib.CorporateBody = row["Corporate_Body"].ToString();
lib.SeriesStatement = row["Series_State"].ToString();
lib.Note = row["Note"].ToString();
lib.BoardSubjectHeading = row["Brd_Subject_Heading"].ToString();
lib.GeoDescription = row["Geo_Desc"].ToString();
lib.PhysicalDescription = row["Phy_Desc"].ToString();
lib.LanguageID = int.Parse(row["Lang_ID"].ToString());
lib.PublisherID = int.Parse(row["Publisher_ID"].ToString());
//if (row["Content_File"] == System.DBNull.Value)
// lib.ContentFile = null;
//else
// lib.ContentFile = (byte[])row["Content_File"];
lib.CFileType = row["File_Type"].ToString();
lib.Action = action;
tempLib = lib;
lstLM.Add(tempLib);
}
ATTLibraryMaterialCopy libCopy = null;
libCopy = tempLib.LstLMCopy.Find
(
delegate(ATTLibraryMaterialCopy copy)
{
return
(copy.OrgID == orgID &&
copy.LibraryID == libraryID &&
copy.LMaterialID == lMaterialID &&
copy.AccessionID == accessionID);
}
);
if (libCopy == null)
{
libCopy = new ATTLibraryMaterialCopy();
libCopy.OrgID = orgID;
libCopy.LibraryID = libraryID;
libCopy.LMaterialID = lMaterialID;
libCopy.AccessionID = accessionID;
libCopy.Edition = row["Edition"].ToString();
libCopy.PublicationDate = row["Pub_Date"].ToString();
libCopy.RegistrationDate = (DateTime)row["Reg_Date"];
libCopy.IsbnIssnNo = row["Isbn_Issn"].ToString();
libCopy.Price = double.Parse((row["Price"] == System.DBNull.Value) ? "0" : row["Price"].ToString());
libCopy.CurrencyID = int.Parse(row["Currency_ID"].ToString());
libCopy.Location = row["MT_COPY_LOC"].ToString();
libCopy.Action = action;
tempLib.LstLMCopy.Add(libCopy);
}
}
return(lstLM);
}
catch (Exception ex)
{
throw ex;
}
}
