public static List <FamilyNeed_ListerGroup> GetFamilyNeed_ListerGroupBySupportGroupID(int?OrderID, int FamilyID) { List <FamilyNeed_ListerGroup> lgfns = new List <FamilyNeed_ListerGroup>(); SqlConnection con = new SqlConnection(BaseDataBase.ConnectionString); SqlCommand com = new SqlCommand("sp_GetFamilyNeed_ListerGroupBySupportGroupID", con); com.CommandType = System.Data.CommandType.StoredProcedure; SqlParameter pr1 = new SqlParameter("@OrderID", OrderID); com.Parameters.Add(pr1); SqlParameter pr2 = new SqlParameter("@FamilyID", FamilyID); com.Parameters.Add(pr2); try { con.Open(); SqlDataReader rd = com.ExecuteReader(); while (rd.Read()) { FamilyNeed_ListerGroup x = new FamilyNeed_ListerGroup(); if (!(rd["ID"] is DBNull)) { x.ID = System.Int32.Parse(rd["ID"].ToString()); } if (!(rd["FamilyNeedListerID"] is DBNull)) { x.FamilyNeedByLister = FamilyNeedByLister.GetFamilyNeedByListerByID(System.Int32.Parse(rd["FamilyNeedListerID"].ToString())); } if (!(rd["ListerGroupID"] is DBNull)) { x.ListerGroupID = System.Int32.Parse(rd["ListerGroupID"].ToString()); } if (!(rd["OrderID"] is DBNull)) { x.OrderID = System.Int32.Parse(rd["OrderID"].ToString()); } if (!(rd["Count"] is DBNull)) { x.Count = System.Int32.Parse(rd["Count"].ToString()); } x.IsEnsured = x.OrderID.HasValue; lgfns.Add(x); } rd.Close(); } catch { lgfns = new List <FamilyNeed_ListerGroup>(); } finally { con.Close(); } return(lgfns); }
public static ListerGroup GetListerGroupByID(int?id) { ListerGroup x = new ListerGroup(); SqlConnection con = new SqlConnection(BaseDataBase.ConnectionString); SqlCommand com = new SqlCommand("sp_GetListerGroupByID", con); com.CommandType = System.Data.CommandType.StoredProcedure; SqlParameter pr = new SqlParameter("@GroupID", id); com.Parameters.Add(pr); try { con.Open(); SqlDataReader rd = com.ExecuteReader(); if (rd.Read()) { if (!(rd["GroupID"] is DBNull)) { x.GroupID = System.Int32.Parse(rd["GroupID"].ToString()); } if (!(rd["OrphanID"] is DBNull)) { x.OrphanID = System.Int32.Parse(rd["OrphanID"].ToString()); } if (!(rd["Date"] is DBNull)) { x.Date = System.DateTime.Parse(rd["Date"].ToString()); } x.Evaluation = rd["Evaluation"].ToString(); x.Notes = rd["Notes"].ToString(); x.CreatePerson = rd["CreatePerson"].ToString(); if (!(rd["CreateDate"] is DBNull)) { x.CreateDate = System.DateTime.Parse(rd["CreateDate"].ToString()); } x.LastModifiedPerson = rd["LastModifiedPerson"].ToString(); x.Notes = rd["Notes"].ToString(); if (!(rd["FamilyID"] is DBNull)) { x.FamilyID = System.Int32.Parse(rd["FamilyID"].ToString()); } x.Listers = ListerGroup.GetListersAllByGroupID(x.GroupID); x.FamilyNeeds = FamilyNeed_ListerGroup.GetFamilyNeed_ListerGroupByListerGroupID(x.GroupID.Value); } rd.Close(); } catch { x = new ListerGroup(); } finally { con.Close(); } return(x); }
public static bool UpdateData(FamilyNeed_ListerGroup x) { return(BaseDataBase._StoredProcedure("sp_UpdateFamilyNeed_ListerGroup" , new SqlParameter("@ID", x.ID) , new SqlParameter("@FamilyNeedListerID", x.FamilyNeedByLister.ID) , new SqlParameter("@ListerGroupID", x.ListerGroupID) , new SqlParameter("@OrderID", x.OrderID) , new SqlParameter("@Count", x.Count))); }
public static bool InsertData(FamilyNeed_ListerGroup x) { x.ID = BaseDataBase._StoredProcedureReturnable("sp_Add2FamilyNeed_ListerGroup" , new SqlParameter("@ID", System.Data.SqlDbType.Int) , new SqlParameter("@FamilyNeedListerID", x.FamilyNeedByLister.ID) , new SqlParameter("@ListerGroupID", x.ListerGroupID) , new SqlParameter("@OrderID", x.OrderID) , new SqlParameter("@Count", x.Count)); return(x.ID.HasValue); }
public static FamilyNeed_ListerGroup GetFamilyNeed_ListerGroupByID(int id) { FamilyNeed_ListerGroup x = new FamilyNeed_ListerGroup(); SqlConnection con = new SqlConnection(BaseDataBase.ConnectionString); SqlCommand com = new SqlCommand("sp_GetFamilyNeed_ListerGroupByID", 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 = System.Int32.Parse(rd["ID"].ToString()); } if (!(rd["FamilyNeedListerID"] is DBNull)) { x.FamilyNeedByLister = FamilyNeedByLister.GetFamilyNeedByListerByID(System.Int32.Parse(rd["FamilyNeedListerID"].ToString())); } if (!(rd["ListerGroupID"] is DBNull)) { x.ListerGroupID = System.Int32.Parse(rd["ListerGroupID"].ToString()); } if (!(rd["OrderID"] is DBNull)) { x.OrderID = System.Int32.Parse(rd["OrderID"].ToString()); } if (!(rd["Count"] is DBNull)) { x.Count = System.Int32.Parse(rd["Count"].ToString()); } x.IsEnsured = x.OrderID.HasValue; } rd.Close(); } catch { x = new FamilyNeed_ListerGroup(); } finally { con.Close(); } return(x); }
public static bool DeleteData(FamilyNeed_ListerGroup x) { return(BaseDataBase._StoredProcedure("sp_DeleteFromFamilyNeed_ListerGroup" , new SqlParameter("@ID", x.ID))); }