void LoadLibraryMaterialToEdit(ATTLibraryMaterial library)
{
Session["LM_LibraryMaterial"] = library;
Session["LibMatID"] = library.LMaterialID;
this.ddlOrg.SelectedValue = library.OrgID.ToString();
this.ddlLibrary.SelectedValue = library.LibraryID.ToString();
this.ddlCategory_Rqd.SelectedValue = library.LibraryMaterialCategory.ToString();
this.ddlType_Rqd.SelectedValue = library.LibraryMaterialType.ToString();
this.txtCallNo_Rqd.Text = library.CallNo;
this.ddlLanguage_Rqd.SelectedValue = library.LanguageID.ToString();
this.ddlPublisher_Rqd.SelectedValue = library.PublisherID.ToString();
this.txtCorporateBody.Text = library.CorporateBody;
this.txtTitle_Rqd.Text = library.Title;
this.txtSeriesState.Text = library.SeriesStatement;
this.txtNote.Text = library.Note;
this.txtBrdSubHeading.Text = library.BoardSubjectHeading;
this.txtGeoDescription.Text = library.GeoDescription;
this.txtPhyDescription.Text = library.PhysicalDescription;
library.LstLMKeyword = BLLLibraryMaterialKeyword.GetLibraryMaterialKeywordList(library.OrgID, library.LibraryID, library.LMaterialID);
this.grdKeyword.DataSource = library.LstLMKeyword;
this.grdKeyword.DataBind();
library.LstLMAuthor = BLLLibraryMaterialAuthor.GetLibraryMaterialAuthorList(library.OrgID, library.LibraryID, library.LMaterialID);
this.grdAuthor.DataSource = library.LstLMAuthor;
this.grdAuthor.DataBind();
}
void LoadLibraryMaterialCopyGrid(long LMID)
{
ATTLibraryMaterial LMObj = (ATTLibraryMaterial)Session["LM"];
List <ATTLibraryMaterialCopy> LMCopy = BLLLibraryMaterialCopy.GetLMCopy(LMObj.OrgID, LMObj.LibraryID, LMID);
libMatCopyGrd.DataSource = LMCopy;
libMatCopyGrd.DataBind();
Session["LMCopy"] = LMCopy;
}
void LoadLibraryMaterialCopy(ATTLibraryMaterial library)
{
//Session["LMCopy"] = library.LstLMCopy;
List <ATTLibraryMaterialCopy> LstLibCpy = BLLLibraryMaterialCopy.GetLMCopy(library.OrgID, library.LibraryID, library.LMaterialID);
Session["LMCopy"] = LstLibCpy;
this.libMatCopyGrd.DataSource = LstLibCpy;
this.libMatCopyGrd.DataBind();
}
public static long AddLibraryMaterial(ATTLibraryMaterial obj, Previlege pobj)
{
try
{
return(DLLLibraryMaterial.AddLibraryMaterial(obj, pobj));
}
catch (Exception ex)
{
throw ex;
}
}
protected void btnSearch_Click(object sender, EventArgs e)
{
try
{
if (this.hdnPagingIndex.Value == "")
{
this.hdnPagingIndex.Value = "0";
}
else
{
this.hdnPagingIndex.Value = (int.Parse(this.hdnPagingIndex.Value) + 1).ToString();
}
string keywordCollection = this.GetCriteriaCollectionFromList(this.lstKeyword);
string authorCollection = this.GetCriteriaCollectionFromList(this.lstAuthor);
ATTLibraryMaterial obj = new ATTLibraryMaterial();
obj.OrgID = int.Parse(this.ddlOrg.SelectedValue);
obj.LibraryID = int.Parse(this.ddlLibrary.SelectedValue);
obj.LibraryMaterialType = int.Parse(this.ddlType.SelectedValue);
obj.LibraryMaterialCategory = int.Parse(this.ddlCategory.SelectedValue);
obj.LanguageID = int.Parse(this.ddlLanguage.SelectedValue);
obj.PublisherID = int.Parse(this.ddlPublisher.SelectedValue);
obj.CallNo = this.txtCallNo.Text;
Session["LibraryMaterialEditor"] = BLLLibraryMaterial.GetSearchedLibraryMaterialList(obj, keywordCollection, authorCollection, "M");
this.grdSearch.DataSource = (List <ATTLibraryMaterial>)Session["LibraryMaterialEditor"];
this.grdSearch.DataBind();
this.lblRecordCount.Text = "Total " + this.grdSearch.Rows.Count.ToString() + " record found.";
this.LoadImageX.Width = new Unit(0);
this.LoadImageX.Height = new Unit(0);
}
catch (Exception ex)
{
throw ex;
}
}
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);
}
protected void btnSubmit_Click(object sender, EventArgs e)
{
if (this.hdnAction.Value == "")
{
if (!ServerValidateAll())
{
this.lblStatusMessage.Text = sb.ToString();
this.programmaticModalPopup.Show();
return;
}
}
else if (this.hdnAction.Value == "M")
{
if (!ServerValidateMaster())
{
this.lblStatusMessage.Text = sb.ToString();
this.programmaticModalPopup.Show();
return;
}
}
string ext = System.IO.Path.GetExtension(this.fupAttachment.FileName);
if (ext == "pdf" || ext == "jpeg" || ext == "jpg" || ext == "gif")
{
this.lblStatusMessage.Text = "Uploaded file's extention must be of 'pdf' or 'jpg' or 'jpeg' or 'gif'.";
this.programmaticModalPopup.Show();
return;
}
ATTLibraryMaterial LM = (ATTLibraryMaterial)Session["LM_LibraryMaterial"];
LM.OrgID = int.Parse(this.ddlOrg.SelectedValue);
LM.LibraryID = int.Parse(this.ddlLibrary.SelectedValue);
if (this.hdnAction.Value != "M")
{
LM.LMaterialID = 0;
}
LM.LibraryMaterialType = int.Parse(this.ddlType_Rqd.SelectedValue);
LM.LibraryMaterialCategory = int.Parse(this.ddlCategory_Rqd.Text);
LM.CallNo = this.txtCallNo_Rqd.Text;
LM.CorporateBody = this.txtCorporateBody.Text;
LM.Title = this.txtTitle_Rqd.Text;
LM.SeriesStatement = this.txtSeriesState.Text;
LM.Note = this.txtNote.Text;
LM.BoardSubjectHeading = this.txtBrdSubHeading.Text;
LM.GeoDescription = this.txtGeoDescription.Text;
LM.LanguageID = int.Parse(this.ddlLanguage_Rqd.SelectedValue);
LM.PublisherID = int.Parse(this.ddlPublisher_Rqd.SelectedValue);
LM.PhysicalDescription = this.txtPhyDescription.Text;
LM.EntryBy = ((ATTUserLogin)Session["Login_User_Detail"]).UserName;
LM.EntryOn = DateTime.Now;
//LM.ContentFile = null;
//LM.CFileType = "";
if (this.hdnAction.Value == "M")
{
LM.Action = "M";
}
else
{
LM.Action = "A";
}
if (this.fupAttachment.HasFile == true)
{
LM.ContentFile = this.fupAttachment.FileBytes;
LM.CFileType = System.IO.Path.GetExtension(this.fupAttachment.FileName);
}
ObjectValidation OV = BLLLibraryMaterial.Validate(LM);
if (OV.IsValid == false)
{
//this.lblMaterialStatus.Text = OV.ErrorMessage;
this.lblStatusMessage.Text = OV.ErrorMessage;
this.programmaticModalPopup.Show();
return;
}
GridViewRow keyRow;
int keyRowCount = 0;
bool keyChecked;
foreach (ATTLibraryMaterialKeyword ky in LM.LstLMKeyword)
{
keyRow = this.grdKeyword.Rows[keyRowCount];
keyChecked = ((CheckBox)keyRow.FindControl("chkKeyword")).Checked;
if (keyChecked == true && ky.Action == "A")
{
ky.Action = "N";
}
else if (keyChecked == true && ky.Action == "M")
{
ky.Action = "D";
}
else if (keyChecked == false && ky.Action == "M")
{
ky.Action = "N";
}
keyRowCount = keyRowCount + 1;
}
GridViewRow authorRow;
int authorRowCount = 0;
bool authorChecked;
foreach (ATTLibraryMaterialAuthor au in LM.LstLMAuthor)
{
authorRow = this.grdAuthor.Rows[authorRowCount];
authorChecked = ((CheckBox)authorRow.FindControl("chkAuthor")).Checked;
if (authorChecked == true && au.Action == "A")
{
au.Action = "N";
}
else if (authorChecked == true && au.Action == "M")
{
au.Action = "D";
}
else if (authorChecked == false && au.Action == "M")
{
au.Action = "N";
}
authorRowCount = authorRowCount + 1;
}
ATTUserLogin user = ((ATTUserLogin)Session["Login_User_Detail"]);
try
{
if (LM.Action == "A")
{
if (user.MenuList["4,9,1"] == null || user.MenuList["4,9,1"].PAdd == "N")
{
this.lblStatusMessage.Text = Utilities.PreviledgeMsg + " add Library Material.";
this.programmaticModalPopup.Show();
return;
}
}
else if (LM.Action == "M")
{
if (user.MenuList["4,9,1"] == null || user.MenuList["4,9,1"].PEdit == "N")
{
this.lblStatusMessage.Text = Utilities.PreviledgeMsg + " update Library Material.";
this.programmaticModalPopup.Show();
return;
}
}
Previlege.PrevilegeType pType = Previlege.PrevilegeType.P_ADD;
string modeName = "";
if (LM.Action == "A")
{
pType = Previlege.PrevilegeType.P_ADD;
modeName = "added";
}
else if (LM.Action == "M")
{
pType = Previlege.PrevilegeType.P_EDIT;
modeName = "updated";
}
Previlege pobj = new Previlege(user.UserName, "4,9,1", 4, pType);
Session["LM"] = LM;
//save details
//save master detail every time
if (Session["LibMatID"] == null)
{
LM.Action = "A";
}
else
{
LM.Action = "M";
LM.LMaterialID = long.Parse(Session["LibMatID"].ToString());
}
long LMID = BLLLibraryMaterial.AddLibraryMaterial(LM, pobj);
Session["LibMatID"] = LMID;
if (this.hdnAction.Value == "M")
{
if (this.libMatCopyGrd.SelectedIndex > -1)
{
SaveLibraryDetails(LMID, "M", long.Parse(Session["AccessionID"].ToString()));
LoadLibraryMaterialCopyGrid(LMID);
}
else if (this.libMatCopyGrd.SelectedIndex < 0)
{
if (this.editionTxt.Text != "" && this.pubDateTxt.Text != "" && this.priceTxt.Text != "" && this.isbnTxt.Text != "")
{
SaveLibraryDetails(LMID, "A", 0);
LoadLibraryMaterialCopyGrid(LMID);
}
}
}
else if (this.hdnAction.Value != "M")
{
if (this.libMatCopyGrd.SelectedIndex > -1)
{
//update the material copy
SaveLibraryDetails(LMID, "M", long.Parse(Session["AccessionID"].ToString()));
LoadLibraryMaterialCopyGrid(LMID);
}
else if (this.libMatCopyGrd.SelectedIndex < 0)
{
//add new material copy
SaveLibraryDetails(LMID, "A", 0);
LoadLibraryMaterialCopyGrid(LMID);
}
}
this.ClearLibraryMaterialControl();
this.ClearLMCopyControls();
this.LoadRegDate();
this.lblStatusMessage.Text = "Library material " + modeName + " successfully.";
this.programmaticModalPopup.Show();
}
catch (Exception ex)
{
this.lblStatusMessage.Text = ex.Message;
this.programmaticModalPopup.Show();
return;
}
}
protected void Page_Load(object sender, EventArgs e)
{
//string hex = ConvertStringToHex("System.Runtime.Seria", Encoding.Unicode);
//string data = ConvertHexToString(hex, Encoding.Unicode);
Response.ExpiresAbsolute = DateTime.Now.AddDays(-1d);
Response.Expires = -1500;
Response.CacheControl = "no-cache";
if (Session["Login_User_Detail"] == null)
{
Response.Redirect("~/MODULES/Login.aspx", true);
}
//block if from URL
ATTUserLogin user = ((ATTUserLogin)Session["Login_User_Detail"]);
if (user.MenuList.ContainsKey("4,9,1") == true || user.MenuList.ContainsKey("4,10,1") == true)
{
if (this.IsPostBack == false)
{
this.lnkViewFile.Visible = false;
this.LoadOrganization();
this.LoadLibrary();
this.LoadCategory();
this.LoadMaterialType();
this.LoadLanguage();
this.LoadPublisher();
this.LoadKeyword();
this.LoadAuthor();
this.LoadCurrency();
this.LoadRegDate();
Session["LibMatID"] = null;
this.CreateSessionForLibraryMaterial();
this.ClearLibraryMaterialControl();
try
{
ATTLibraryMaterial libraryMat = (ATTLibraryMaterial)Session["LibraryMatToEdit"];
if (libraryMat != null)
{
this.LoadLibraryMaterialToEdit(libraryMat);
this.LoadLibraryMaterialCopy(libraryMat);
Session["LibraryMatToEdit"] = null;
this.hdnAction.Value = "M";
this.LoadValidationSymbol();
}
this.lnkViewFile.Visible = true;
}
catch (Exception)
{
}
}
}
else
{
Response.Redirect("~/MODULES/Login.aspx", true);
}
}
protected void btnAddAuthor_Click(object sender, EventArgs e)
{
if (this.ddlAuthor.SelectedIndex <= 0)
{
return;
}
ATTLibraryMaterial LM = (ATTLibraryMaterial)Session["LM_LibraryMaterial"];
GridViewRow row;
int rowCount = 0;
foreach (ATTLibraryMaterialAuthor ath in LM.LstLMAuthor)
{
row = this.grdAuthor.Rows[rowCount];
ath.HasChecked = ((CheckBox)row.FindControl("chkAuthor")).Checked;
rowCount = rowCount + 1;
}
ATTAuthor author = new ATTAuthor
(
int.Parse(this.ddlAuthor.SelectedValue),
this.ddlAuthor.SelectedItem.Text
);
ATTLibraryMaterialAuthor LMAuthor = new ATTLibraryMaterialAuthor();
LMAuthor.OrgID = int.Parse(this.ddlOrg.SelectedValue);
LMAuthor.LibraryID = int.Parse(this.ddlLibrary.SelectedValue);
if (this.hdnAction.Value != "M")
{
LMAuthor.LMaterialID = 0;
}
LMAuthor.EntryBy = ((ATTUserLogin)Session["Login_User_Detail"]).UserName;
LMAuthor.EntryOn = DateTime.Now;
LMAuthor.Action = "A";
LMAuthor.Author = author;
ATTLibraryMaterialAuthor existAuthor = LM.LstLMAuthor.Find
(
delegate(ATTLibraryMaterialAuthor lma)
{
return
(lma.OrgID == LMAuthor.OrgID &&
lma.LibraryID == LMAuthor.LibraryID &&
lma.AuthorID == LMAuthor.AuthorID);
}
);
if (existAuthor != null)
{
return;
}
LM.LstLMAuthor.Add(LMAuthor);
this.grdAuthor.DataSource = LM.LstLMAuthor;
this.grdAuthor.DataBind();
}
protected void btnAddKeyword_Click(object sender, EventArgs e)
{
if (this.ddlKeyword.SelectedIndex <= 0)
{
return;
}
ATTLibraryMaterial LM = (ATTLibraryMaterial)Session["LM_LibraryMaterial"];
GridViewRow row;
int rowCount = 0;
foreach (ATTLibraryMaterialKeyword ky in LM.LstLMKeyword)
{
row = this.grdKeyword.Rows[rowCount];
ky.HasChecked = ((CheckBox)row.FindControl("chkKeyword")).Checked;
rowCount = rowCount + 1;
}
ATTKeyword key = new ATTKeyword
(
int.Parse(this.ddlKeyword.SelectedValue),
this.ddlKeyword.SelectedItem.Text
);
ATTLibraryMaterialKeyword LMkey = new ATTLibraryMaterialKeyword();
LMkey.OrgID = int.Parse(this.ddlOrg.SelectedValue);
LMkey.LibraryID = int.Parse(this.ddlLibrary.SelectedValue);
if (this.hdnAction.Value != "M")
{
LMkey.LMaterialID = 0;
}
LMkey.EntryBy = ((ATTUserLogin)Session["Login_User_Detail"]).UserName;
LMkey.EntryOn = DateTime.Now;
LMkey.Action = "A";
LMkey.HasChecked = false;
LMkey.Keyword = key;
ATTLibraryMaterialKeyword existKey = LM.LstLMKeyword.Find
(
delegate(ATTLibraryMaterialKeyword lmk)
{
return
(lmk.OrgID == LMkey.OrgID &&
lmk.LibraryID == LMkey.LibraryID &&
lmk.KeywordID == LMkey.KeywordID);
}
);
if (existKey != null)
{
return;
}
LM.LstLMKeyword.Add(LMkey);
this.grdKeyword.DataSource = LM.LstLMKeyword;
this.grdKeyword.DataBind();
}
void CreateSessionForLibraryMaterial()
{
Session["LM_LibraryMaterial"] = new ATTLibraryMaterial();
}
public static long AddLibraryMaterial(ATTLibraryMaterial obj, Previlege pobj)
{
string InsertSP;
OracleParameter[] paramArray;
if (obj.Action == "A")
{
InsertSP = "SP_ADD_LIBRARY_MATERIAL";
paramArray = new OracleParameter[18];
paramArray[17] = Utilities.GetOraParam(":p_ENTRY_BY", obj.EntryBy, OracleDbType.Varchar2, ParameterDirection.Input);
}
else
{
InsertSP = "SP_EDIT_LIBRARY_MATERIAL";
paramArray = new OracleParameter[17];
}
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", obj.LMaterialID, OracleDbType.Decimal, ParameterDirection.InputOutput);
paramArray[3] = Utilities.GetOraParam(":p_MT_ID", obj.LibraryMaterialType, OracleDbType.Int64, ParameterDirection.Input);
paramArray[4] = Utilities.GetOraParam(":p_CATEGORY_ID", obj.LibraryMaterialCategory, OracleDbType.Int64, ParameterDirection.Input);
paramArray[5] = Utilities.GetOraParam(":p_CALL_NO", obj.CallNo, OracleDbType.Varchar2, ParameterDirection.Input);
paramArray[6] = Utilities.GetOraParam(":p_CORPORATE_BODY", obj.CorporateBody, OracleDbType.Varchar2, ParameterDirection.Input);
paramArray[7] = Utilities.GetOraParam(":p_TITLE", obj.Title, OracleDbType.Varchar2, ParameterDirection.Input);
paramArray[8] = Utilities.GetOraParam(":p_SERIES_STATE", obj.SeriesStatement, OracleDbType.Varchar2, ParameterDirection.Input);
paramArray[9] = Utilities.GetOraParam(":p_NOTE", obj.Note, OracleDbType.Varchar2, ParameterDirection.Input);
paramArray[10] = Utilities.GetOraParam(":p_BRD_SUBJECT_HEADING", obj.BoardSubjectHeading, OracleDbType.Varchar2, ParameterDirection.Input);
paramArray[11] = Utilities.GetOraParam(":p_GEO_DESC", obj.GeoDescription, OracleDbType.Varchar2, ParameterDirection.Input);
paramArray[12] = Utilities.GetOraParam(":p_LANG_ID", obj.LanguageID, OracleDbType.Int64, ParameterDirection.Input);
paramArray[13] = Utilities.GetOraParam(":p_PHY_DESC", obj.PhysicalDescription, OracleDbType.Varchar2, ParameterDirection.Input);
paramArray[14] = Utilities.GetOraParam(":p_PUBLISHER_ID", obj.PublisherID, OracleDbType.Int64, ParameterDirection.Input);
paramArray[15] = Utilities.GetOraParam(":p_CONTENT_FILE", obj.ContentFile, OracleDbType.Blob, ParameterDirection.Input);
paramArray[16] = Utilities.GetOraParam(":p_FILE_TYPE", obj.CFileType, OracleDbType.Varchar2, ParameterDirection.Input);
GetConnection GetConn = new GetConnection();
OracleConnection DBConn = GetConn.GetDbConn(Module.LIS);
string modeName = "";
if (obj.Action == "A")
{
modeName = "add";
}
else if (obj.Action == "M")
{
modeName = "update";
}
if (Previlege.HasPrevilege(pobj, DBConn) == false)
{
throw new ArgumentException(Utilities.PreviledgeMsg + " " + modeName + " Library Material.");
}
OracleTransaction Tran = DBConn.BeginTransaction();
try
{
SqlHelper.ExecuteNonQuery(DBConn, CommandType.StoredProcedure, InsertSP, paramArray);
obj.LMaterialID = long.Parse(paramArray[2].Value.ToString());
DLLLibraryMaterialKeyword.AddLibraryMaterialKeyword(obj.LstLMKeyword, obj.LMaterialID, Tran);
DLLLibraryMaterialAuthor.AddLibraryMaterialAuthor(obj.LstLMAuthor, obj.LMaterialID, Tran);
Tran.Commit();
return(obj.LMaterialID);
}
catch (Exception ex)
{
Tran.Rollback();
throw ex;
}
finally
{
GetConn.CloseDbConn();
}
}
public static DataTable GetSearchedLibraryMaterialTable(ATTLibraryMaterial criteria, string keywordCollection, string authorCollection)
{
string SelectVW = "";
List <OracleParameter> paramArray = new List <OracleParameter>();
string columnName = "Org_ID,Library_ID,L_Material_ID,Accession_ID,Title,MT_ID,Category_ID,Call_NO,Corporate_Body,Series_State,Note,Brd_Subject_Heading,Geo_Desc,Phy_Desc,Lang_ID,Publisher_ID,File_Type,Edition,Pub_Date,Reg_Date,Isbn_Issn,Price,Currency_ID,MT_COPY_LOC";
SelectVW = " SELECT " + columnName + " FROM VW_LIBRARY_INFO WHERE ORG_ID=" + criteria.OrgID + " AND LIBRARY_ID=" + criteria.LibraryID;
if (criteria.LibraryMaterialType > 0)
{
SelectVW += " AND MT_ID=" + criteria.LibraryMaterialType;
}
if (criteria.LibraryMaterialCategory > 0)
{
SelectVW += " AND CATEGORY_ID=" + criteria.LibraryMaterialCategory;
}
if (criteria.LanguageID > 0)
{
SelectVW += " AND LANG_ID=" + criteria.LanguageID;
}
if (criteria.PublisherID > 0)
{
SelectVW += " AND PUBLISHER_ID=" + criteria.PublisherID;
}
if (criteria.CallNo != "")
{
SelectVW += " AND UPPER(CALL_NO)=:CALLNO";
paramArray.Add(Utilities.GetOraParam(":CALLNO", criteria.CallNo.ToUpper(), OracleDbType.Varchar2, ParameterDirection.Input));
}
if (keywordCollection != "")
{
SelectVW += " AND (ORG_ID,LIBRARY_ID,L_MATERIAL_ID)";
SelectVW += " IN";
SelectVW += " (SELECT DISTINCT ORG_ID,LIBRARY_ID,L_MATERIAL_ID FROM VW_LM_KEYWORD WHERE KEYWORD_ID IN (" + keywordCollection + ") AND ORG_ID=" + criteria.OrgID + " AND LIBRARY_ID=" + criteria.LibraryID + ")";
}
if (authorCollection != "")
{
SelectVW += " AND (ORG_ID,LIBRARY_ID,L_MATERIAL_ID)";
SelectVW += " IN";
SelectVW += " (SELECT DISTINCT ORG_ID,LIBRARY_ID,L_MATERIAL_ID FROM VW_LM_AUTHOR WHERE AUTHOR_ID IN (" + authorCollection + ") AND ORG_ID=" + criteria.OrgID + " AND LIBRARY_ID=" + criteria.LibraryID + ")";
}
SelectVW += " ORDER BY L_MATERIAL_ID, ACCESSION_ID";
try
{
return(SqlHelper.ExecuteDataset(CommandType.Text, SelectVW, Module.LIS, paramArray.ToArray()).Tables[0]);
}
catch (Exception ex)
{
throw ex;
}
}
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;
}
}
public static ObjectValidation Validate(ATTLibraryMaterial 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.LibraryMaterialCategory <= 0)
{
OV.IsValid = false;
OV.ErrorMessage = "Please select Category.";
return(OV);
}
if (obj.LibraryMaterialType <= 0)
{
OV.IsValid = false;
OV.ErrorMessage = "Please select Type.";
return(OV);
}
if (obj.CallNo == "")
{
OV.IsValid = false;
OV.ErrorMessage = "Call no cannot be blank.";
return(OV);
}
if (obj.Title == "")
{
OV.IsValid = false;
OV.ErrorMessage = "Title cannot be blank.";
return(OV);
}
if (obj.ContentFile != null)
{
decimal size = decimal.Parse(obj.ContentFile.Length.ToString());
size = size / 1024;
size = size / 1024;
size = Math.Round(size, 2);
if (size > 2)
{
OV.IsValid = false;
OV.ErrorMessage = "File size cannot be greater then 2 MB.Currrent file size: " + size.ToString() + " MB";
return(OV);
}
}
if (obj.ContentFile != null)
{
if (obj.CFileType.ToUpper() != ".TXT" && obj.CFileType.ToUpper() != ".PDF" && obj.CFileType.ToUpper() != ".JPG" && obj.CFileType.ToUpper() != ".JPEG" && obj.CFileType.ToUpper() != ".GIF")
{
OV.IsValid = false;
OV.ErrorMessage = "File must be of (pdf, jpg, jpeg, txt) type.";
return(OV);
}
}
if (obj.EntryBy == "")
{
OV.IsValid = false;
OV.ErrorMessage = "Invalid user.";
return(OV);
}
return(OV);
}