public static ObjectValidation Validate(ATTLibraryMaterialCopy obj)
{
ObjectValidation OV = new ObjectValidation();
if (obj.OrgID <= 0)
{
OV.IsValid = false;
OV.ErrorMessage = "Please select Organization.";
return(OV);
}
if (obj.LibraryID <= 0)
{
OV.IsValid = false;
OV.ErrorMessage = "Please select Library.";
return(OV);
}
if (obj.EntryBy == "")
{
OV.IsValid = false;
OV.ErrorMessage = "Invalid user.";
return(OV);
}
return(OV);
}
public static bool AddLibraryMaterialCopy(List <ATTLibraryMaterialCopy> lstCopy, long lMaterialID, OracleTransaction Tran)
{
string InsertSP = "";
try
{
ATTLibraryMaterialCopy obj = lstCopy[0];
OracleParameter[] paramArray = new OracleParameter[1];
if (obj.Action == "A")
{
InsertSP = "SP_ADD_LIBRARY_MATERIAL_COPY";
paramArray = new OracleParameter[12];
paramArray[11] = Utilities.GetOraParam(":p_ENTRY_BY", obj.EntryBy, OracleDbType.Varchar2, ParameterDirection.Input);
}
else if (obj.Action == "M")
{
InsertSP = "SP_EDIT_LIBRARY_MATERIAL_COPY";
paramArray = new OracleParameter[11];
}
else if (obj.Action == "D")
{
InsertSP = "SP_DEL_LIBRARY_MATERIAL_COPY";
paramArray = new OracleParameter[4];
}
else if (obj.Action == "N")
{
}
if (obj.Action != "N")
{
paramArray[0] = Utilities.GetOraParam(":p_ORG_ID", obj.OrgID, OracleDbType.Int64, ParameterDirection.Input);
paramArray[1] = Utilities.GetOraParam(":p_LIBRARY_ID", obj.LibraryID, OracleDbType.Int64, ParameterDirection.Input);
paramArray[2] = Utilities.GetOraParam(":p_L_MATERIAL_ID", lMaterialID, OracleDbType.Long, ParameterDirection.InputOutput);
paramArray[3] = Utilities.GetOraParam(":p_ACCESSION_ID", obj.AccessionID, OracleDbType.Long, ParameterDirection.Input);
if (obj.Action != "D")
{
paramArray[4] = Utilities.GetOraParam(":p_EDITION", obj.Edition, OracleDbType.Varchar2, ParameterDirection.Input);
paramArray[5] = Utilities.GetOraParam(":p_PUB_DATE", obj.PublicationDate, OracleDbType.Varchar2, ParameterDirection.Input);
paramArray[6] = Utilities.GetOraParam(":p_REG_DATE", obj.RegistrationDate, OracleDbType.Date, ParameterDirection.Input);
paramArray[7] = Utilities.GetOraParam(":p_ISBN_ISSN", obj.IsbnIssnNo, OracleDbType.Varchar2, ParameterDirection.Input);
paramArray[8] = Utilities.GetOraParam(":p_PRICE", obj.Price, OracleDbType.Long, ParameterDirection.Input);
paramArray[9] = Utilities.GetOraParam(":p_CURRENCY_ID", obj.CurrencyID, OracleDbType.Int64, ParameterDirection.Input);
paramArray[10] = Utilities.GetOraParam(":p_LOCATION", obj.Location, OracleDbType.Varchar2, ParameterDirection.Input);
}
SqlHelper.ExecuteNonQuery(Tran, CommandType.StoredProcedure, InsertSP, paramArray);
}
return(true);
}
catch (Exception ex)
{
throw ex;
}
}
public static List <ATTLibraryMaterialCopy> GetLMCopy(int orgID, int libraryID, decimal lMaterialID)
{
List <ATTLibraryMaterialCopy> lstLMCopy = new List <ATTLibraryMaterialCopy>();
foreach (DataRow row in DLLLibraryMaterialCopy.GetLMCopy(orgID, libraryID, lMaterialID).Rows)
{
ATTLibraryMaterialCopy libCopy = new ATTLibraryMaterialCopy();
libCopy.AccessionID = int.Parse(row["accession_id"].ToString());
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["location"].ToString();
lstLMCopy.Add(libCopy);
}
return(lstLMCopy);
}
void SaveLibraryDetails(long?LibMatID, string action, long acc_id)
{
long LMID = 0;
if (LibMatID == null)
{
LMID = long.Parse(Session["LibMatID"].ToString());
}
else
{
LMID = LibMatID.Value;
}
ATTLibraryMaterial LMObj = (ATTLibraryMaterial)Session["LM"];
////---------Add Material Copy---------
ATTLibraryMaterialCopy libCopyObj = new ATTLibraryMaterialCopy();
libCopyObj.Edition = editionTxt.Text;
libCopyObj.PublicationDate = pubDateTxt.Text;
libCopyObj.RegistrationDate = DateTime.Now;
regDateTxt.Text = DateTime.Now.ToShortDateString();
libCopyObj.Price = double.Parse(priceTxt.Text);
libCopyObj.CurrencyID = int.Parse(this.ddlCurrency.SelectedValue);
libCopyObj.Location = locTxt.Text;
libCopyObj.Action = action;
libCopyObj.AccessionID = acc_id;
libCopyObj.IsbnIssnNo = isbnTxt.Text;
libCopyObj.OrgID = LMObj.OrgID;
libCopyObj.LibraryID = LMObj.LibraryID;
libCopyObj.EntryBy = LMObj.EntryBy;
List <ATTLibraryMaterialCopy> lstLMCpy = new List <ATTLibraryMaterialCopy>();
lstLMCpy.Add(libCopyObj);
BLLLibraryMaterial.AddLibraryMaterialCopy(lstLMCpy, LMID);
}
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;
}
}
