protected void ddlSpType_SelectedIndexChanged(object sender, EventArgs e)
{
string sSPTypeID = ddlSpType.SelectedValue;
TotalClear();
if (!string.IsNullOrEmpty(sSPTypeID))
{
ddlSpType.Text = sSPTypeID;
LoadCurrencyBySPType(ddlSpType.SelectedValue);
SPTypeDAL oSPTypeDAL = new SPTypeDAL();
Result oResult = oSPTypeDAL.GetCurrencyBySPTypeID(ddlSpType.SelectedValue);
if (oResult.Status)
{
SPType oSPType = oResult.Return as SPType;
ViewState[_BASE_CURRENCY] = oSPType.Currency.CurrencyID;
}
if (ddlSpType.SelectedValue.Equals(Constants.SP_TYPE_DIB) ||
ddlSpType.SelectedValue.Equals(Constants.SP_TYPE_DPB))
{
txtCovRateToBC.Enabled = true;
txtCovRateToBC.Text = "1.0000";
}
else
{
txtCovRateToBC.Text = "1.0000";
txtCovRateToBC.Enabled = false;
}
}
//txtReimConvRate.Text = string.Empty;
txtReimConvRate.Enabled = true;
txtBBReferenceNo.Focus();
}
protected void btnSearch_Click(object sender, EventArgs e)
{
SPType oSPType = new SPType();
SPTypeDAL oSPTypeDAL = new SPTypeDAL();
Result oResult = oSPTypeDAL.SearchList(txtSPTypeID.Text, txtDescription.Text, txtDenom.Text, txtReOrderLevel.Text);
DataTable dtTmpList = null;
ScriptManager.RegisterStartupScript(this.upSuccess, typeof(string), Constants.POPUP_WINDOW, " HideProgressStatus('ctl00_cphDet_ucSearchSPType_lblProgress') ", true);
if (oResult.Status)
{
dtTmpList = (DataTable)oResult.Return;
if (dtTmpList.Rows.Count > 0)
{
gvSearchList.DataSource = dtTmpList;
gvSearchList.DataBind();
}
else
{
gvSearchList.DataSource = null;
gvSearchList.DataBind();
}
}
Session[Constants.SES_CONFIG_APPROVE_DATA] = dtTmpList;
}
/// <summary>
/// Method to execute a stored procedure against the dataservice
/// </summary>
/// <param name="record"></param>
/// <param name="spType"></param>
/// <returns></returns>
protected async Task <DbTaskResult> RunStoredProcedure(TRecord record, SPType spType)
{
var ret = new DbTaskResult()
{
Message = $"Error saving {this.RecordConfiguration.RecordDescription}",
IsOK = false,
Type = MessageType.Error
};
var spname = spType switch
{
SPType.Create => this.RecordInfo.CreateSP,
SPType.Update => this.RecordInfo.UpdateSP,
SPType.Delete => this.RecordInfo.DeleteSP,
_ => string.Empty
};
var parms = this.GetSQLParameters(record, spType);
if (await this.DBContext.CreateDbContext().ExecStoredProcAsync(spname, parms))
{
var idparam = parms.FirstOrDefault(item => item.Direction == ParameterDirection.Output && item.SqlDbType == SqlDbType.Int && item.ParameterName.Contains("ID"));
ret = new DbTaskResult()
{
Message = $"{this.RecordConfiguration.RecordDescription} saved",
IsOK = true,
Type = MessageType.Success
};
if (idparam != null)
{
ret.NewID = Convert.ToInt32(idparam.Value);
}
}
return(ret);
}
private void LoadDenomDetailData(string sTypeID, string sDenomID, SPTypeList spList)
{
if (spList != null)
{
if (spList.ListOfSPType.Count > 0)
{
SPType oSpType = null;
for (int i = 0; i < spList.ListOfSPType.Count; i++)
{
oSpType = (SPType)spList.ListOfSPType[i];
if (sTypeID.Equals(oSpType.SPTypeID.Trim()))
{
for (int j = 0; j < oSpType.ListOfDenomination.Denomination.Count; j++)
{
Denomination oDenomination = oSpType.ListOfDenomination.Denomination[j];
if (oDenomination.DenominationID == Convert.ToInt32(sDenomID))
{
txtDenomination.Text = oDenomination.DenominationID.ToString();
txtReOrderLevel.Text = oDenomination.ReOrderLevel.ToString().Trim();
txtSeries.Text = oDenomination.Series.ToString().Trim();
txtNoOfDigitInSeries.Text = oDenomination.NoOfDigitsInSeries.ToString().Trim();
//ucUserDet.UserDetail = oDenomination.UserDetail;
hdDenomID.Value = oDenomination.DenominationID.ToString();
}
}
}
}
}
}
}
public static string GetSPName(string aplicacion, string entidad, SPType sptype)
{
const string FORMATO = "{0}_{1}_{2}";
string postfix = "";
switch (sptype)
{
case SPType.Select:
postfix = "S";
break;
case SPType.Delete:
postfix = "D";
break;
case SPType.Insert:
postfix = "I";
break;
case SPType.Update:
postfix = "U";
break;
}
return(string.Format(FORMATO, aplicacion.ToUpper(), entidad, postfix));
}
protected void gvDenom_RowCommand(object sender, GridViewCommandEventArgs e)
{
GridViewRow gvRow = (GridViewRow)((Button)e.CommandSource).NamingContainer;
SPType oSPType = (SPType)Session[Constants.SES_SPTYPE];
if (((Button)e.CommandSource).Text.Equals("Select"))
{
txtDenomination.Enabled = false;
txtSeries.Enabled = false;
LoadDenomDetailData(gvRow.Cells[2].Text.Trim());
}
else if (((Button)e.CommandSource).Text.Equals("Delete"))
{
if (oSPType.ListOfDenomination.Denomination.Count > 0)
{
hdSPTypeID.Value = gvRow.Cells[2].Text.Trim();
hdDenomID.Value = gvRow.Cells[3].Text.Trim();
Denomination oDenomination = oSPType.ListOfDenomination.Denomination.Where(d => d.DenominationID.Equals(Convert.ToInt32(hdDenomID.Value))).SingleOrDefault();
if (oDenomination != null)
{
oSPType.ListOfDenomination.Denomination.Remove(oDenomination);
}
Session[Constants.SES_SPTYPE] = oSPType;
ReloadDenomTmpListFromSession();
ResetDenom();
}
}
}
private void SetSPType(SPType oSpType)
{
txtSpTypeId.Text = oSpType.SPTypeID.ToString().Trim();
txtDescription.Text = oSpType.TypeDesc.ToString().Trim();
ddlCurrency.Text = oSpType.Currency.CurrencyID.Trim();
hdSPTypeID.Value = oSpType.SPTypeID.ToString().Trim();
if (string.IsNullOrEmpty(hdDataType.Value))
{
//When Loading from Approver End
UserDetails userDetails = ucUserDet.UserDetail;
userDetails.MakerID = oSpType.UserDetails.MakerID;
userDetails.MakeDate = oSpType.UserDetails.MakeDate;
ucUserDet.UserDetail = userDetails;
}
else if (hdDataType.Value.Equals("T"))
{
//When loading from temp table
UserDetails userDetails = ucUserDet.UserDetail;
userDetails.CheckDate = oSpType.UserDetails.CheckDate;
userDetails.CheckerID = oSpType.UserDetails.CheckerID;
userDetails.CheckDate = oSpType.UserDetails.CheckDate;
userDetails.CheckerComment = oSpType.UserDetails.CheckerComment;
ucUserDet.UserDetail = userDetails;
}
DataTable oDataTable = new DataTable("dtData");
oDataTable.Columns.Add(new DataColumn("bfDenomSPType", typeof(string)));
oDataTable.Columns.Add(new DataColumn("bfDenomination", typeof(string)));
oDataTable.Columns.Add(new DataColumn("bfSPSeries", typeof(string)));
oDataTable.Columns.Add(new DataColumn("bfDigitsInSlNo", typeof(string)));
oDataTable.Columns.Add(new DataColumn("bfReOrderLevel", typeof(string)));
DataRow row = null;
gvDenom.DataSource = null;
gvDenom.DataBind();
if (oSpType.ListOfDenomination.Denomination.Count > 0)
{
for (int j = 0; j < oSpType.ListOfDenomination.Denomination.Count; j++)
{
Denomination oDenomination = (Denomination)oSpType.ListOfDenomination.Denomination[j];
row = oDataTable.NewRow();
row["bfDenomSPType"] = oSpType.SPTypeID.ToString();
row["bfDenomination"] = oDenomination.DenominationID.ToString();
row["bfSPSeries"] = oDenomination.Series.ToString();
row["bfDigitsInSlNo"] = oDenomination.NoOfDigitsInSeries.ToString();
row["bfReOrderLevel"] = oDenomination.ReOrderLevel.ToString();
oDataTable.Rows.Add(row);
}
gvDenom.DataSource = oDataTable;
gvDenom.DataBind();
}
}
private void LoadDenomDataListBySPTypeID(string spTYpeID, SPTypeList spList)
{
gvDenom.DataSource = null;
gvDenom.DataBind();
if (!string.IsNullOrEmpty(spTYpeID) && spList != null)
{
if (spList.ListOfSPType.Count > 0)
{
DataTable oDataTable = new DataTable("dtData");
oDataTable.Columns.Add(new DataColumn("bfDenomSPType", typeof(string)));
oDataTable.Columns.Add(new DataColumn("bfDenomination", typeof(string)));
oDataTable.Columns.Add(new DataColumn("bfSPSeries", typeof(string)));
oDataTable.Columns.Add(new DataColumn("bfDigitsInSlNo", typeof(string)));
oDataTable.Columns.Add(new DataColumn("bfReOrderLevel", typeof(string)));
DataRow row = null;
SPType oSpType = spTypeList.ListOfSPType.Where(d => d.SPTypeID.Equals(spTYpeID)).SingleOrDefault();
if (oSpType != null)
{
if (oSpType.ListOfDenomination.Denomination.Count > 0)
{
for (int j = 0; j < oSpType.ListOfDenomination.Denomination.Count; j++)
{
Denomination oDenomination = (Denomination)oSpType.ListOfDenomination.Denomination[j];
row = oDataTable.NewRow();
row["bfDenomSPType"] = oSpType.SPTypeID.ToString();
row["bfDenomination"] = oDenomination.DenominationID.ToString();
row["bfSPSeries"] = oDenomination.Series.ToString();
row["bfDigitsInSlNo"] = oDenomination.NoOfDigitsInSeries.ToString();
row["bfReOrderLevel"] = oDenomination.ReOrderLevel.ToString();
oDataTable.Rows.Add(row);
}
}
}
//
else
{
}
gvDenom.DataSource = oDataTable;
gvDenom.DataBind();
}
else
{
ucMessage.OpenMessage(Constants.MSG_ERROR_NOT_FOUND, Constants.MSG_TYPE_ERROR);
}
}
else
{
ucMessage.OpenMessage(Constants.MSG_ERROR_NOT_FOUND, Constants.MSG_TYPE_ERROR);
}
}
protected void btnSave_Click(object sender, EventArgs e)
{
if (!string.IsNullOrEmpty(hdDataType.Value))
{
SPType oSPType = (SPType)Session[Constants.SES_SPTYPE];
if (oSPType == null)
{
oSPType = new SPType();
}
SPTypeDAL oSPTypeDAL = new SPTypeDAL();
oSPType.SPTypeID = Request[txtSpTypeId.UniqueID].Trim().ToUpper();
oSPType.TypeDesc = txtDescription.Text.Trim().ToUpper();
if (!string.IsNullOrEmpty(ddlCurrency.SelectedValue))
{
oSPType.Currency.CurrencyID = ddlCurrency.SelectedValue;
}
oSPType.UserDetails = ucUserDet.UserDetail;
oSPType.UserDetails.MakeDate = DateTime.Now;
ucUserDet.ResetData();
Result oResult = (Result)oSPTypeDAL.Save(oSPType);
if (oResult.Status)
{
ReloadList(oSPTypeDAL, oSPType.SPTypeID);
ClearTextValue();
ResetDenom();
hdDenomID.Value = string.Empty;
hdSPTypeID.Value = string.Empty;
ucMessage.OpenMessage(Constants.MSG_SUCCESS_SAVE, Constants.MSG_TYPE_SUCCESS);
}
else
{
ucMessage.OpenMessage(Constants.MSG_ERROR_SAVE, Constants.MSG_TYPE_ERROR);
}
}
else
{
ucMessage.OpenMessage(Constants.MSG_APPROVED_SAVE_DATA, Constants.MSG_TYPE_INFO);
ScriptManager.RegisterStartupScript(this.UpdatePanel2, typeof(string), Constants.POPUP_WINDOW, Util.OpenPopup("info"), true);
ClearTextValue();
ResetDenom();
hdDenomID.Value = string.Empty;
hdSPTypeID.Value = string.Empty;
}
}
/// <summary>
/// Method that sets up the SQL Stored Procedure Parameters
/// </summary>
/// <param name="item"></param>
/// <param name="withid"></param>
/// <returns></returns>
protected virtual List <SqlParameter> GetSQLParameters(TRecord record, SPType spType)
{
var parameters = new List <SqlParameter>();
foreach (var prop in RecordInfo.SPProperties)
{
var attr = prop.GetCustomAttribute <SPParameterAttribute>();
attr.CheckName(prop);
// If its a delete we only need the ID and then break out of the for
if (attr.IsID && spType == SPType.Delete)
{
parameters.Add(new SqlParameter(attr.ParameterName, attr.DataType)
{
Direction = ParameterDirection.Input, Value = prop.GetValue(record)
});
break;
}
// skip if its a delete
if (spType != SPType.Delete)
{
// if its a create add the ID as an output foe capturing the new ID
if (attr.IsID && spType == SPType.Create)
{
parameters.Add(new SqlParameter(attr.ParameterName, attr.DataType)
{
Direction = ParameterDirection.Output
});
}
// Deal with dates
else if (attr.DataType == SqlDbType.SmallDateTime)
{
parameters.Add(new SqlParameter(attr.ParameterName, attr.DataType)
{
Direction = ParameterDirection.Input, Value = ((DateTime)prop.GetValue(record)).ToString("dd-MMM-yyyy")
});
}
else
{
parameters.Add(new SqlParameter(attr.ParameterName, attr.DataType)
{
Direction = ParameterDirection.Input, Value = prop.GetValue(record)
});
}
}
}
return(parameters);
}
private void ReloadDenomTmpListFromSession()
{
SPType oSPType = (SPType)Session[Constants.SES_SPTYPE];
DataTable oDataTable = new DataTable("dtData");
oDataTable.Columns.Add(new DataColumn("bfDenomSPType", typeof(string)));
oDataTable.Columns.Add(new DataColumn("bfDenomination", typeof(string)));
oDataTable.Columns.Add(new DataColumn("bfSPSeries", typeof(string)));
oDataTable.Columns.Add(new DataColumn("bfDigitsInSlNo", typeof(string)));
oDataTable.Columns.Add(new DataColumn("bfReOrderLevel", typeof(string)));
string sSPTypeTmp = oSPType.SPTypeID;
if (string.IsNullOrEmpty(sSPTypeTmp))
{
sSPTypeTmp = txtSpTypeId.Text;
}
if (string.IsNullOrEmpty(sSPTypeTmp))
{
sSPTypeTmp = "Not Define Yet";
}
DataRow row = null;
if (oSPType.ListOfDenomination.Denomination.Count > 0)
{
for (int j = 0; j < oSPType.ListOfDenomination.Denomination.Count; j++)
{
Denomination oDenomination = (Denomination)oSPType.ListOfDenomination.Denomination[j];
row = oDataTable.NewRow();
//row["bfDenomSPType"] = oSPType.SPTypeID == "" ? "Not Define Yet" : oSPType.SPTypeID.ToString();
row["bfDenomSPType"] = sSPTypeTmp;
row["bfDenomination"] = oDenomination.DenominationID.ToString();
row["bfSPSeries"] = oDenomination.Series.ToString();
row["bfDigitsInSlNo"] = oDenomination.NoOfDigitsInSeries.ToString();
row["bfReOrderLevel"] = oDenomination.ReOrderLevel.ToString();
oDataTable.Rows.Add(row);
}
}
gvDenom.DataSource = oDataTable;
gvDenom.DataBind();
}
protected void btnApprove_Click(object sender, EventArgs e)
{
SPTypeDAL oSPTypeDAL = new SPTypeDAL();
SPType oSPType = new SPType(hdSPTypeID.Value);
oSPType.UserDetails = ucUserDet.UserDetail;
Result oResult = (Result)oSPTypeDAL.Approve(oSPType);
if (oResult.Status)
{
ucMessage.OpenMessage(Constants.MSG_SUCCESS_APPROVE, Constants.MSG_TYPE_SUCCESS);
}
else
{
ucMessage.OpenMessage(Constants.MSG_ERROR_APPROVE, Constants.MSG_TYPE_ERROR);
}
}
public void SPLoadAction(string sSPTypeID)
{
if (!string.IsNullOrEmpty(sSPTypeID))
{
SPTypeDAL oSpTypeDal = new SPTypeDAL();
Result oResult = oSpTypeDal.LoadByID(sSPTypeID);
if (oResult.Status)
{
SPType oSpType = (SPType)oResult.Return;
if (oSpType != null)
{
hdDataType.Value = oResult.Message;
SetSPType(oSpType);
Session[Constants.SES_SPTYPE] = oSpType;
}
}
}
}
protected void gvList_RowCommand(object sender, GridViewCommandEventArgs e)
{
if (!e.CommandName.Equals("Page"))
{
GridViewRow gvRow = (GridViewRow)((Button)e.CommandSource).NamingContainer;
spTypeList = (SPTypeList)Session[Constants.SES_SPTYPELIST];
SPType oSpType = new SPType();
if (spTypeList != null)
{
oSpType = spTypeList.ListOfSPType.Where(d => d.SPTypeID.Equals(gvRow.Cells[1].Text.Trim())).SingleOrDefault();
Session[Constants.SES_SPTYPE] = oSpType;
ReloadDenomTmpListFromSession();
hdDataType.Value = "T";
LoadSPDetailData(gvRow.Cells[1].Text.Trim(), spTypeList);
ResetDenom();
}
}
}
private void LoadDenomDetailData(string sDenomID)
{
SPType oSPType = (SPType)Session[Constants.SES_SPTYPE];
if (oSPType != null)
{
Denomination oDenomination = oSPType.ListOfDenomination.Denomination.Where(d => d.DenominationID.Equals(Convert.ToInt32(sDenomID))).SingleOrDefault();
if (oDenomination != null)
{
if (oDenomination.DenominationID == Convert.ToInt32(sDenomID))
{
txtDenomination.Text = oDenomination.DenominationID.ToString();
txtReOrderLevel.Text = oDenomination.ReOrderLevel.ToString().Trim();
txtSeries.Text = oDenomination.Series.ToString().Trim();
txtNoOfDigitInSeries.Text = oDenomination.NoOfDigitsInSeries.ToString().Trim();
hdDenomID.Value = oDenomination.DenominationID.ToString();
}
}
}
}
protected void btnLoad_Click(object sender, EventArgs e)
{
if (!string.IsNullOrEmpty(Request[txtSpTypeId.UniqueID].Trim().ToUpper()))
{
spTypeList = (SPTypeList)Session[Constants.SES_SPTYPELIST];
string sTmp = Request[txtSpTypeId.UniqueID].Trim().ToUpper();
ClearTextValue();
SPType oSpType = spTypeList.ListOfSPType.Where(d => d.SPTypeID.Equals(sTmp.Trim())).SingleOrDefault();
if (oSpType != null)
{
LoadDenomDataListBySPTypeID(sTmp, spTypeList);
LoadSPDetailData(sTmp, spTypeList);
txtSpTypeId.Text = sTmp;
Session[Constants.SES_SPTYPE] = oSpType;
}
else
{
SPLoadAction(sTmp);
}
}
}
private void LoadSPDataList(SPTypeList spList)
{
if (spList != null)
{
if (spList.ListOfSPType.Count > 0)
{
DataTable oDataTable = new DataTable("dtData");
oDataTable.Columns.Add(new DataColumn("bfSpType", typeof(string)));
oDataTable.Columns.Add(new DataColumn("bfTypeDesc", typeof(string)));
oDataTable.Columns.Add(new DataColumn("bfCurrencyCode", typeof(string)));
oDataTable.Columns.Add(new DataColumn("MakeDate", typeof(DateTime)));
DataRow row = null;
SPType oSpType = null;
for (int i = 0; i < spList.ListOfSPType.Count; i++)
{
oSpType = (SPType)spList.ListOfSPType[i];
row = oDataTable.NewRow();
row["bfSpType"] = oSpType.SPTypeID;
row["bfTypeDesc"] = oSpType.TypeDesc;
row["bfCurrencyCode"] = oSpType.Currency.CurrencyCode;
row["MakeDate"] = oSpType.UserDetails.MakeDate.ToString("dd-MMM-yyyy");
oDataTable.Rows.Add(row);
}
gvList.DataSource = oDataTable;
gvList.DataBind();
}
else
{
gvList.DataSource = null;
gvList.DataBind();
}
}
else
{
ucMessage.OpenMessage(Constants.MSG_ERROR_NOT_FOUND, Constants.MSG_TYPE_ERROR);
}
}
private void LoadSPDetailData(string sSpTypeId, SPTypeList spList)
{
if (spList != null)
{
if (spList.ListOfSPType.Count > 0)
{
SPType oSpType = null;
for (int i = 0; i < spList.ListOfSPType.Count; i++)
{
oSpType = (SPType)spList.ListOfSPType[i];
if (sSpTypeId.Equals(oSpType.SPTypeID.Trim()))
{
txtSpTypeId.Text = oSpType.SPTypeID.ToString().Trim();
txtSpTypeId.ReadOnly = true;
txtDescription.Text = oSpType.TypeDesc.ToString().Trim();
ddlCurrency.Text = oSpType.Currency.CurrencyID.Trim();
hdSPTypeID.Value = oSpType.SPTypeID.ToString().Trim();
ucUserDet.UserDetail = oSpType.UserDetails;
}
}
}
}
}
protected void btnSaveDenom_Click(object sender, EventArgs e)
{
SPType oSPType = (SPType)Session[Constants.SES_SPTYPE];
Result oResult = new Result();
bool isExist = false;
// need to check first for adding can be possible or not...
SPTypeDAL oSPTypeDAL = new SPTypeDAL();
if (oSPType.ListOfDenomination.Denomination.Count > 0)
{
Denomination oDenomSerRemove = oSPType.ListOfDenomination.Denomination.Where(d => d.Series.Equals(txtSeries.Text)).SingleOrDefault();
Denomination oDenomRemove = oSPType.ListOfDenomination.Denomination.Where(d => d.DenominationID.Equals(Convert.ToInt32(txtDenomination.Text))).SingleOrDefault();
if (oDenomSerRemove != null && oDenomRemove == null)
{
isExist = true;
}
}
if (!isExist)
{
oResult = oSPTypeDAL.IsExistSeriesName(txtSeries.Text);
if (oResult.Status)
{
isExist = (bool)oResult.Return;
}
}
if (!isExist)
{
if (oSPType != null)
{
if (oSPType.ListOfDenomination.Denomination.Count > 0)
{
Denomination oDenomRemove = oSPType.ListOfDenomination.Denomination.Where(d => d.DenominationID.Equals(Convert.ToInt32(txtDenomination.Text))).SingleOrDefault();
if (oDenomRemove != null)
{
oSPType.ListOfDenomination.Denomination.Remove(oDenomRemove);
}
}
}
else
{
oSPType = new SPType();
}
Denomination oDenomination = new Denomination();
oDenomination.DenominationID = Util.GetIntNumber(txtDenomination.Text);
oDenomination.NoOfDigitsInSeries = Util.GetIntNumber(txtNoOfDigitInSeries.Text);
oDenomination.ReOrderLevel = Util.GetIntNumber(txtReOrderLevel.Text);
oDenomination.Series = txtSeries.Text.Trim().ToUpper();
oDenomination.SPType.SPTypeID = hdSPTypeID.Value.Trim();
oDenomination.UserDetail = ucUserDet.UserDetail;
oSPType.ListOfDenomination.Denomination.Add(oDenomination);
Session[Constants.SES_SPTYPE] = oSPType;
ReloadDenomTmpListFromSession();
ResetDenom();
}
else
{
ucMessage.OpenMessage("This Series " + txtSeries.Text + " all ready exist for other Denotation !", Constants.MSG_TYPE_ERROR);
ScriptManager.RegisterStartupScript(this.UpdatePanel1, typeof(string), Constants.POPUP_WINDOW, Util.OpenPopup("info"), true);
}
}
public static string GetSPName(string aplicacion, string entidad, SPType sptype)
{
const string FORMATO = "{0}_{1}_{2}";
string postfix = "";
switch(sptype)
{
case SPType.Select:
postfix = "S";
break;
case SPType.Delete:
postfix = "D";
break;
case SPType.Insert:
postfix = "I";
break;
case SPType.Update:
postfix = "U";
break;
}
return string.Format(FORMATO,aplicacion.ToUpper(),entidad,postfix);
}
public void UpdateLayouter(CVType nComparativeType, SPType nSuperpositionType, int nVisualSpaceDim, int nParametersDim, List <ParameterNameValue> parameters)
{
Camera.main.transform.position = new Vector3(0, 0, -300);
if (GameObject.Find("Composition") != null)
{
GameObject.DestroyImmediate(GameObject.Find("Composition"));
}
comparativeType = nComparativeType;
visualSpaceDim = nVisualSpaceDim;
parametersDim = nParametersDim;
switch (comparativeType)
{
case CVType.Juxtaposition:
{
if (parametersDim == 1)
{
layouter = new LayouterStripes();
(layouter as LayouterStripes).mainParameter = ensemble.getParameter(1);
(layouter as LayouterStripes).minValue = ensemble.parametersInfo[(layouter as LayouterStripes).mainParameter].minValue;
(layouter as LayouterStripes).maxValue = ensemble.parametersInfo[(layouter as LayouterStripes).mainParameter].maxValue;
(layouter as LayouterStripes).count = ensemble.parametersInfo[(layouter as LayouterStripes).mainParameter].count;
(layouter as LayouterStripes).delta = ensemble.structuresSize.x * 0.5f;
}
else if (parametersDim == 2 && ensemble.parametersInfo.Count >= 2)
{
layouter = new LayouterBoxes();
(layouter as LayouterBoxes).mainParameter = ensemble.getParameter(1);
(layouter as LayouterBoxes).mCount = ensemble.parametersInfo[(layouter as LayouterBoxes).mainParameter].count;
(layouter as LayouterBoxes).mMinValue = ensemble.parametersInfo[(layouter as LayouterBoxes).mainParameter].minValue;
(layouter as LayouterBoxes).mMaxValue = ensemble.parametersInfo[(layouter as LayouterBoxes).mainParameter].maxValue;
(layouter as LayouterBoxes).mDelta = ensemble.structuresSize.x * 0.5f;
(layouter as LayouterBoxes).secParameter = ensemble.getParameter(2);
(layouter as LayouterBoxes).sCount = ensemble.parametersInfo[(layouter as LayouterBoxes).secParameter].count;
(layouter as LayouterBoxes).sMinValue = ensemble.parametersInfo[(layouter as LayouterBoxes).secParameter].minValue;
(layouter as LayouterBoxes).sMaxValue = ensemble.parametersInfo[(layouter as LayouterBoxes).secParameter].maxValue;
(layouter as LayouterBoxes).sDelta = ensemble.structuresSize.y * 0.5f;
}
else
{
Debug.Log("Not permitted combination! Yet!");
}
break;
}
case CVType.Superposition:
{
if (parametersDim == 1)
{
layouter = new LayouterSuperPosition();
(layouter as LayouterSuperPosition).mainParameter = ensemble.getParameter(1);
(layouter as LayouterSuperPosition).minValue = ensemble.parametersInfo[(layouter as LayouterSuperPosition).mainParameter].minValue;
(layouter as LayouterSuperPosition).maxValue = ensemble.parametersInfo[(layouter as LayouterSuperPosition).mainParameter].maxValue;
(layouter as LayouterSuperPosition).count = ensemble.parametersInfo[(layouter as LayouterSuperPosition).mainParameter].count;
(layouter as LayouterSuperPosition).delta = 0.5f;
(layouter as LayouterSuperPosition).type = nSuperpositionType;
}
else
{
Debug.Log("Not permitted combination! Yet!");
}
break;
}
case CVType.Hybrid:
{
if (parametersDim == 2 && ensemble.parametersInfo.Count >= 2)
{
layouter = new LayouterSuperStripes();
(layouter as LayouterSuperStripes).mainParameter = ensemble.getParameter(1);
(layouter as LayouterSuperStripes).mCount = ensemble.parametersInfo[(layouter as LayouterSuperStripes).mainParameter].count;
(layouter as LayouterSuperStripes).mMinValue = ensemble.parametersInfo[(layouter as LayouterSuperStripes).mainParameter].minValue;
(layouter as LayouterSuperStripes).mMaxValue = ensemble.parametersInfo[(layouter as LayouterSuperStripes).mainParameter].maxValue;
(layouter as LayouterSuperStripes).mDelta = ensemble.structuresSize.x * 0.5f;
(layouter as LayouterSuperStripes).secParameter = ensemble.getParameter(2);
(layouter as LayouterSuperStripes).sCount = ensemble.parametersInfo[(layouter as LayouterSuperStripes).secParameter].count;
(layouter as LayouterSuperStripes).sMinValue = ensemble.parametersInfo[(layouter as LayouterSuperStripes).secParameter].minValue;
(layouter as LayouterSuperStripes).sMaxValue = ensemble.parametersInfo[(layouter as LayouterSuperStripes).secParameter].maxValue;
(layouter as LayouterSuperStripes).sDelta = 0.5f;
(layouter as LayouterSuperStripes).type = nSuperpositionType;
}
else if (parametersDim == 3 && ensemble.parametersInfo.Count >= 3)
{
layouter = new LayouterSuperBoxes();
(layouter as LayouterSuperBoxes).mainParameter = ensemble.getParameter(1);
(layouter as LayouterSuperBoxes).mCount = ensemble.parametersInfo[(layouter as LayouterSuperBoxes).mainParameter].count;
(layouter as LayouterSuperBoxes).mMinValue = ensemble.parametersInfo[(layouter as LayouterSuperBoxes).mainParameter].minValue;
(layouter as LayouterSuperBoxes).mMaxValue = ensemble.parametersInfo[(layouter as LayouterSuperBoxes).mainParameter].maxValue;
(layouter as LayouterSuperBoxes).mDelta = ensemble.structuresSize.x * 0.5f;
(layouter as LayouterSuperBoxes).secParameter = ensemble.getParameter(2);
(layouter as LayouterSuperBoxes).sCount = ensemble.parametersInfo[(layouter as LayouterSuperBoxes).secParameter].count;
(layouter as LayouterSuperBoxes).sMinValue = ensemble.parametersInfo[(layouter as LayouterSuperBoxes).secParameter].minValue;
(layouter as LayouterSuperBoxes).sMaxValue = ensemble.parametersInfo[(layouter as LayouterSuperBoxes).secParameter].maxValue;
(layouter as LayouterSuperBoxes).sDelta = ensemble.structuresSize.y * 0.5f;
(layouter as LayouterSuperBoxes).thirdParameter = ensemble.getParameter(2);
(layouter as LayouterSuperBoxes).tCount = ensemble.parametersInfo[(layouter as LayouterSuperBoxes).thirdParameter].count;
(layouter as LayouterSuperBoxes).tMinValue = ensemble.parametersInfo[(layouter as LayouterSuperBoxes).thirdParameter].minValue;
(layouter as LayouterSuperBoxes).tMaxValue = ensemble.parametersInfo[(layouter as LayouterSuperBoxes).thirdParameter].maxValue;
(layouter as LayouterSuperBoxes).tDelta = 0.5f;
(layouter as LayouterSuperBoxes).type = nSuperpositionType;
}
else
{
Debug.Log("Not permitted combination! Yet!");
}
break;
}
}
if (visualSpaceDim == 3)
{
Camera.main.gameObject.GetComponent <MouseCameraControl> ().pitch.activate = true;
Camera.main.gameObject.GetComponent <MouseCameraControl> ().yaw.activate = true;
}
else
{
Camera.main.gameObject.GetComponent <MouseCameraControl> ().pitch.activate = false;
Camera.main.gameObject.GetComponent <MouseCameraControl> ().yaw.activate = false;
}
layouter.axisParameters = parameters;
string abstractionName = pickupAbstractionNew();
int numOfElements = Mathf.FloorToInt((Camera.main.orthographicSize * 2f) / (abstractions[abstractionName].scale * 300f));
if (numOfElements == 0)
{
numOfElements = 5;
}
layouter.PlacePreview(numOfElements);
wasLayoutChanged = true;
isCompositionCreated = false;
}
