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