private bool SaveData()
    {
        objCommon = new clsCommon();
        if (objCommon.IsRecordExists("tblSize", tblSize.ColumnNames.AppSize, tblSize.ColumnNames.AppSizeID, txtSize.Text, hdnPKID.Value))
        {
            DInfo.ShowMessage("Size is already exists", Enums.MessageType.Warning);
            return(false);
        }
        objSize = new tblSize();
        if (!string.IsNullOrEmpty(hdnPKID.Value) && hdnPKID.Value != "")
        {
            objSize.LoadByPrimaryKey(Convert.ToInt32(hdnPKID.Value));
        }
        else
        {
            objSize.AddNew();
        }

        objSize.s_AppSize   = txtSize.Text.Trim();
        objSize.AppIsActive = chkIsActive.Checked;
        if (chkIsDefault.Checked)
        {
            tblSize ObjTemp = new tblSize();
            ObjTemp.SetDefaultSize();
            ObjTemp              = null;
            objSize.AppIsActive  = true;
            objSize.AppIsDefault = true;
        }
        else
        {
            tblSize ObjTemp = new tblSize();
            ObjTemp.LoadAll();
            if (ObjTemp.RowCount <= 0)
            {
                objSize.AppIsActive  = true;
                objSize.AppIsDefault = true;
            }
            else
            {
                objSize.AppIsDefault = false;
            }
            ObjTemp = null;
        }


        objSize.Save();
        iprojectID   = objSize.AppSizeID;
        objSize      = null;
        objClsCommon = null;
        return(true);
    }
    public string GetSizeId(string strSizeName)
    {
        string  StrSize = "";
        tblSize objSize = new tblSize();

        objSize.Where.AppSize.Value = strSizeName;
        objSize.Query.Load();
        if (objSize.RowCount <= 0)
        {
            objSize.AddNew();
            objSize.s_AppSize    = strSizeName;
            objSize.AppIsActive  = true;
            objSize.AppIsDefault = false;

            objSize.Save();
        }

        StrSize = objSize.s_AppSizeID;
        objSize = null;

        return(StrSize);
    }