public worksheetmaster SelectById(Int64 id)
        {
            worksheetmaster objworksheetmaster = new worksheetmaster();

            try
            {
                Cls_worksheetmaster_db objCls_worksheetmaster_db = new Cls_worksheetmaster_db();

                objworksheetmaster = objCls_worksheetmaster_db.SelectById(id);
                return(objworksheetmaster);
            }
            catch (Exception ex)
            {
                //ErrHandler.writeError(ex.Message, ex.StackTrace);
                return(objworksheetmaster);
            }
        }
        public Int64 Update(worksheetmaster objworksheetmaster)
        {
            Int64 result = 0;

            try
            {
                Cls_worksheetmaster_db objCls_worksheetmaster_db = new Cls_worksheetmaster_db();

                result = Convert.ToInt64(objCls_worksheetmaster_db.Update(objworksheetmaster));
                return(result);
            }
            catch (Exception ex)
            {
                ////ErrHandler.writeError(ex.Message, ex.StackTrace);
                return(result);
            }
        }
        public DataTable SelectAll(worksheetmaster objworksheetmaster)
        {
            DataTable dt = new DataTable();

            try
            {
                Cls_worksheetmaster_db objCls_worksheetmaster_db = new Cls_worksheetmaster_db();

                dt = objCls_worksheetmaster_db.SelectAll(objworksheetmaster);
                return(dt);
            }
            catch (Exception ex)
            {
                //ErrHandler.writeError(ex.Message, ex.StackTrace);
                return(dt);
            }
        }