/// <summary>
/// Saves the NVP detail.
/// </summary>
/// <param name="nameValuePairDetailProfile">The profile.</param>
/// <returns>System.Int32.</returns>
public void SaveNameValuePairDetail(MNameValuePairDetail nameValuePairDetailProfile)
{
m_DNameValuePair.DetailProfile = nameValuePairDetailProfile;
if (DatabaseIsOnline())
{
m_DNameValuePair.SaveNVPDetail(nameValuePairDetailProfile);
}
}
void IDNameValuePair.SaveNVPDetail(MNameValuePairDetail profile)
{
string myStoreProcedure = "ZGWSystem.Set_Name_Value_Pair_Detail";
SqlParameter[] mParameters = { new SqlParameter("@P_NVP_Detail_SeqID", profile.Id), new SqlParameter("@P_NVP_SeqID", profile.NameValuePairSeqId), new SqlParameter("@P_NVP_Detail_Name", profile.Value), new SqlParameter("@P_NVP_Detail_Value", profile.Text), new SqlParameter("@P_Status_SeqID", profile.Status), new SqlParameter("@P_Sort_Order", profile.SortOrder), new SqlParameter("@P_Added_Updated_BY", GetAddedUpdatedBy(profile)),
GetSqlParameter("@P_Primary_Key", -1, ParameterDirection.Output), GetSqlParameter("@P_ErrorCode", -1, ParameterDirection.Output) };
base.ExecuteNonQuery(myStoreProcedure, mParameters);
}
/// <summary>
/// Deletes the NVP detail.
/// </summary>
/// <param name="detailProfile">The profile.</param>
/// <returns><c>true</c> if XXXX, <c>false</c> otherwise</returns>
public bool DeleteNameValuePairDetail(MNameValuePairDetail detailProfile)
{
bool mRetVal = false;
if (DatabaseIsOnline())
{
mRetVal = m_DNameValuePair.DeleteNVPDetail(detailProfile);
}
return(mRetVal);
}
/// <summary>
/// Saves the detail.
/// </summary>
/// <param name="profile">The profile.</param>
/// <returns>System.Int32.</returns>
public static void SaveDetail(MNameValuePairDetail profile)
{
if (profile == null)
{
throw new ArgumentNullException("profile", "profile cannot be a null reference (Nothing in Visual Basic)!");
}
MSecurityEntityProfile mSecurityProfile = SecurityEntityUtility.CurrentProfile();
BNameValuePairs mBNameValuePairs = new BNameValuePairs(mSecurityProfile);
CacheController.RemoveFromCache(CachedNameValuePairDetailsTableName);
mBNameValuePairs.SaveNameValuePairDetail(profile);
}
bool IDNameValuePair.DeleteNVPDetail(MNameValuePairDetail profile)
{
string myStoreProcedure = "ZGWSystem.Delete_Name_Value_Pair_Detail";
Boolean mRetVal = false;
SqlParameter[] mParameters = { new SqlParameter("@P_NVP_SeqID", profile.NameValuePairSeqId), new SqlParameter("@P_NVP_Detail_SeqID", profile.Id) };
try
{
base.ExecuteNonQuery(myStoreProcedure, mParameters);
mRetVal = true;
}
catch (Exception)
{
throw;
}
return(mRetVal);
}
/// <summary>
/// Gets the NVP detail.
/// </summary>
/// <param name="nameValuePairSeqDetailId">The NVP seq det ID.</param>
/// <param name="nameValuePairSeqId">The NVP seq ID.</param>
/// <returns>MNameValuePairDetail.</returns>
public static MNameValuePairDetail GetNameValuePairDetail(int nameValuePairSeqDetailId, int nameValuePairSeqId)
{
DataView mDataView = null;
DataTable mDataTable = null;
DataTable mImportTable = null;
MNameValuePairDetail mRetVal = null;
try
{
GetNameValuePairDetails(ref mDataTable, nameValuePairSeqId);
mDataTable.Locale = CultureInfo.InvariantCulture;
mDataView = mDataTable.DefaultView;
mImportTable = mDataTable.Clone();
mDataView.RowFilter = "NVP_SEQ_DET_ID = " + nameValuePairSeqDetailId;
foreach (DataRowView drv in mDataView)
{
mImportTable.ImportRow(drv.Row);
}
mRetVal = new MNameValuePairDetail(mImportTable.Rows[0]);
}
catch (Exception)
{
throw;
}
finally
{
if (mDataTable != null)
{
mDataTable.Dispose();
mDataTable = null;
}
if (mDataView != null)
{
mDataView.Dispose();
mDataView = null;
}
if (mImportTable != null)
{
mImportTable.Dispose();
mImportTable = null;
}
}
return(mRetVal);
}
public IHttpActionResult DeleteNameValuePairDetail(UINVPDetailProfile uiProfile)
{
string mRetVal = false.ToString();
String mAction = GWWebHelper.GetQueryValue(HttpContext.Current.Request, "Action");
int mEditId = int.Parse(HttpContext.Current.Items["EditId"].ToString());
MAccountProfile mUpdatingAccount = AccountUtility.CurrentProfile();
MSecurityInfo mSecurityInfo = new MSecurityInfo(FunctionUtility.GetProfile(mAction), mUpdatingAccount);
Logger mLog = Logger.Instance();
if (mEditId != uiProfile.NVP_SEQ_DET_ID)
{
Exception mError = new Exception("Identifier you have last looked at does not match the one passed in nothing has been saved!!!!");
mLog.Error(mError);
return(this.InternalServerError(mError));
}
if (!mSecurityInfo.MayDelete)
{
Exception mError = new Exception("The account (" + mUpdatingAccount.Account + ") being used does not have the correct permissions to delete");
mLog.Error(mError);
return(this.InternalServerError(mError));
}
try
{
MNameValuePairDetail mProfile = new MNameValuePairDetail();
mProfile.NameValuePairSeqId = uiProfile.NVP_SEQ_ID;
mProfile.Id = uiProfile.NVP_SEQ_DET_ID;
mProfile.UpdatedBy = mUpdatingAccount.Id;
mProfile.UpdatedDate = DateTime.Now;
mProfile.SortOrder = uiProfile.SortOrder;
mProfile.Text = uiProfile.Text;
mProfile.Value = uiProfile.Value;
mProfile.Status = uiProfile.Status;
NameValuePairUtility.DeleteDetail(mProfile);
}
catch (Exception ex)
{
mLog.Error(ex);
throw;
}
return(this.Ok(mRetVal));
}
protected void Page_Load(object sender, EventArgs e)
{
string NVP_SEQ_ID = GWWebHelper.GetQueryValue(Request, "NVP_SEQ_ID");
string NVP_Detail_SeqID = GWWebHelper.GetQueryValue(Request, "NVP_Detail_SeqID");
MNameValuePairDetail mProfile = new MNameValuePairDetail();
if (!String.IsNullOrEmpty(NVP_SEQ_ID) && !String.IsNullOrEmpty(NVP_Detail_SeqID))
{
int mSeqId = int.Parse(NVP_SEQ_ID);
int mSeqDetId = int.Parse(NVP_Detail_SeqID);
if (mSeqDetId != -1)
{
mProfile = NameValuePairUtility.GetNameValuePairDetail(mSeqDetId, mSeqId);
}
hdnNVP_SEQ_ID.Value = mSeqId.ToString();
hdnNVP_SEQ_DET_ID.Value = mProfile.Id.ToString();
txtValue.Value = mProfile.Value;
txtText.Value = mProfile.Text;
txtSortOrder.Value = mProfile.SortOrder.ToString();
HttpContext.Current.Session.Add("EditId", mProfile.Id);
}
HttpContext.Current.Session.Add("EditId", mProfile.Id);
}
