private TypeCrimen ConvertToTypeCrimen(DataRow dr)
{
TypeCrimen z = new TypeCrimen();
if (dr != null)
{
z.TypeCrimenId = Convert.ToInt32(dr["TypeCrimeId"]);
z.Crimen = Convert.ToString(dr["Crime"]);
z.Description = dr["Description"].ToString();
z.Code = dr["Code"].ToString();
z.Article = Convert.ToString(dr["Article"]);
z.OrganizationId = Convert.ToInt32(dr["OrganizationId"]);
}
return(z);
}
public static List <GroupTypeCrimen> getGroupTypeCrimen(string search)
{
List <GroupTypeCrimen> lgp = new List <GroupTypeCrimen>();
DBTransaction db = new DBTransaction();
List <SqlParameter> lp = new List <SqlParameter>();
lp.Add(new SqlParameter("@Search", search));
DataTable dt = db.GetStoreProcedure("den.GetOrganization", lp);
foreach (DataRow dr in dt.Rows)
{
GroupTypeCrimen gp = new GroupTypeCrimen();
gp = gp.ConvertToGroupTypeCrimen(dr);
TypeCrimen tc = new TypeCrimen();
gp.TypeCrimens = tc.getTypeCrimeByOrganization(gp.OrganizationId, search);
lgp.Add(gp);
}
return(lgp);
}