/// <summary> /// Criar a tabela no banco de dados /// </summary> /// <returns>true se criar</returns> public virtual void Create() { try { using (var trans = TransManager.GetTrans()) { var eventArgs = new TableAdapterEventArgs(); if (OnBeforeCreate != null) { OnBeforeCreate(this, eventArgs); } var command = GetCreateCommand(); Connection.SqlServerExecute(command.Item1, command.Item2); eventArgs = new TableAdapterEventArgs(); if (OnAfterCreate != null) { OnAfterCreate(this, eventArgs); } trans.Complete(); } } catch (Exception ex) { var message = string.Format("Erro ao criar a tabela [{0}..{1}]", DBName, TableName); throw new Exception(message, ex); } }
/// <summary> /// Atualiza o registro no banco de dados /// </summary> /// <returns>True se atualizar</returns> public virtual void Update() { using (var trans = TransManager.GetTrans()) { var eventArgs = new TableAdapterEventArgs(); if (OnBeforeUpdate != null) { OnBeforeUpdate(this, eventArgs); } var command = GetUpdateCommand(); Connection.SqlServerExecute(command.Item1, command.Item2); eventArgs = new TableAdapterEventArgs(); if (OnAfterUpdate != null) { eventArgs.Keys = KeyFields; OnAfterUpdate(this, eventArgs); } trans.Complete(); } }
/// <summary> /// Adiciona um registro no banco de dados /// </summary> /// <returns>true se adicionar</returns> public virtual void Add() { using (var trans = TransManager.GetTrans()) { var eventArgs = new TableAdapterEventArgs(); if (OnBeforeAdd != null) { OnBeforeAdd(this, eventArgs); } var inserdCommand = GetInsertCommand(); var lastInsertedId = Connection.SqlServerExecuteAndGetLastInsertId(inserdCommand.Item1, inserdCommand.Item2); SetIdentityValue(lastInsertedId); eventArgs.Keys = KeyFields; eventArgs = new TableAdapterEventArgs(); if (OnAfterAdd != null) { OnAfterAdd(this, eventArgs); } trans.Complete(); } }
/// <summary> /// Pega o registro pelas chaves /// </summary> /// <returns>True se encontrar</returns> public virtual bool GetByKey() { using (var trans = TransManager.GetTrans()) { var eventArgs = new TableAdapterEventArgs(); if (OnBeforeSelect != null) { OnBeforeSelect(this, eventArgs); } var command = GetSelectCommand(); var data = Connection.SqlServerQuery(command.Item1, command.Item2); var foundRecord = data.Rows.Count > 0; if (foundRecord) { eventArgs = new TableAdapterEventArgs { Keys = KeyFields }; FillFields(data.Rows[0], true); StateRecord = eState.eDatabase; if (OnAfterSelect != null) { OnAfterSelect(this, eventArgs); } } trans.Complete(); return(foundRecord); } }