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"] == "SearchCmnDocListTableMapping")
{
TransactionReferenceList = new CustomList <CmnDocListTableMapping>();
CmnDocListTableMapping searchCmnDocListTableMapping = Session[STATIC.StaticInfo.SearchSessionVarName] as CmnDocListTableMapping;
TransactionReferenceList.Add(searchCmnDocListTableMapping);
if (searchCmnDocListTableMapping.IsNotNull())
{
PopulateTransactionReferenceInformation(searchCmnDocListTableMapping);
}
}
}
}
catch (Exception ex)
{
throw ex;
}
}
protected void btnSave_Click(object sender, EventArgs e)
{
try
{
CustomList <CmnDocListTableMapping> lstTransactionReference = TransactionReferenceList;
if (lstTransactionReference.Count == 0)
{
CmnDocListTableMapping newTransactionReference = new CmnDocListTableMapping();
lstTransactionReference.Add(newTransactionReference);
}
SetDataFromControlToObj(ref lstTransactionReference);
if (!CheckUserAuthentication(lstTransactionReference))
{
return;
}
_manager.SaveCmnDocListTableMapping(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 <CmnDocListTableMapping> lstTransactionReference)
{
try
{
CmnDocListTableMapping obj = lstTransactionReference[0];
// obj.DocListID= 0;
obj.ColumnName = ddlColumnName.SelectedItem.Text;
obj.ColumnType = lblColumnType.Text;
// obj.DocListTableMappingID = ddlTableName.SelectedValue.ToInt();
obj.TableName = ddlTableName.SelectedItem.Text;
// obj.TransactionTypeColumn = txtTransactionTypeColumn.Text;
obj.TableType = lblTableType.Text;
obj.DocListID = ddlDocList.SelectedValue.ToInt();
// obj.TransTypeID = ddlTransTypeName.SelectedValue.ToInt();
}
catch (Exception ex)
{
throw (ex);
}
}
private void PopulateTransactionReferenceInformation(CmnDocListTableMapping TransactionReference)
{
try
{
ddlTableName.SelectedValue = TransactionReference.TableName.ToString();
//ddlDetailForeignKey.SelectedValue = TransactionReference.DetailForeignKey.ToString();
ddlColumnName.DataSource = _manager.GetAllDetailForeignKey(TransactionReference.TableName.ToString());
ddlColumnName.DataTextField = "DetailForeignKey";
ddlColumnName.DataValueField = "DetailForeignKey";
ddlColumnName.DataBind();
ddlColumnName.Items.Insert(0, new ListItem(String.Empty, String.Empty));
ddlColumnName.SelectedIndex = 0;
ddlColumnName.SelectedValue = TransactionReference.ColumnName.ToString();
ddlDocList.SelectedValue = TransactionReference.DocListID.ToString();
lblTableType.Text = TransactionReference.TableType.ToString();
lblColumnType.Text = TransactionReference.ColumnType.ToString();
}
catch (Exception ex)
{
throw (ex);
}
}
public CustomList <CmnDocListTableMapping> GetAllCmnTransactionReferenceFind()
{
return(CmnDocListTableMapping.GetAllCmnTransactionReferenceFind());
}
