internal static List <FormedBasket> GetFormedBasketByFamilyID(int familyID)
{
List <FormedBasket> xx = new List <FormedBasket>();
SqlConnection con = new SqlConnection(BaseDataBase.ConnectionString);
SqlCommand com = new SqlCommand("sp_Get_All_FormedBasketByFamilyID", con);
com.CommandType = System.Data.CommandType.StoredProcedure;
com.Parameters.Add(new SqlParameter("@FamilyID", familyID));
try
{
con.Open();
SqlDataReader rd = com.ExecuteReader();
while (rd.Read())
{
FormedBasket x = new FormedBasket();
if (!(rd["Id"] is DBNull))
{
x.Id = int.Parse(rd["Id"].ToString());
}
x.Name = rd["Name"].ToString();
if (!(rd["IsActive"] is DBNull))
{
x.IsActive = bool.Parse(rd["IsActive"].ToString());
}
if (!(rd["IsUrgent"] is DBNull))
{
x.IsUrgent = bool.Parse(rd["IsUrgent"].ToString());
}
x.Notes = rd["Notes"].ToString();
if (!(rd["LastUserID"] is DBNull))
{
x.LastUserID = int.Parse(rd["LastUserID"].ToString());
}
x.FormedBasketItems = FormedBasket_Item.GetAllBasket_ItemByBasket(x);
xx.Add(x);
}
rd.Close();
}
catch
{
xx = null;
}
finally
{
con.Close();
}
return(xx);
}
public static FormedBasket GetItemByID(int id)
{
FormedBasket x = new FormedBasket();
SqlConnection con = new SqlConnection(BaseDataBase.ConnectionString);
SqlCommand com = new SqlCommand("sp_Get_ID_FormedBasket", con);
com.CommandType = System.Data.CommandType.StoredProcedure;
SqlParameter pr = new SqlParameter("@ID", id);
com.Parameters.Add(pr);
try
{
con.Open();
SqlDataReader rd = com.ExecuteReader();
if (rd.Read())
{
if (!(rd["Id"] is DBNull))
{
x.Id = int.Parse(rd["Id"].ToString());
}
x.Name = rd["Name"].ToString();
if (!(rd["IsActive"] is DBNull))
{
x.IsActive = bool.Parse(rd["IsActive"].ToString());
}
if (!(rd["IsUrgent"] is DBNull))
{
x.IsUrgent = bool.Parse(rd["IsUrgent"].ToString());
}
x.Notes = rd["Notes"].ToString();
if (!(rd["LastUserID"] is DBNull))
{
x.LastUserID = int.Parse(rd["LastUserID"].ToString());
}
x.FormedBasketItems = FormedBasket_Item.GetAllBasket_ItemByBasket(x);
}
rd.Close();
}
catch
{
x = null;
}
finally
{
con.Close();
}
return(x);
}
