public int Update_Group_mst(Group_mst objGroup_mst)
{
return (int)ExecuteNonQuery(Sp_Group_mst_Update, new object[] { objGroup_mst.Groupname, objGroup_mst.Groupid, objGroup_mst.Description });
}
public object GenerateGroup_mst_mstObject(ref IDataReader returnData)
{
Group_mst obj = new Group_mst();
while (returnData.Read())
{
obj.Groupid = (int)returnData["Groupid"];
obj.Groupname = (string)returnData["Groupname"];
if (returnData["Description"] != DBNull.Value)
{ obj.Description = (string)returnData["Description"]; }
}
returnData.Close();
returnData.Dispose();
return obj;
}
public int Insert_Group_mst(Group_mst objGroup_mst)
{
return (int)ExecuteNonQuery(Sp_Group_mst_Insert, new object[] { objGroup_mst.Groupname, objGroup_mst.Description });
}
public CollectionBase GenerateGroup_mstCollection(ref IDataReader returnData)
{
BLLCollection<Group_mst> col = new BLLCollection<Group_mst>();
while (returnData.Read())
{
Group_mst obj = new Group_mst();
obj.Groupid = (int)returnData["Groupid"];
obj.Groupname = (string)returnData["Groupname"];
if (returnData["Description"] != DBNull.Value)
{ obj.Description = (string)returnData["Description"]; }
col.Add(obj);
}
returnData.Close();
returnData.Dispose();
return col;
}