public ConditionEC(String tableName, String nameCondition, String EventsSupport)
{
InitializeComponent();
TableName = tableName;
if (TablesNamesListBinding == null)
{
TablesNamesListBinding = new BindingList <string>
{
tableName
};
}
if (RowsCharge == null)
{
RowsCharge = new List <ItemconditionModel>();
}
QueryStructure = "{SelecCondition} ";
TxtQueryResult.Multiline = true;
TxtQueryResult.ScrollBars = ScrollBars.Vertical;
TxtQueryResult.AcceptsTab = true;
TxtQueryResult.AcceptsReturn = true;
TxtQueryResult.WordWrap = true;
TxtQueryResult.Height = 200;
TxtQueryResult.Text = QueryStructure.Replace("{SelecCondition}", "SELECT * FROM " + TablesNamesListBinding[0] + " WHERE ");
LblTableNAme.Text = tableName;
LblNotificationName.Text = nameCondition;
LblEventNotification.Text = EventsSupport;
}
public void ChangeValueItem(String Identifier, String value, String conector)
{
Boolean hastLasRowtValue = true;
int postition = 0;
Boolean hastValueCurrentQuery = false;
hastValueCurrentQuery = RowsCharge.FirstOrDefault(r => r.Identifier == Identifier) != null;
if (hastValueCurrentQuery)
{
RowsCharge.FirstOrDefault(r => r.Identifier == Identifier).Conector = conector;
postition = RowsCharge.IndexOf(RowsCharge.FirstOrDefault(r => r.Identifier == Identifier));
}
if (postition > 0)
{
hastLasRowtValue = RowsCharge[postition - 1].ValueQuery != null;
}
if (RowsCharge.FirstOrDefault(v => v.LastValueQuery.Contains(value)) == null && hastLasRowtValue && hastValueCurrentQuery)
{
if (postition == 0)
{
RowsCharge[postition].ValueQuery = value;
QueryStructure = QueryStructure.Replace(RowsCharge[postition].LastValueQuery, value);
RowsCharge[postition].LastValueQuery = value;
}
else
{
RowsCharge[postition].ValueQuery = " " + RowsCharge[postition - 1].Conector + " " + value;
QueryStructure = QueryStructure.Replace(RowsCharge[postition].LastValueQuery, " " + RowsCharge[postition - 1].Conector + " " + value);
RowsCharge[postition].LastValueQuery = " " + RowsCharge[postition - 1].Conector + " " + value;
}
}
else if (RowsCharge[postition].LastValueQuery != null && TableDelete != null)
{
Boolean hasContains = false;
foreach (String item in TableDelete)
{
hasContains = RowsCharge[postition].LastValueQuery.Contains(item) || RowsCharge[postition].LastValueQuery.Contains(" {" + RowsCharge[postition].Identifier + "}");
}
if (hasContains)
{
QueryStructure = QueryStructure.Replace(RowsCharge[postition].LastValueQuery, " {" + RowsCharge[postition].Identifier + "}");
}
}
if (RowsCharge.Count - 1 > postition && RowsCharge[postition + 1].ValueQuery != null)
{
RowsCharge[postition + 1].ValueQuery = " " + RowsCharge[postition].Conector + RowsCharge[postition + 1].ValueQuery.Replace("OR ", "").Replace("AND ", "");
QueryStructure = QueryStructure.Replace(RowsCharge[postition + 1].LastValueQuery, RowsCharge[postition + 1].ValueQuery);
RowsCharge[postition + 1].LastValueQuery = RowsCharge[postition + 1].ValueQuery;
}
SetTextInterface();
}
private void BtnDeleteCondition_Click(object sender, EventArgs e)
{
int postition = 0;
List <ItemconditionModel> listDelete = RowsCharge.Where(r => r.IsCheked).ToList();
if (listDelete != null)
{
foreach (ItemconditionModel item in listDelete)
{
RowsCharge.Remove(item);
QueryStructure = QueryStructure.Replace(item.LastValueQuery, "");
postition = PnlConditions.Controls.IndexOf(item.Intance);
PnlConditions.Controls.Remove(item.Intance);
if (postition == 0 && item.ValueQuery != null)
{
QueryStructure = QueryStructure.Replace(item.LastValueQuery, item.ValueQuery?.Replace(item.Conector, ""));
}
ReajustAling();
SetTextInterface();
}
listDelete.Clear();
}
}
