public int Update_Technician_To_Group(Technician_To_Group objTechnician_To_Group)
 {
     return (int)ExecuteNonQuery(Sp_Technician_To_Group_Update, new object[] { objTechnician_To_Group.Technicianid, objTechnician_To_Group.Groupid });
 }
    public object GenerateTechnician_To_GroupObject(ref IDataReader returnData)
    {
        Technician_To_Group obj = new Technician_To_Group();
        while (returnData.Read())
        {
            obj.Groupid = (int)returnData["Groupid"];
            obj.Technicianid = (int)returnData["Technicianid"];

        }
        returnData.Close();
        returnData.Dispose();
        return obj;
    }
 public int Insert_Technician_To_Group(Technician_To_Group objTechnician_To_Group)
 {
     return (int)ExecuteNonQuery(Sp_Technician_To_Group_Insert, new object[] { objTechnician_To_Group.Technicianid, objTechnician_To_Group.Groupid });
 }
    public CollectionBase GenerateTechnician_To_GroupCollection(ref IDataReader returnData)
    {
        BLLCollection<Technician_To_Group> col = new BLLCollection<Technician_To_Group>();
        while (returnData.Read())
        {

            Technician_To_Group obj = new Technician_To_Group();
            obj.Groupid = (int)returnData["Groupid"];
            obj.Technicianid = (int)returnData["Technicianid"];

            col.Add(obj);
        }
        returnData.Close();
        returnData.Dispose();
        return col;
    }