public DataTable FillGrid(UpdateGroupMasterModel ObjPlGroupTypeModel)
{
objUpdGrTypeDA = new UpdateGroupTypeDataAccess();
DataTable fillGridGrType = objUpdGrTypeDA.FillGridView(ObjPlGroupTypeModel);
return(fillGridGrType);
}
public DataTable UpdateProcess(UpdateGroupMasterModel ObjPlGroupTypeModel)
{
objUpdGrTypeDA = new UpdateGroupTypeDataAccess();
DataTable UpdateGrType = objUpdGrTypeDA.SaveProcessGroupItem(ObjPlGroupTypeModel);
return(UpdateGrType);
}
internal DataTable SaveProcessGroupItem(UpdateGroupMasterModel ObjPlGroupTypeModel)
{
try
{
ClsCon.cmd = new SqlCommand();
ClsCon.cmd.CommandType = CommandType.StoredProcedure;
ClsCon.cmd.CommandText = "SPItemGroups";
ClsCon.cmd.CommandType = CommandType.StoredProcedure;
ClsCon.cmd.Parameters.AddWithValue("@Ind", ObjPlGroupTypeModel.Ind);
ClsCon.cmd.Parameters.AddWithValue("@OrgID", ObjPlGroupTypeModel.OrgID);
ClsCon.cmd.Parameters.AddWithValue("@GrType", ObjPlGroupTypeModel.GrType);
ClsCon.cmd.Parameters.AddWithValue("@GrDesc", ObjPlGroupTypeModel.GrDesc);
ClsCon.cmd.Parameters.AddWithValue("@ItemGroupID", ObjPlGroupTypeModel.ItemGroupID);
ClsCon.cmd.Parameters.AddWithValue("@IP", ObjPlGroupTypeModel.IP);
ClsCon.cmd.Parameters.AddWithValue("@User", ObjPlGroupTypeModel.User);
con = ClsCon.SqlConn();
ClsCon.cmd.Connection = con;
dtUpdGroupTypMaster = new DataTable();
ClsCon.da = new SqlDataAdapter(ClsCon.cmd);
ClsCon.da.Fill(dtUpdGroupTypMaster);
dtUpdGroupTypMaster.TableName = "success";
}
catch (Exception)
{
dtUpdGroupTypMaster = new DataTable();
dtUpdGroupTypMaster.TableName = "error";
return(dtUpdGroupTypMaster);
}
finally
{
con.Close();
con.Dispose();
ClsCon.da.Dispose();
ClsCon.cmd.Dispose();
}
return(dtUpdGroupTypMaster);
}
