private bool IsExists(String existQuery)
        {
            DataSet ds = GF.GetDataFromDB(existQuery);

            if (ds != null && ds.Tables.Count > 0 && ds.Tables[0].Rows.Count > 0 && ds.Tables[0].Rows[0].ItemArray.GetValue(0) != DBNull.Value)
            {
                return(true);
            }
            else
            {
                return(false);
            }
        }
        private string getValueFromMaster(string MasterLookUpTable, string MasterIdField, string MasterLookUpField, string FieldValue)
        {
            DataSet ds;
            string  Query;

            Query = "select " + MasterIdField + " from " + MasterLookUpTable + " where " + MasterLookUpField + " = '" + FieldValue + "'";

            ds = GF.GetDataFromDB(Query);
            if (ds != null && ds.Tables.Count > 0 && ds.Tables[0].Rows.Count > 0)
            {
                if (ds.Tables[0].Rows[0].ItemArray.GetValue(0) != null)
                {
                    return(Convert.ToString(ds.Tables[0].Rows[0].ItemArray.GetValue(0)));
                }
                else
                {
                    return("null");
                }
            }
            return("null");
        }