public override DataTable SQLSearch(MasterVO vo)
{
List <SqlParameter> parameters = new List <SqlParameter>();
if ((vo as GoalsVO).Id > 0)
{
parameters.Add(new SqlParameter("@id", (vo as GoalsVO).Id));
}
if (!string.IsNullOrEmpty((vo as GoalsVO).Name))
{
parameters.Add(new SqlParameter("@name", (vo as GoalsVO).Name));
}
if ((vo as GoalsVO).UserId > 0)
{
parameters.Add(new SqlParameter("@userId", (vo as GoalsVO).UserId));
}
if (!string.IsNullOrEmpty((vo as GoalsVO).Name))
{
parameters.Add(new SqlParameter("@typeId", (vo as GoalsVO).Name));
}
if ((vo as GoalsVO).EndDate < DateTime.Now)
{
parameters.Add(new SqlParameter("@date", (vo as GoalsVO).EndDate));
}
return(Methods.SQLSelectProcedure("fn_FilterGoalsByName", parameters.ToArray()));
}
public override SqlParameter[] CreateParameters(MasterVO vo, ActionDatabaseENUM action)
{
if (action == ActionDatabaseENUM.insert)
{
SqlParameter[] parameters =
{
new SqlParameter("@name", (vo as InvestmentsVO).Name),
new SqlParameter("@userId", (vo as InvestmentsVO).UserId),
new SqlParameter("@value", (vo as InvestmentsVO).Value),
new SqlParameter("@start", (vo as InvestmentsVO).StartDate),
new SqlParameter("@end", (vo as InvestmentsVO).EndDate),
};
return(parameters);
}
else if (action == ActionDatabaseENUM.update)
{
SqlParameter[] parameters =
{
new SqlParameter("@id", (vo as InvestmentsVO).Id),
new SqlParameter("@name", (vo as InvestmentsVO).Name),
new SqlParameter("@userId", (vo as InvestmentsVO).UserId),
new SqlParameter("@value", (vo as InvestmentsVO).Value),
new SqlParameter("@start", (vo as InvestmentsVO).StartDate),
new SqlParameter("@end", (vo as InvestmentsVO).EndDate),
};
return(parameters);
}
else
{
throw new Exception("Escolha um método válido para executar.");
}
}
public override DataTable SQLSearch(MasterVO vo)
{
List <SqlParameter> parameters = new List <SqlParameter>();
if ((vo as UsersVO).Id > 0)
{
parameters.Add(new SqlParameter("@id", (vo as UsersVO).Id));
}
if (!string.IsNullOrEmpty((vo as UsersVO).Name))
{
parameters.Add(new SqlParameter("@name", (vo as UsersVO).Name));
}
if ((vo as UsersVO).Picture.Length > 0)
{
parameters.Add(new SqlParameter("@picture", (vo as UsersVO).Picture));
}
if ((vo as UsersVO).DateBirth < DateTime.Now)
{
parameters.Add(new SqlParameter("@dtBirth", (vo as UsersVO).DateBirth));
}
if (!string.IsNullOrEmpty((vo as UsersVO).Password))
{
parameters.Add(new SqlParameter("@password", (vo as UsersVO).Password));
}
return(Methods.SQLSelectProcedure("usp_FilterUsersByName", parameters.ToArray()));
}
public override SqlParameter[] CreateParameters(MasterVO vo, ActionDatabaseENUM action)
{
if (action == ActionDatabaseENUM.insert)
{
SqlParameter[] parameters =
{
new SqlParameter("@name", (vo as UsersVO).Name),
new SqlParameter("@picture", (vo as UsersVO).Picture),
new SqlParameter("@dateBirth", (vo as UsersVO).DateBirth),
new SqlParameter("@password", (vo as UsersVO).Password),
};
return(parameters);
}
else if (action == ActionDatabaseENUM.update)
{
SqlParameter[] parameters =
{
new SqlParameter("@id", (vo as UsersVO).Id),
new SqlParameter("@name", (vo as UsersVO).Name),
new SqlParameter("@picture", (vo as UsersVO).Picture),
new SqlParameter("@dateBirth", (vo as UsersVO).DateBirth),
new SqlParameter("@password", (vo as UsersVO).Password),
};
return(parameters);
}
else
{
throw new Exception("Escolha um método válido para executar.");
}
}
public override SqlParameter[] CreateParameters(MasterVO vo, ActionDatabaseENUM action)
{
if (action == ActionDatabaseENUM.insert)
{
SqlParameter[] parameters =
{
new SqlParameter("@name", (vo as TypesVO).Name),
new SqlParameter("@description", (vo as TypesVO).Description),
new SqlParameter("@action", (vo as TypesVO).Action)
};
return(parameters);
}
else if (action == ActionDatabaseENUM.update)
{
SqlParameter[] parameters =
{
new SqlParameter("@id", (vo as TypesVO).Id),
new SqlParameter("@name", (vo as TypesVO).Name),
new SqlParameter("@description", (vo as TypesVO).Description),
new SqlParameter("@action", (vo as TypesVO).Action)
};
return(parameters);
}
else
{
throw new Exception("Escolha um método válido para executar.");
}
}
public override DataTable SQLSearch(MasterVO vo)
{
List <SqlParameter> parameters = new List <SqlParameter>();
if ((vo as TypesVO).Id > 0)
{
parameters.Add(new SqlParameter("@id", (vo as TypesVO).Id));
}
if (!string.IsNullOrEmpty((vo as TypesVO).Name))
{
parameters.Add(new SqlParameter("@name", (vo as TypesVO).Name));
}
if (!string.IsNullOrEmpty((vo as TypesVO).Description))
{
parameters.Add(new SqlParameter("@description", (vo as TypesVO).Description));
}
if (!string.IsNullOrEmpty((vo as TypesVO).Action))
{
parameters.Add(new SqlParameter("@action", (vo as TypesVO).Action));
}
return(Methods.SQLSelectProcedure("usp_FilterTypesByName", parameters.ToArray()));
}
private void btn_Last_Click(object sender, EventArgs e)
{
try
{
MasterVO o = registerDAO.SQLLast();
FillScreen(o);
}
catch (Exception erro)
{
TrataErro(erro);
}
}
public void Inicializa()
{
try
{
MasterVO objVO = registerDAO.SQLFirst();
FillScreen(objVO);
}
catch (Exception erro)
{
TrataErro(erro);
}
ChangeMode(NavigationTypeENUM.Navigation);
}
private void btn_Next_Click(object sender, EventArgs e)
{
try
{
MasterVO objVO = registerDAO.SQLNext(Convert.ToInt32(txt_Id.Text));
if (objVO != null)
{
FillScreen(objVO);
}
}
catch (Exception erro)
{
TrataErro(erro);
}
}
public override DataTable SQLSearch(MasterVO vo)
{
List <SqlParameter> parameters = new List <SqlParameter>();
if ((vo as StatementsVO).Id > 0)
{
parameters.Add(new SqlParameter("@id", (vo as StatementsVO).Id));
}
if (!string.IsNullOrEmpty((vo as StatementsVO).Name))
{
parameters.Add(new SqlParameter("@name", (vo as StatementsVO).Name));
}
if ((vo as StatementsVO).UserId > 0)
{
parameters.Add(new SqlParameter("@userId", (vo as StatementsVO).UserId));
}
if ((vo as StatementsVO).TypeId > 0)
{
parameters.Add(new SqlParameter("@typeId", (vo as StatementsVO).TypeId));
}
if ((vo as StatementsVO).EnvironmentId > 0)
{
parameters.Add(new SqlParameter("@environmentId", (vo as StatementsVO).EnvironmentId));
}
if ((vo as StatementsVO).Value > 0)
{
parameters.Add(new SqlParameter("@value", (vo as StatementsVO).Value));
}
if ((vo as StatementsVO).Date > DateTime.Now)
{
parameters.Add(new SqlParameter("@date", (vo as StatementsVO).Date));
}
return(Methods.SQLSelectProcedure("usp_FilterStatementsByName", parameters.ToArray()));
}
public override void FillScreen(MasterVO objVO)
{
try
{
if (objVO != null)
{
txt_Id.Text = (objVO as GoalsVO).Id.ToString();
txt_Name.Text = (objVO as GoalsVO).Name;
dt_EndDate.Value = (objVO as GoalsVO).EndDate;
}
else
{
LimpaCampos(this);
}
}
catch (Exception erro)
{
TrataErro(erro);
}
}
public override void FillScreen(MasterVO objVO)
{
try
{
if (objVO != null)
{
txt_Id.Text = (objVO as EnvironmentsVO).Id.ToString();
txt_Name.Text = (objVO as EnvironmentsVO).Name;
txt_Description.Text = (objVO as EnvironmentsVO).Description;
}
else
{
LimpaCampos(this);
}
}
catch (Exception erro)
{
TrataErro(erro);
}
}
private void btn_Save_Click(object sender, EventArgs e)
{
try
{
MasterVO obj = FillObject();
if (txt_Id.Enabled)
{
registerDAO.SQLInsert(obj);
}
else
{
registerDAO.SQLUpdate(obj);
}
ChangeMode(NavigationTypeENUM.Navigation);
}
catch (Exception erro)
{
TrataErro(erro);
}
}
public override void FillScreen(MasterVO objVO)
{
try
{
if (objVO != null)
{
txt_Id.Text = (objVO as StatementsVO).Id.ToString();
txt_Environment.Text = (objVO as StatementsVO).EnvironmentId.ToString();
txt_Type.Text = (objVO as StatementsVO).TypeId.ToString();
txt_Name.Text = (objVO as StatementsVO).Name;
dt_Date.Value = (objVO as StatementsVO).Date;
txt_Value.Text = (objVO as StatementsVO).Value.ToString();
}
else
{
LimpaCampos(this);
}
}
catch (Exception erro)
{
TrataErro(erro);
}
}
public abstract void SQLUpdate(MasterVO vo);
public virtual void FillScreen(MasterVO obj)
{
//preencher nos filhos
}
public abstract DataTable SQLSearch(MasterVO vo);
public abstract SqlParameter[] CreateParameters(MasterVO vo, ActionDatabaseENUM action);
//protected string table { get; set; }
//protected string key { get; set; } = "id";
public abstract void SQLInsert(MasterVO vo);
public override void SQLUpdate(MasterVO vo)
{
Methods.SQLNonQueryProcedure("usp_UpdateType", CreateParameters(vo, ActionDatabaseENUM.update));
}
public override void SQLInsert(MasterVO vo)
{
Methods.SQLNonQueryProcedure("usp_InsertType", CreateParameters(vo, ActionDatabaseENUM.insert));
}
