public int Compare(object obj1, object obj2)
{
TitleItem item1 = (TitleItem)obj1;
TitleItem item2 = (TitleItem)obj2;
int ret = 0;
string s1 = "";
string s2 = "";
switch (_compareEnum)
{
case CompareEnum.ItemID:
{
ret = item1.ItemID.CompareTo(item2.ItemID);
break;
}
case CompareEnum.BarCode:
{
ret = TypeHelper.EmptyIfNull(item1.BarCode).CompareTo(
TypeHelper.EmptyIfNull(item2.BarCode));
break;
}
case CompareEnum.ItemSequence:
{
ret = (TypeHelper.ZeroIfNull((int?)item1.ItemSequence)).CompareTo(
(TypeHelper.ZeroIfNull((int?)item2.ItemSequence)));
break;
}
case CompareEnum.Volume:
{
ret = TypeHelper.EmptyIfNull(item1.Volume).CompareTo(
TypeHelper.EmptyIfNull(item2.Volume));
break;
}
}
if (_sortOrder == SortOrder.Descending)
{
ret = ret * -1;
}
return(ret);
}
/// <summary>
/// Update values in TitleItem. Returns an object of type TitleItem.
/// </summary>
/// <param name="sqlConnection">Sql connection or null.</param>
/// <param name="sqlTransaction">Sql transaction or null.</param>
/// <param name="connectionKeyName">Connection key name located in config file.</param>
/// <param name="value">Object of type TitleItem.</param>
/// <returns>Object of type TitleItem.</returns>
public TitleItem TitleItemUpdateAuto(
SqlConnection sqlConnection,
SqlTransaction sqlTransaction,
string connectionKeyName,
TitleItem value)
{
return TitleItemUpdateAuto(sqlConnection, sqlTransaction, connectionKeyName,
value.TitleItemID,
value.TitleID,
value.ItemID,
value.ItemSequence);
}
/// <summary>
/// Update values in TitleItem. Returns an object of type TitleItem.
/// </summary>
/// <param name="sqlConnection">Sql connection or null.</param>
/// <param name="sqlTransaction">Sql transaction or null.</param>
/// <param name="value">Object of type TitleItem.</param>
/// <returns>Object of type TitleItem.</returns>
public TitleItem TitleItemUpdateAuto(
SqlConnection sqlConnection,
SqlTransaction sqlTransaction,
TitleItem value)
{
return TitleItemUpdateAuto(sqlConnection, sqlTransaction, "BHL", value );
}
/// <summary>
/// Manage TitleItem object.
/// If the object is of type CustomObjectBase,
/// then either insert values into, delete values from, or update values in TitleItem.
/// </summary>
/// <param name="sqlConnection">Sql connection or null.</param>
/// <param name="sqlTransaction">Sql transaction or null.</param>
/// <param name="connectionKeyName">Connection key name located in config file.</param>
/// <param name="value">Object of type TitleItem.</param>
/// <returns>Object of type CustomDataAccessStatus<TitleItem>.</returns>
public CustomDataAccessStatus<TitleItem> TitleItemManageAuto(
SqlConnection sqlConnection,
SqlTransaction sqlTransaction,
string connectionKeyName,
TitleItem value)
{
if (value.IsNew && !value.IsDeleted)
{
TitleItem returnValue = TitleItemInsertAuto(sqlConnection, sqlTransaction, connectionKeyName,
value.TitleID,
value.ItemID,
value.ItemSequence);
return new CustomDataAccessStatus<TitleItem>(
CustomDataAccessContext.Insert,
true, returnValue);
}
else if (!value.IsNew && value.IsDeleted)
{
if (TitleItemDeleteAuto(sqlConnection, sqlTransaction, connectionKeyName,
value.TitleItemID))
{
return new CustomDataAccessStatus<TitleItem>(
CustomDataAccessContext.Delete,
true, value);
}
else
{
return new CustomDataAccessStatus<TitleItem>(
CustomDataAccessContext.Delete,
false, value);
}
}
else if (value.IsDirty && !value.IsDeleted)
{
TitleItem returnValue = TitleItemUpdateAuto(sqlConnection, sqlTransaction, connectionKeyName,
value.TitleItemID,
value.TitleID,
value.ItemID,
value.ItemSequence);
return new CustomDataAccessStatus<TitleItem>(
CustomDataAccessContext.Update,
true, returnValue);
}
else
{
return new CustomDataAccessStatus<TitleItem>(
CustomDataAccessContext.NA,
false, value);
}
}
/// <summary>
/// Manage TitleItem object.
/// If the object is of type CustomObjectBase,
/// then either insert values into, delete values from, or update values in TitleItem.
/// </summary>
/// <param name="sqlConnection">Sql connection or null.</param>
/// <param name="sqlTransaction">Sql transaction or null.</param>
/// <param name="value">Object of type TitleItem.</param>
/// <returns>Object of type CustomDataAccessStatus<TitleItem>.</returns>
public CustomDataAccessStatus<TitleItem> TitleItemManageAuto(
SqlConnection sqlConnection,
SqlTransaction sqlTransaction,
TitleItem value)
{
return TitleItemManageAuto( sqlConnection, sqlTransaction, "BHL", value );
}
protected void saveButton_Click(object sender, EventArgs e)
{
Item item = (Item)Session["Item" + itemIdTextBox.Text];
if ( validate( item ) )
{
// Gather up data on form
short? s = null;
int? i = null;
item.MARCItemID = marcItemIDTextBox.Text.Trim();
item.CallNumber = callNumberTextBox.Text.Trim();
item.Volume = volumeTextBox.Text.Trim();
item.InstitutionCode = (ddlInst.SelectedValue.Length == 0 ? null : ddlInst.SelectedValue);
item.LanguageCode = ( ddlLang.SelectedValue.Length == 0 ? null : ddlLang.SelectedValue );
item.Note = notesTextBox.Text.Trim();
item.Year = yearTextBox.Text.Trim();
item.IdentifierBib = identifierBibTextBox.Text.Trim();
item.ZQuery = zQueryTextBox.Text.Trim();
item.Sponsor = sponsorTextBox.Text.Trim();
item.LicenseUrl = licenseUrlTextBox.Text.Trim();
item.Rights = rightsTextBox.Text.Trim();
item.DueDiligence = dueDiligenceTextBox.Text.Trim();
item.CopyrightStatus = copyrightStatusTextBox.Text.Trim();
item.CopyrightRegion = copyrightRegionTextBox.Text.Trim();
item.CopyrightComment = copyrightCommentTextBox.Text.Trim();
item.CopyrightEvidence = copyrightEvidenceTextBox.Text.Trim();
item.VaultID = ( ddlVault.SelectedIndex == 0 ? i : int.Parse(ddlVault.SelectedValue) );
item.ItemStatusID = int.Parse( ddlItemStatus.SelectedValue );
item.IsNew = false;
//----------------------------------------
// Update the title information
CustomGenericList<ItemTitle> itemTitles = (CustomGenericList<ItemTitle>)Session["ItemTitleList" + itemIdTextBox.Text];
// Add new titles
foreach (ItemTitle itemTitle in itemTitles)
{
bool found = false;
foreach (TitleItem titleItem in item.TitleItems)
{
if (itemTitle.TitleID == titleItem.TitleID)
{
found = true;
break;
}
}
if (!found)
{
TitleItem newTitleItem = new TitleItem();
newTitleItem.TitleID = itemTitle.TitleID;
newTitleItem.ItemID = item.ItemID;
newTitleItem.ItemSequence = 1;
newTitleItem.IsNew = true;
item.TitleItems.Add(newTitleItem);
}
}
// Flag deleted titles
foreach (TitleItem titleItem in item.TitleItems)
{
bool found = false;
foreach (ItemTitle itemTitle in itemTitles)
{
if (titleItem.TitleID == itemTitle.TitleID)
{
found = true;
break;
}
}
if (!found) titleItem.IsDeleted = true;
}
//----------------------------------------
BHLProvider bp = new BHLProvider();
try
{
bp.ItemSave( item, 1 );
}
catch ( Exception ex )
{
Session[ "Exception" ] = ex;
Response.Redirect( "/Error.aspx" );
}
}
else
{
return;
}
litMessage.Text = "<span class='liveData'>Item Saved.</span>";
Page.MaintainScrollPositionOnPostBack = false;
//Response.Redirect("/Admin/Dashboard.aspx");
}