/// <summary>
/// SaveForEdit
/// </summary>
/// <param name="viewId">viewId</param>
/// <param name="loginId">loginId</param>
/// <param name="name">name</param>
/// <param name="type">type</param>
/// <param name="logic">logic</param>
/// <param name="sqlCommand">sqlCommand</param>
/// <param name="fmType">fmType</param>
/// <param name="companyId">companyId</param>
public void SaveForEdit(int viewId, int loginId, string name, string type, string logic, string sqlCommand, string fmType, int companyId, string newName, string newType)
{
FmViewGateway fmViewGateway = new FmViewGateway();
fmViewGateway.LoadByViewId(viewId, companyId);
int originalViewId = viewId;
int originalLoginId = fmViewGateway.GetLoginId(viewId);
string originalName = fmViewGateway.GetName(viewId);
string originalType = fmViewGateway.GetType(viewId);
string originalLogic = fmViewGateway.GetLogic(viewId);
string originalSqlCommand = fmViewGateway.GetSqlCommand(viewId);
string originalFmType = fmViewGateway.GetFmType(viewId);
bool originalDeleted = fmViewGateway.GetDeleted(viewId);
int originalCompanyId = fmViewGateway.GetCompanyId(viewId);
UpdateDirect(originalViewId, originalLoginId, originalName, originalType, originalLogic, originalSqlCommand, originalFmType, originalDeleted, originalCompanyId, viewId, loginId, newName, newType, logic, sqlCommand, fmType, false, companyId);
}
private bool StepConditionsNext()
{
// Validate data
bool validData = true;
// Edit if there is data to save
Page.Validate("ConditionsUpdate");
if (!Page.IsValid) validData = false;
if (validData)
{
// Conditions Gridview, if the gridview is edition mode
if (grdConditions.EditIndex >= 0)
{
grdConditions.UpdateRow(grdConditions.EditIndex, true);
grdConditions.DataBind();
}
}
Page.Validate("ConditionsNext");
if (!Page.IsValid) validData = false;
if (validData)
{
// Add conditions if exists at footer
if (ValidateFooterNext())
{
GrdConditionsAdd();
}
int companyId = Int32.Parse(hdfCompanyId.Value);
int viewId = Int32.Parse(hdfViewId.Value);
FmViewGateway fmViewGateway = new FmViewGateway();
fmViewGateway.LoadByViewId(viewId, companyId );
fmViewConditionTemp.Rows.Clear();
// Create dataset
FmViewTDS dataSet = new FmViewTDS();
dataSet.FmViewConditionNew.Merge(fmViewConditionNew, true);
dataSet.FmViewConditionTemp.Merge(fmViewConditionTemp, true);
// Process conditions
FmViewConditionTemp model = new FmViewConditionTemp(dataSet);
FmViewConditionNew modelLogic = new FmViewConditionNew(dataSet);
string originalLogic = fmViewGateway.GetLogic(viewId);
string newLogic = modelLogic.GetConditionsByDefault();
ArrayList aConditions = new ArrayList();
aConditions = modelLogic.GetConditions();
bool isConditionsUpdate = false;
if (originalLogic.Trim() != newLogic.Trim())
{
foreach (string conditionNumber in aConditions)
{
if (!originalLogic.Contains(conditionNumber))
{
isConditionsUpdate = true;
}
}
if (!isConditionsUpdate)
{
if (Session["conditionsUpdate"] != null)
{
if (Session["conditionsUpdate"].ToString() == "true")
{
isConditionsUpdate = true;
}
}
}
}
else
{
tbxLogic.Text = originalLogic.Trim();
}
if (isConditionsUpdate)
{
tbxLogic.Text = newLogic.Trim();
}
else
{
tbxLogic.Text = originalLogic.Trim();
}
// Get changes
fmViewConditionNew.Rows.Clear();
fmViewConditionNew.Merge(modelLogic.Table);
fmViewConditionTemp.Rows.Clear();
fmViewConditionTemp.Merge(model.Table);
// Store tables
Session.Remove("fmViewConditionNewDummy");
Session.Remove("fmViewConditionTempDummy");
Session["fmViewConditionNew"] = fmViewConditionNew;
Session["fmViewConditionTemp"] = fmViewConditionTemp;
Session["conditionsUpdate"] = null;
return true;
}
else
{
return false;
}
}