private void PopulateTransactionReferenceInformation(CmnTransactionReference TransactionReference)
{
try
{
if (TransactionReference.TransRefID != 0)
{
ddlReferenceMasterTable.SelectedValue = TransactionReference.ReferenceMasterTable.ToString();
}
//ddlDetailForeignKey.SelectedValue = TransactionReference.DetailForeignKey.ToString();
ddlDetailForeignKey.DataSource = _manager.GetAllDetailForeignKey(TransactionReference.ReferenceDetailTable.ToString());
ddlDetailForeignKey.DataTextField = "DetailForeignKey";
ddlDetailForeignKey.DataValueField = "DetailForeignKey";
ddlDetailForeignKey.DataBind();
ddlDetailForeignKey.Items.Insert(0, new ListItem(String.Empty, String.Empty));
ddlDetailForeignKey.SelectedIndex = 0;
ddlDetailForeignKey.SelectedValue = TransactionReference.DetailForeignKey.ToString();
ddlReferenceDetailTable.SelectedValue = TransactionReference.ReferenceDetailTable.ToString();
ddlTransactionReferenceName.SelectedValue = TransactionReference.TransRefID.ToString();
ddlTransTypeName.SelectedValue = TransactionReference.TransTypeID.ToString();
txtTransactionTypeColumn.Text = TransactionReference.TransactionTypeColumn.ToString();
}
catch (Exception ex)
{
throw (ex);
}
}
protected void Page_Load(object sender, EventArgs e)
{
try
{
if (IsPostBack.IsFalse())
{
InitializeCombo();
InitializeSession();
}
else
{
Page.ClientScript.GetPostBackEventReference(this, String.Empty);
String eventTarget = Request["__EVENTTARGET"].IsNullOrEmpty() ? String.Empty : Request["__EVENTTARGET"];
if (Request["__EVENTTARGET"] == "SearchTransactionReference")
{
TransactionReferenceList = new CustomList <CmnTransactionReference>();
CmnTransactionReference searchCmnTransactionReference = Session[STATIC.StaticInfo.SearchSessionVarName] as CmnTransactionReference;
TransactionReferenceList.Add(searchCmnTransactionReference);
if (searchCmnTransactionReference.IsNotNull())
{
PopulateTransactionReferenceInformation(searchCmnTransactionReference);
}
}
}
}
catch (Exception ex)
{
throw ex;
}
}
protected void btnSave_Click(object sender, EventArgs e)
{
try
{
CustomList <CmnTransactionReference> lstTransactionReference = TransactionReferenceList;
if (lstTransactionReference.Count == 0)
{
CmnTransactionReference newTransactionReference = new CmnTransactionReference();
lstTransactionReference.Add(newTransactionReference);
}
SetDataFromControlToObj(ref lstTransactionReference);
if (!CheckUserAuthentication(lstTransactionReference))
{
return;
}
_manager.SaveTransactionReference(ref lstTransactionReference);
((PageBase)this.Page).SuccessMessage = (StaticInfo.SavedSuccessfullyMsg);
}
catch (SqlException ex)
{
((PageBase)this.Page).ErrorMessage = (ExceptionHelper.getSqlExceptionMessage(ex));
}
catch (Exception ex)
{
((PageBase)this.Page).ErrorMessage = (ExceptionHelper.getExceptionMessage(ex));
}
}
private void SetDataFromControlToObj(ref CustomList <CmnTransactionReference> lstTransactionReference)
{
try
{
CmnTransactionReference obj = lstTransactionReference[0];
obj.CustomCode = "0";
obj.ReferenceName = "0";
obj.TypeName = "0";
obj.TransRefID = ddlReferenceMasterTable.SelectedValue.ToInt();
obj.ReferenceMasterTable = ddlReferenceMasterTable.SelectedItem.Text;
obj.ReferenceDetailTable = ddlReferenceDetailTable.SelectedItem.Text;
obj.TransactionTypeColumn = txtTransactionTypeColumn.Text;
obj.DetailForeignKey = ddlDetailForeignKey.SelectedItem.Text;
obj.TransRefID = ddlTransactionReferenceName.SelectedValue.ToInt();
obj.TransTypeID = ddlTransTypeName.SelectedValue.ToInt();
}
catch (Exception ex)
{
throw (ex);
}
}
public CustomList <CmnTransactionReference> GetAllDetailForeignKey(string referenceDetailTable)
{
return(CmnTransactionReference.GetAllDetailForeignKey(referenceDetailTable));
}
public CustomList <CmnTransactionReference> GetAllCmnTransactionReferenceFind()
{
return(CmnTransactionReference.GetAllCmnTransactionReferenceFind());
}
public CustomList <CmnTransactionReference> GetAllReferenceMasterTable()
{
return(CmnTransactionReference.GetAllReferenceMasterTable());
}
public CustomList <CmnTransactionReference> GetAllReferenceType()
{
return(CmnTransactionReference.GetAllReferenceType());
}
public CustomList <CmnTransactionReference> GetAllReferenceType(Int32 TransRefID)
{
return(CmnTransactionReference.GetAllReferenceType(TransRefID));
}
