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)); }