public static List<clsResponsible> SelectByName(string name)
{
DAOResponsible daoProxy = new DAOResponsible();
DataSet dtsProxy = daoProxy.selectByName(name);
return LoadList(dtsProxy.Tables[0]);
}
public static List<clsResponsible> SelectAll()
{
DAOResponsible daoProxy = new DAOResponsible();
DataSet dtsProxy = daoProxy.selectAll();
return LoadList(dtsProxy.Tables[0]);
}
public static clsResponsible SelectRow(int codigo)
{
DAOResponsible daoProxy = new DAOResponsible();
DataSet dtsProxy = daoProxy.selectRow(codigo);
return Load(dtsProxy.Tables[0].Rows[0]);
}
public static clsResponsible SelectByUsername(string usrnm)
{
DAOResponsible daoProxy = new DAOResponsible();
DataSet dtsProxy = daoProxy.selectByUsername(usrnm);
if (dtsProxy.Tables[0].Rows.Count > 0)
return Load(dtsProxy.Tables[0].Rows[0]);
return null;
}
public static bool Delete(int iResponsible_id)
{
ValidationException x = new ValidationException();
if (iResponsible_id <= 0)
x.AgregarError("Ingrese el código de la persona");
if (x.Cantidad > 0)
throw x;
DAOResponsible daoProxy = new DAOResponsible();
return daoProxy.Delete(iResponsible_id);
}
public static int Insert(clsResponsible objProxy)
{
ValidationException x = new ValidationException();
if (string.IsNullOrEmpty(objProxy.SPerson_name)&& string.IsNullOrEmpty(objProxy.SPerson_lname))
x.AgregarError("verifique el nombre y el apellido de la persona");
if (objProxy.DEnd_time <= objProxy.DStart_time)
x.AgregarError("La fecha de fin deber ser mayor a la fecha de inicio");
if (string.IsNullOrEmpty(objProxy.SUsername))
x.AgregarError("Ingrese un nombre de usuario");
if (string.IsNullOrEmpty(objProxy.SPassword))
x.AgregarError("Ingrese una contrasenia");
if (x.Cantidad > 0)
throw x;
DAOResponsible daoProxy = new DAOResponsible();
return daoProxy.Insert(objProxy.SPerson_name, objProxy.SPerson_lname,objProxy.SPerson_dni,objProxy.SPerson_phone, objProxy.SPerson_email,objProxy.SUsername,objProxy.SPassword,objProxy.IRol_id.IRol_id,objProxy.DStart_time, objProxy.DEnd_time,objProxy.SStatus);
}
public static bool Update(clsResponsible objProxy)
{
ValidationException x = new ValidationException();
if (objProxy.IResponsible_id <= 0)
x.AgregarError("Ingrese el código");
if (string.IsNullOrEmpty(objProxy.SPerson_name) && string.IsNullOrEmpty(objProxy.SPerson_lname))
x.AgregarError("verifique el nombre y el apellido de la persona");
if (x.Cantidad > 0)
throw x;
DAOResponsible daoProxy = new DAOResponsible();
return daoProxy.Update(objProxy.IResponsible_id, objProxy.SPerson_name, objProxy.SPerson_lname, objProxy.SPerson_dni, objProxy.SPerson_phone, objProxy.SPerson_email, objProxy.SUsername, objProxy.SPassword, objProxy.IRol_id.IRol_id, objProxy.DStart_time, objProxy.DEnd_time, objProxy.SStatus);
}