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