private int obtemNovoId() { try { db = ServidorSingleton.obterServidor().OpenClient(); IQuery query = db.Query(); query.Constrain(typeof(clsStatus)).Greater(); query.Descend("codigo").OrderDescending(); IObjectSet leitor = query.Execute(); if (leitor.HasNext()) { clsStatus objStatus = (clsStatus)leitor.Next(); return(Convert.ToInt32(objStatus.Codigo) + 1); } else { return(1); } } catch (Exception ex) { throw new Exception("Erro obtendo o id do status :" + ex.ToString()); } finally { db.Close(); db.Dispose(); } }
public Boolean excluirStatus(clsStatus objStatus) { FilmeDAO objFilmeDAO = new FilmeDAO(); if (!objFilmeDAO.temStatusEmFilme(objStatus)) { try { db = ServidorSingleton.obterServidor().OpenClient(); IObjectSet leitor = db.QueryByExample(objStatus); clsStatus s = (clsStatus)leitor.Next(); db.Delete(s); db.Commit(); return(true); } catch (Exception ex) { throw new Exception("Erro tentando excluir o Status :" + ex.ToString()); } finally { db.Close(); db.Dispose(); } } else { return(false); } }
public String EditStatus(string Status, int IdStatus, string Cve) { //Boolean msg = true; string sResp = ""; clsStatus oclsStatus = new clsStatus(); String strIdStatus = Convert.ToString(IdStatus); if (string.IsNullOrEmpty(Status)) { return("Falta agregar el Estatus"); } if (string.IsNullOrEmpty(Cve)) { return("Falta agregar la clave"); } if (string.IsNullOrEmpty(strIdStatus)) { return("Falta agregar el Estatus"); } sResp = oclsStatus.UpdateStatus(IdStatus, Status, Cve); return(sResp); //if (msg) { return "La Estatus se ha actualizado en la base de datos"; } //else { return "Error al actualizar los datos"; } }
public bool UpdateStatus(clsStatus objStatus) { DataSet dsStatusList; dsStatusList = new DataSet(); SqlParameter[] objParam = new SqlParameter[2]; objParam[0] = new SqlParameter("@StatusID", SqlDbType.Int); objParam[0].Value = objStatus.StatusID; objParam[1] = new SqlParameter("@Status", SqlDbType.VarChar, 100); objParam[1].Value = objStatus.StatusName; int recaffected1; try { recaffected1 = SqlHelper.ExecuteNonQuery(sqlConn, CommandType.StoredProcedure, "sp_UpdateStatus", objParam); } catch (V2Exceptions ex) { throw; } catch (System.Exception ex) { FileLog objFileLog = FileLog.GetLogger(); objFileLog.WriteLine(LogType.Error, ex.Message, "clsDLStatus.cs", "UpdateStatus", ex.StackTrace); throw new V2Exceptions(); } return(true); }
/// <summary> /// update row in the table /// </summary> /// <param name="businessObject">business object</param> /// <returns>true for successfully updated</returns> public bool Update(clsStatus businessObject) { SqlCommand sqlCommand = new SqlCommand(); sqlCommand.CommandText = "dbo.[sp_STATUS_Update]"; sqlCommand.CommandType = CommandType.StoredProcedure; // Use connection object of base class sqlCommand.Connection = MainConnection; try { sqlCommand.Parameters.Add(new SqlParameter("@STATUS_ID", SqlDbType.SmallInt, 2, ParameterDirection.Input, false, 0, 0, "", DataRowVersion.Proposed, businessObject.STATUS_ID)); sqlCommand.Parameters.Add(new SqlParameter("@STATUS_NAME", SqlDbType.VarChar, 20, ParameterDirection.Input, false, 0, 0, "", DataRowVersion.Proposed, businessObject.STATUS_NAME)); sqlCommand.Parameters.Add(new SqlParameter("@DESCR", SqlDbType.VarChar, 20, ParameterDirection.Input, false, 0, 0, "", DataRowVersion.Proposed, businessObject.DESCR)); sqlCommand.Parameters.Add(new SqlParameter("@STATUS", SqlDbType.SmallInt, 2, ParameterDirection.Input, false, 0, 0, "", DataRowVersion.Proposed, businessObject.STATUS)); MainConnection.Open(); sqlCommand.ExecuteNonQuery(); return(true); } catch (Exception ex) { throw new Exception("clsStatus::Update::Error occured.", ex); } finally { MainConnection.Close(); sqlCommand.Dispose(); } }
public Collection <clsFilme> listarFilme(string ano, string tituloOriginal, string tituloBr, string codGenero, string codStatus) { clsGenero objGenero = new clsGenero(); GeneroDAO objGeneroDAO = new GeneroDAO(); int intCodGenero; try{ intCodGenero = Convert.ToInt32(codGenero); }catch { intCodGenero = -1; } objGenero = objGeneroDAO.obterGenero(intCodGenero); clsStatus objStatus = new clsStatus(); StatusDAO objStatusDAO = new StatusDAO(); int intCodStatus; try { intCodStatus = Convert.ToInt32(codStatus); } catch { intCodStatus = -1; } objStatus = objStatusDAO.obterStatus(intCodStatus); FilmeDAO objFilmeDAO = new FilmeDAO(); return(objFilmeDAO.listarFilmes(ano, tituloOriginal, tituloBr, objGenero, objStatus)); }
public Boolean alterarFilme(int codigo, string tituloOriginal, string tituloBr, int ano, int codGenero, int avaliacao, int codStatus) { clsFilme objFilme = new clsFilme(); objFilme.Codigo = codigo; objFilme.TituloOriginal = tituloOriginal; objFilme.TituloBr = tituloBr; objFilme.Ano = ano; clsGenero objGenero = new clsGenero(); objGenero.Codigo = codGenero; objFilme.Genero = objGenero; objFilme.Avaliacao = avaliacao; clsStatus objStatus = new clsStatus(); objStatus.Codigo = codStatus; objFilme.Status = objStatus; FilmeDAO objFilmeDAO = new FilmeDAO(); return(objFilmeDAO.alterarFilme(objFilme)); }
/// <summary> /// Populate business object from data reader /// </summary> /// <param name="businessObject">business object</param> /// <param name="dataReader">data reader</param> internal void PopulateBusinessObjectFromReader(clsStatus businessObject, IDataReader dataReader) { businessObject.STATUS_ID = (byte)dataReader.GetInt16(dataReader.GetOrdinal(clsStatus.clsStatusFields.STATUS_ID.ToString())); businessObject.STATUS_NAME = dataReader.GetString(dataReader.GetOrdinal(clsStatus.clsStatusFields.STATUS_NAME.ToString())); businessObject.DESCR = dataReader.GetString(dataReader.GetOrdinal(clsStatus.clsStatusFields.DESCR.ToString())); businessObject.STATUS = (byte)dataReader.GetInt16(dataReader.GetOrdinal(clsStatus.clsStatusFields.STATUS.ToString())); }
public Boolean temStatusEmFilme(clsStatus objStatus) { bool temfilme; try { db = ServidorSingleton.obterServidor().OpenClient(); clsFilme objFilme = new clsFilme(); objFilme.Status = objStatus; IObjectSet leitor = db.QueryByExample(objFilme); if (leitor.HasNext()) { temfilme = true; } else { temfilme = false; } leitor = null; } catch (Exception ex) { throw new Exception("Erro verificando possibilidade de exclusão do status:" + ex.ToString()); } finally { db.Close(); db.Dispose(); } return(temfilme); }
public bool UpdateStatus(clsStatus objStatus) { try { if (objDLStatus.UpdateStatus(objStatus)) { return(true); } else { return(false); } } catch (V2Exceptions ex) { throw; } catch (System.Exception ex) { FileLog objFileLog = FileLog.GetLogger(); objFileLog.WriteLine(LogType.Error, ex.Message, "clsBLStatus.cs", "UpdateStatus", ex.StackTrace); throw new V2Exceptions(); } }
public DataSet IsDuplicateStatus(clsStatus objStatus) { DataSet dsIsDuplicateStatus; SqlParameter[] objParam = new SqlParameter[2]; objParam[0] = new SqlParameter("@StatusID", SqlDbType.Int); objParam[0].Value = objStatus.StatusID; objParam[1] = new SqlParameter("@Status", SqlDbType.VarChar, 100); objParam[1].Value = objStatus.StatusName; try { dsIsDuplicateStatus = SqlHelper.ExecuteDataset(sqlConn, CommandType.StoredProcedure, "sp_IsDuplicateStatus", objParam); return(dsIsDuplicateStatus); } catch (V2Exceptions ex) { throw; } catch (System.Exception ex) { FileLog objFileLog = FileLog.GetLogger(); objFileLog.WriteLine(LogType.Error, ex.Message, "clsDLStatus.cs", "IsDuplicateStatus", ex.StackTrace); throw new V2Exceptions(); } }
public Boolean alterarStatus(clsStatus objAtualizar) { try { if (!temDuplicidade(objAtualizar, "Alterar")) { clsStatus objStatusBuscar = new clsStatus(); objStatusBuscar.Codigo = objAtualizar.Codigo; db = ServidorSingleton.obterServidor().OpenClient(); IObjectSet leitor = db.QueryByExample(objStatusBuscar); clsStatus objStatus = (clsStatus)leitor.Next(); objStatus.Descricao = objAtualizar.Descricao; db.Store(objStatus); db.Commit(); db.Close(); db.Dispose(); return(true); } else { return(false); } } catch (Exception ex) { throw new Exception("Erro atualizando o status :" + ex.ToString()); } }
public Boolean cadastrarStatus(clsStatus objStatus) { try { if (!temDuplicidade(objStatus, "Cadastrar")) { objStatus.Codigo = obtemNovoId(); //Executa a solicitação de um novo id db = ServidorSingleton.obterServidor().OpenClient(); db.Store(objStatus); db.Commit(); return(true); } else { return(false); } } catch (Exception ex) { db.Rollback(); throw new Exception("Erro cadastrando o status :" + ex.ToString()); } finally { db.Close(); db.Dispose(); } }
public clsStatus obterStatus(int codStatus) { clsStatus objStatusProt = new clsStatus(); clsStatus objStatus = new clsStatus(); objStatusProt.Codigo = codStatus; try { db = ServidorSingleton.obterServidor().OpenClient(); IObjectSet leitor = db.QueryByExample(objStatusProt); if (leitor.HasNext()) { return((clsStatus)leitor.Next()); } else { return(null); } leitor = null; } catch (Exception ex) { throw new Exception("Erro obtendo o genero :" + ex.ToString()); } finally { db.Close(); db.Dispose(); } }
public Boolean cadastrarStatus(string descricao) { StatusDAO objStatusDAO = new StatusDAO(); clsStatus objStatus = new clsStatus(); objStatus.Descricao = descricao; return(objStatusDAO.cadastrarStatus(objStatus)); }
public Boolean alterarStatus(int codigo, string descricao) { StatusDAO objStatusDAO = new StatusDAO(); clsStatus objStatus = new clsStatus(); objStatus.Codigo = codigo; objStatus.Descricao = descricao; return(objStatusDAO.alterarStatus(objStatus)); }
public Boolean excluirStatus(int codStatus) { clsStatus objStatus = new clsStatus(); objStatus.Codigo = codStatus; StatusDAO objStatusDAO = new StatusDAO(); return(objStatusDAO.excluirStatus(objStatus)); }
private Boolean temDuplicidade(clsStatus objStatus, string modo) { bool possuiObjeto = false; clsStatus objStatusProt = new clsStatus(); //Protótipo para consulta try { db = ServidorSingleton.obterServidor().OpenClient(); objStatusProt.Descricao = objStatus.Descricao; //Setando a descrição para busca IObjectSet leitor = db.QueryByExample(objStatusProt); if (leitor.HasNext()) { switch (modo) { case "Cadastrar": possuiObjeto = true; break; case "Alterar": clsStatus objStatusDb = new clsStatus(); objStatusDb = (clsStatus)leitor.Next(); //Carregando em cache o obj do banco //Comparando se o codigo a ser alterado é diferente do do banco. if (Convert.ToInt32(objStatus.Codigo) != Convert.ToInt32(objStatusDb.Codigo)) { //É diferente, logo se trata de um objeto diferente do que esta sendo alterado //A alteração não pode ser feita possuiObjeto = true; } else { possuiObjeto = false; } break; } } else { possuiObjeto = false; } leitor = null; } catch (Exception ex) { throw new Exception("Erro verificando a duplicidade do Status: " + ex.ToString()); } finally { db.Close(); db.Dispose(); } return(possuiObjeto); }
/// <summary> /// Populate business objects from the data reader /// </summary> /// <param name="dataReader">data reader</param> /// <returns>list of clsStatus</returns> internal List <clsStatus> PopulateObjectsFromReader(IDataReader dataReader) { List <clsStatus> list = new List <clsStatus>(); while (dataReader.Read()) { clsStatus businessObject = new clsStatus(); PopulateBusinessObjectFromReader(businessObject, dataReader); list.Add(businessObject); } return(list); }
public DataSet IsDuplicateStatus(clsStatus objStatus) { try { return(objDLStatus.IsDuplicateStatus(objStatus)); } catch (V2Exceptions ex) { throw; } catch (System.Exception ex) { FileLog objFileLog = FileLog.GetLogger(); objFileLog.WriteLine(LogType.Error, ex.Message, "clsBLStatus.cs", "IsDuplicateStatus", ex.StackTrace); throw new V2Exceptions(); } }
public string NewStatus(string Cve, string Status) { clsStatus oclsStatus = new clsStatus(); string sResp = ""; if (string.IsNullOrEmpty(Cve)) { return("Falta agregar la clave del Estatus"); } if (string.IsNullOrEmpty(Status)) { return("Falta agregar la descripcion del Estatus"); } sResp = oclsStatus.NewStatus(Cve, Status); return(sResp); }
public String DeleteStatus(int intIdStatus_delete) { clsStatus oClsStatus = new clsStatus(); String strIdGrupo = Convert.ToString(intIdStatus_delete); Boolean msg = true; if (string.IsNullOrEmpty(strIdGrupo)) { return("Falta agregar el Estatus"); } msg = oClsStatus.DeleteStatus(intIdStatus_delete); if (msg) { return("El Estatus se ha eliminado de la base de datos"); } else { return("Error al eliminar el estatus de la base de datos"); } }
//Lista a busca dinâmica public Collection <clsFilme> listarFilmes(string ano, string tituloOriginal, string tituloBr, clsGenero objGenero, clsStatus objStatus) { try { int intAno = Convert.ToInt32(ano); } catch { ano = ""; } //Se não foi informado genero/status, seta a descrição como "" para buscar todos if (objGenero == null) { objGenero = new clsGenero(); objGenero.Descricao = ""; } if (objStatus == null) { objStatus = new clsStatus(); objStatus.Descricao = ""; } db = ServidorSingleton.obterServidor().OpenClient(); return(new Collection <clsFilme>(db.Query <clsFilme>(delegate(clsFilme objFilme) { db.Close(); db.Dispose(); return objFilme.TituloBr.ToLower().Contains(tituloBr.ToLower()) && objFilme.TituloOriginal.ToLower().Contains(tituloOriginal.ToLower()) && objFilme.Ano.ToString().Contains(ano) && objFilme.Genero.Descricao.StartsWith(objGenero.Descricao) && objFilme.Status.Descricao.StartsWith(objStatus.Descricao); }))); }
public Boolean cadastrarFilme(string tituloOriginal, string tituloBr, int ano, int codGenero, int avaliacao, int codStatus) { clsFilme objFilme = new clsFilme(); objFilme.TituloOriginal = tituloOriginal; objFilme.TituloBr = tituloBr; objFilme.Ano = ano; objFilme.Avaliacao = avaliacao; clsGenero objGenero = new clsGenero(); objGenero.Codigo = codGenero; objFilme.Genero = objGenero; clsStatus objStatus = new clsStatus(); objStatus.Codigo = codStatus; objFilme.Status = objStatus; FilmeDAO f = new FilmeDAO(); try { f.cadastrarFilme(objFilme); return(true); } catch { return(false); } }
protected void Page_Load(object sender, EventArgs e) { clsStatus clsBussinesStatus = new clsStatus(); try { if (!IsPostBack) { DataTable dtG = clsBussinesStatus.GetAllStatus(); Session["dtG"] = dtG; strHTMLGroup = clsBussinesStatus.ReturnHTMLDivision(dtG); DBDataPlaceHolder.Controls.Add(new Literal { Text = strHTMLGroup.ToString() }); } this.Dispose(); } catch (Exception ex) { clsError.logMessage = ex.ToString(); clsError.logModule = "Page_Load"; clsError.LogWrite(); } }